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 ('207590C')
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 ('207590C')
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 CEN25LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 401 · Arlington, TXThe failure of the left landing gear system and subsequent intentional gear up landing.NTSB CEN12FA290Accident · 4 fatalField investigationFinal reportCessna 401 · Chanute, KSThe malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…NTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB CHI04LA264Accident · Minor injuriesLimited investigationFinal reportCessna 401 · New Century, KSA loss of engine power due to fuel starvation and the pilot's failure to maintain directional control during approach to an alternate airport. Contributing to the accident was the pilot's failure to obtain a weather briefing, his flight into adverse weather,…NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB FTW03LA075Accident · No injuriesLimited investigationFinal reportCessna 401 · Mc Allen, TXThe pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend.NTSB FTW98LA389Accident · No injuriesLimited investigationFinal reportCessna 401 · Lancaster, TXThe pilot's inadvertent retraction of the landing gear while intending to retract the flaps. A factor was the pilots lack of total experience in the type of aircraft.NTSB CHI97FA059Accident · Minor injuriesField investigationFinal reportCessna 401 · Crystal, MNfailure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.NTSB FTW95FA319Accident · No injuriesField investigationFinal reportCessna 401 · Dallas, TXFailure of the flightcrews of the Boeing 737, N675AA, and the Cessna 401, N31DB, to see and avoid each other. Factors were: the failure of 737 flightcrew to respond to the traffic advisory given by the ground controller identifying potentially conflicting…NTSB MIA93WA113Accident · No injuriesForeign investigationCessna 401 · Middle Caicos, Turks & Caicos IslandsNTSB MIA92FA114Accident · 1 fatalField investigationFinal reportCessna 401 · New Port Richey, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering for a forced landing following an in flight left engine fire for undetermined reasons. Contributing to the accident was the pilot in command's inadvertent shutdown of the wrong engine.NTSB ATL91LA172Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Jackson, TNThe pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.NTSB ATL91FA148Accident · 1 fatalField investigationFinal reportCessna 401 · Monroe, NCInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. The pilot's lack of familiarity with the aircraft fuel system was a related factor.NTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.NTSB CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.NTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.NTSB MIA89WA212Accident · 1 fatalForeign investigationCessna 401 · Grand Turk Isl., Turks & Caicos IslandsNTSB ATL89LA169Accident · No injuriesLimited investigationFinal reportCessna 401 · Raleigh, NCImproper maintenance by other maintenance personnel and excessive fuel pressure to the right engine (rich mixture). A possible contributing factor was the worn/unserviceable internal lock nut in the fuel pump.NTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…NTSB SEA87MA018Accident · 2 fatalMajor investigationFinal reportCessna 401 · Henderson, NVApproximately 5 1/2 minutes after departure and while the aircraft was climbing enroute, an unknown ignition source triggered an explosion of fuel/air vapor which existed within the interior of the left wing. Wing skin from the upper/lower wing surface was…NTSB DEN86FA099Accident · Serious injuriesField investigationFinal reportCessna 401 · Silver City, NMThe 2 com rated plts were returning from a part 135 flt at night. The fuel tanks were inadvertently not switched from mains to aux. Fuel starvation occurred when acft was at low altitude. Insufficient altitude remained to restart the engines. Acft impacted…NTSB CHI86LA085Accident · No injuriesLimited investigationFinal reportCessna 401B · Milwaukee, WIWhile taxiing to park, the left main landing gear collapsed. Investigation revealed that the left hand gear support had torn from the wing rib to which it was bolted. On the FAA malfunction or defect report submitted by the operator, company officials stated…NTSB MIA86FA071Accident · No injuriesField investigationFinal reportCessna 401 · Parkland, FLThe plt stated that due to a miscalculation of his fuel supply, his loss of power was a result of fuel exhaustion.NTSB SEA86FA046Accident · 3 fatalField investigationFinal reportCessna 401 · S. Lake Tahoe, CAAcft took off in clear wx but below-freezing temps with heavy frost on acft surfaces. No preflight, run-up or warm-up performed. On initial climb, left eng power loss occurred for undet reason, but probably associated with temp/cold eng operation. Plt turned…NTSB BFO85LA076Accident · No injuriesLimited investigationFinal reportCessna 401 · Cheswold, DEAfter landing on runway 27, the pilot slowed the aircraft to approximately 30 mph. The aircraft had rolled out about 1000 feet when the gear horn sounded and all three landing gear collapsed. The pilot reached for the gear switch, which was in the up…NTSB MKC84LA238Accident · No injuriesLimited investigationFinal reportCessna 401 · Hutchinson, KSWhile taxiing for takeoff the plt turned from the taxiway onto the rwy & the left main gear collapsed. Post crash examination of the left gear revealed that the ldg gear wing rib support bracket failed allowing the gear to collapse. A Cessna service letter…NTSB MKC84LA117Accident · No injuriesLimited investigationFinal reportCessna 401 · Wichita, KSThe plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had…NTSB CHI84LA130Accident · No injuriesLimited investigationFinal reportCessna 401 · Chicago, ILThe acfts left main gear collapsed during the landing roll. Investigation revealed that the bolt on the top portion of the LH bellcrank assembly was sheared off. One of the tangs at the bottom of the bellcrank was also broken. When examined under a 10 power…NTSB ANC83IA053Incident · No injuriesIncident investigationFinal reportCessna 401 · Bethel, AKThe acft right engine started emitting sparks from the cowling during normal cruise. The pilot noted a drop in manifold pressure so he reduced power on that engine and the sparks stopped. The acft was landed at Bethel. The fire dept. Used a fire extinguishing…NTSB LAX83FA082Accident · No injuriesField investigationFinal reportCessna 401 · Lompoc, CAThe acft went off the left side of the runway during landing after the left main landing gear collapsed. This was an airtaxi flight and one of the passengers confirmed that all 3 landing gear green lights were illuminated. Examination of the left main gear…NTSB FTW82DA344Accident · No injuriesFinal reportCessna 401A · Silver City, NMThe aircraft was being flown to check it after some minor maintenance had been performed. During the takeoff roll at about 84 KTS, the pilot noted a drop in the fuel flow to the right engine, followed by a loss of power on the right side. He aborted the…NTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…NTSB ATL82FA052Accident · No injuriesField investigationFinal reportCessna 401 · Jessup, GAAfter reaching a cruise altitude of 9500 feet the pilot noticed smoke coming out of the left engine cowling. He then proceeded to reduce the left throttle but was unable to move the lever. According to the pilot the fire was extinguished when the left fuel…NTSB FTW82DPJ07Accident · No injuriesClosedCessna 401 · Oklahoma City, OKNTSB CHI81FA070Accident · 5 fatalClosedCessna 401 · Muskegon, MINTSB FTW80FA114Accident · 1 fatalClosedCessna 401 · Houma, LANTSB MKC80FA043Accident · Serious injuriesClosedCessna 401A · Spirit Lake, IANTSB MIA80DLD63Accident · No injuriesClosedCessna 401 · Oklawaha, FLNTSB LAX80DVG19Accident · No injuriesClosedCessna 401 · Davis, CANTSB MIA79FA120Accident · No injuriesClosedCessna 401 · Tuscaloosa, ALNTSB MKC79FA044Accident · No injuriesClosedCessna 401 · St.Louis, MONTSB MIA78FLG07Accident · No injuriesClosedCessna 401 · Spartanburg, SCNTSB MIA78FKT22Accident · Serious injuriesClosedCessna 401 · W.Palm Beach, FLNTSB FTW77DPG18Accident · No injuriesClosedCessna 401 · Pine Bluff, ARNTSB MIA77FLD24Accident · Minor injuriesClosedCessna 401 · Tampa, FLNTSB FTW76AF011Accident · 3 fatalClosedCessna 401 · Austin, TXNTSB LAX75OL015Accident · 3 fatalClosedCessna 401 · Los Mochis, MexicoNTSB MKC74DCJ27Accident · No injuriesClosedCessna 401 · Hyannis, NENTSB FTW74FRG46Accident · No injuriesClosedCessna 401 · San Antonio, TX
Back to Cessna 401