Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.aircraft_model_code IN ('2075901')
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2075901')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA25WA005Accident · 3 fatalClass 5 · ForeignCessna 404 · Les Cayes, HaitiNTSB WPR21LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna 404 · Sheridan, WYThe pilot experiencing an episode of impaired behavior and incapacitation for reasons that could not be determined based on the available information.NTSB CEN15FA090Accident · 1 fatalField investigationFinal reportCessna 404 · Englewood, COThe loss of power to the right engine for reasons that could not be determined during postaccident examination and teardown and the pilot’s failure to properly configure the airplane for single-engine flight.NTSB ERA10TA215Accident · No injuriesFinal reportCessna 404 · Ponce, PRA loss of power to the right engine for undetermined reasons.NTSB CEN09CA343Accident · No injuriesData collectionFinal reportCessna 404 · Englewood, COThe failure of the landing gear to extend due to the failure of a hydraulic line.NTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.NTSB CHI00LA114Accident · No injuriesLimited investigationFinal reportCessna 404 · Lansing, MIA loss of engine power due to improper fuel. Also causal was the improper aircraft service by the fixed base operator personnel and the unsuitable terrain for the forced landing encountered by the pilot. Factors were the improper grade of fuel and the lack of…NTSB CHI96LA266Accident · Serious injuriesLimited investigationFinal reportCessna 404 · Benton Harbor, MIthe pilot's delay in initiating a go-around after not attaining the proper touchdown point during the landing, and his failure to remain clear of obstructions (trees) during the go-around. Factors relating to the accident were the adverse weather condition…NTSB MIA95TA199Accident · No injuriesFinal reportCessna 404 · Raiford, FLThe pilot's selection of unsuitable terrain for landing.NTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.NTSB CHI94LA052Accident · No injuriesLimited investigationFinal reportCessna 404 · Big Rapids, MIThe pilot's descent below the minimum descent altitude.NTSB BFO93LA121Accident · No injuriesLimited investigationFinal reportCessna 404 · Cincinnati, OHThe failure of a number three engine cylinder hold down bolt due to fatigue.NTSB NYC91LA027Accident · No injuriesLimited investigationFinal reportCessna 404 · Pittsburgh, PAA failure of nose landing gear retraction cylinder attach points which allowed the nose landing gear to collapse.NTSB DEN90LA056Accident · No injuriesLimited investigationFinal reportCessna 404 · Englewood, COThe collapse of the nose gear assembly for undetermined reasons.NTSB MIA90LA056Accident · Minor injuriesLimited investigationFinal reportCessna 404 · Boca Raton, FLLoss of power in the right engine due to a disconnected duct between the turbocharger and the plenum chamber. The reason for the loss of power in the left engine was not determined.NTSB DEN88FA126Accident · Serious injuriesField investigationFinal reportCessna 404 · Denver, COThe plt was on a flt from greeley to Denver, Colorado to obtain minor maint on a cargo door. As the acft was being vectored on final apch, the plt rprtd that he believed the acft had fuel starvation. Subsequently, the acft was observedto make a complete roll…NTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…NTSB CHI86FA036Accident · No injuriesField investigationFinal reportCessna 404 II · Chicago, ILThe tug driver with baggage cart failed to yield to a taxiing acft when crossing an active taxiway. It was dark nite. Acft had position/taxi lites on. Vehicle stop sign to taxi centerline is 70 ft. driver said he stopped at sign. Tug struck rt wg tip, wg…NTSB ATL85LA273Accident · 1 fatalLimited investigationFinal reportCessna 404 · Hayesville, NCFisherman heard an aircraft overhead but did not see any sign of it in the night sky. Shortly thereafter they saw a flash and fire on the side of a mountain, then they heard the explosion. The sheriff was called and an investigation revealed a crashed…NTSB ATL85LA262Accident · No injuriesLimited investigationFinal reportCessna 404 · Huntington, WVSeveral men who were in a building at the airport reported that they could hear the aircraft on the approach and then a loud noise. They could not see the runway or the aircraft due to the fog. They got in the fire and rescue vehicles and had a hard time…NTSB CHI85FA351Accident · 1 fatalField investigationFinal reportCessna 404 · South Lyon, MIThe acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and…NTSB ATL82IA139Incident · No injuriesIncident investigationFinal reportCessna 404 · Charlotte, NCDuring takeoff, the hydraulic pressure was lost after the gear was raised and the flaps were being retracted. The pilot attempted to extend the gear with both the normal and manual systems, but to no avail. Subsequently, a gear up landing was made. An…NTSB CHI82FA059Accident · No injuriesField investigationFinal reportCessna 404 · Oshkosh, WIThe right main gear collapsed on landing. Investigation revealed that the rear trunnion pivot pin, P/N5741112-1, had moved aft & out of the trunnion. The pin had about 1 inch of white paint on the end of the pin that extended into the flap track area. The…NTSB ATL81FLA12Accident · No injuriesClosedCessna 404 · St Simons Is, GANTSB LAX81FA077Accident · Serious injuriesClosedCessna 404 · Burbank, CANTSB MIA81FA011Accident · 1 fatalClosedCessna 404 · Gowers Corner, FLNTSB MIA80FA086Accident · 2 fatalClosedCessna 404 · Ft White, FLNTSB FTW80FA068Accident · 1 fatalClosedCessna 404 · New Orleans, LANTSB MIA80FKT45Accident · Serious injuriesClosedCessna 404 · Miami, FLNTSB ANC80FA040Incident · No injuriesClosedCessna 404 · Anchorage, AKNTSB MIA79FA132Accident · 1 fatalClosedCessna 404 · Ft.Lauderdale, FLNTSB IAD79IA003Incident · No injuriesClosedCessna 404 · Covington, KYNTSB IAD78FA064Accident · No injuriesClosedCessna 404 · Covington, KYNTSB DEN78FTE28Accident · Serious injuriesClosedCessna 404 · Englewood, CONTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYNTSB NYC68D0389Accident · No injuriesClosedCessna 320E · North Adams, MA
Back to Cessna 404