NTSB investigations
3,371 cases where the sequence of events included Off-field or emergency landing.
Cases, newest first
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…NTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.NTSB ERA14WA245Accident · Minor injuriesForeign investigationCessna T188C · Canton Naranjal, EcuadorOn March 13, 2014, a Cessna T188C, Ecuadorian registration HC-BTA, was substantially damaged when it lost engine power and impacted terrain near Canton Naranjal, Ecuador. A postaccident fire ensued. The foreign certificated pilot received minor injuries. The…NTSB WPR14LA153Accident · No injuriesLimited investigationFinal reportZenair CH2T · Woodland, CAA total loss of engine power during approach due to carburetor icing, which resulted in an off-airport landing into trees.NTSB ERA14LA142Accident · No injuriesLimited investigationFinal reportCessna 172R · Jackson, TNA total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.NTSB ERA14LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJA partial loss of engine power at takeoff for reasons that could not be determined during a postaccident examination or engine test run.NTSB WPR14LA118Accident · No injuriesLimited investigationFinal reportCessna P210N · Bountiful, UTFuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.NTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.NTSB CEN14LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Church Point, LAThe pilot’s improper preflight inspection and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR14CA115Accident · No injuriesData collectionFinal reportBell 47G 5A · Greenfield, CAThe pilot's failure to maintain clearance from a power pole during low-altitude maneuvering flight.NTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.NTSB CEN14IA139Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Gunnison, COThe pilot's improper decision to initiate the flight into an area with forecast icing conditions, which resulted in an encounter with in-flight icing conditions that prevented the airplane from being able to maintain altitude.NTSB ERA14CA118Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Sussex, NJThe pilot's improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Millen, GAThe pilot's failure to fully seat the fuel selector in the left tank position before takeoff, which resulted in fuel starvation and a subsequent loss of engine power.NTSB ERA14CA104Accident · No injuriesData collectionFinal reportMooney M20C · Rutherfordton, NCThe pilot's inadequate pre-flight planning and in-flight monitoring of the fuel level which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14LA131Accident · No injuriesLimited investigationFinal reportCessna R182 · Eustis, NEA catastrophic engine failure, which was initiated by the failure of the No. 5 connecting rod cap.NTSB CEN14LA120Accident · No injuriesLimited investigationFinal reportCessna 414A · Ashland, MOThe in-flight failure of both engines due to water contamination.NTSB CEN14LA118Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5B · Willow Park, TXThe improper reinstallation of the propeller assembly, which resulted in the subsequent in-flight separation of the propeller.NTSB WPR14FA091Accident · Minor injuriesField investigationFinal reportCirrus Design SR22 · Pocatello, IDThe distributor gear teeth failure of the right magneto that resulted in severe engine vibration and partial loss of engine power, which progressively led to the failure of the left magneto distributor drive gear teeth. Contributing to the airplane’s…NTSB ERA14WA090Incident · No injuriesForeign investigationPiper PA-32RT-300T · Margarita, VenezuelaOn January 5, 2014, about 1900 universal coordinated time, a Piper PA-32RT-300T, Venezuelan registration YV2070, operated by a private individual, made an emergency landing on a road due a total loss of engine power. The pilot was not injured. The flight…NTSB ERA14LA089Accident · No injuriesLimited investigationFinal reportFK Lightplanes FK9 ELA SW · Canton, GAA partial loss of engine power during cruise flight due to an overly lean fuel-air mixture, which resulted from an incorrectly installed float chamber vent line and led to a subsequent off-airport landing.NTSB ERA14LA086Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Buckhannon, WVThe pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.NTSB ERA14LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bronx, NYThe total loss of engine power due to fuel starvation for reasons that could not be determined during postaccident engine examination or testing.NTSB CEN14LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Forsyth, MOThe pilot's improper flight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Alabaster, ALThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN14LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gladewater, TXThe loss of engine power due to carburetor icing.NTSB WPR14LA079Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Lodi, CAThe fatigue failure of the crankshaft, which resulted in a total loss of engine power and subsequent forced landing.NTSB ERA14LA076Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Tampa, FLA total loss of engine power due to the fatigue failure of the No. 4 connecting rod. Contributing to the accident was a likely loss of lubrication for reasons that could not be determined during a postaccident engine examination.NTSB ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…NTSB ERA14LA072Accident · No injuriesLimited investigationFinal reportCessna 182T · Burlington, NCA loss of airplane control during takeoff for reasons that could not be determined due to the postaccident condition of the elevator control system.NTSB CEN14LA081Accident · No injuriesLimited investigationFinal reportRockwell International 112 · Hammond, LAThe total loss of engine power due to oil starvation because of a fractured governor oil line, which resulted from the improper installation of the governor oil line assembly during the last oil line replacement.NTSB WPR14CA066Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Monticello, UTThe passenger's accidental discharge of the net gun which resulted in the net going through a main rotor blade.NTSB ERA14FA066Accident · 1 fatalField investigationFinal reportTexas Helicopter M74L · Sebring, FLA partial loss of engine power as a result of contamination of the engine’s fuel supply, and the pilot’s impaired performance due to his use of diphenhydramine, which resulted in his inability to complete a forced or precautionary autorotative landing…NTSB ANC14CA010Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Soldotna, AKThe operation of the airplane by the uncertificated student pilot, his failure to recognize conditions conducive to structural icing, and subsequent decision to depart in conditions conducive to structural icing, resulting in a severe icing encounter and…NTSB ERA14LA059Accident · Minor injuriesLimited investigationFinal reportMoffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SCThe airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.NTSB ERA14LA052Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Trussville, ALThe failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.NTSB ERA14LA051Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Montrose, PAThe pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.NTSB WPR14CA058Accident · No injuriesData collectionFinal reportQuad City Ultralight Acft Challenger II · Kalispell, MTA loss of engine power due to the spark plug coming out of the cylinder head.NTSB ERA14LA048Accident · No injuriesLimited investigationFinal reportCessna 150L · Hopewell, ALA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight inspection and preflight and inflight fuel planning that did not account for increased headwind.NTSB WPR14LA056Accident · No injuriesLimited investigationFinal reportCessna T210 - F · Oceanside, CAThe pilot's failure to determine the actual onboard fuel quantity before beginning the flight, which resulted in a complete loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's habitual reliance solely on the cockpit fuel…NTSB WPR14LA055Accident · Serious injuriesLimited investigationFinal reportRichard S Duncan Avid Flyer · Lakeside, ORThe pilot/owner’s failure to comply with the engine manufacturer’s maintenance guidance, which resulted in the total loss of engine power due to the fracture failure of the plastic drive gear for the engine lubricating oil pump.NTSB ERA14LA043Accident · Serious injuriesLimited investigationFinal reportMaule M-5-180C · Marshfield, MAA partial loss of engine power for reasons that could not be determined in postaccident examinations because fire damage precluded testing of the fuel and several engine accessories.NTSB ERA14LA042Accident · No injuriesLimited investigationFinal reportPiper PA28 · Homestead, FLA total loss of engine power due to the in-flight separation of the No. 3 cylinder because of the fatigue cracking of its respective mounting studs and through bolts, which resulted from inadequate maintenance by unknown personnel.NTSB ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNTSB CEN14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 28-150 · Concordia, KSThe flight instructor’s improper decision to attempt a climb with an excessive pitch attitude for the tailwind condition and flap setting, which resulted in an approach to stall and subsequent off-field landing.NTSB ERA14LA034Accident · Minor injuriesLimited investigationFinal reportTeal Harry H Sonerai II Stretch · De Leon Springs, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of preexisting mechanical anomalies or failures that would have precluded normal operation.NTSB CEN14LA033Accident · No injuriesLimited investigationFinal reportClevenger Jimmie B Pitts S 1S · Wellington, KSThe loss of engine power due to a malfunctioning fuel pump.NTSB WPR14LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Scipio, UTA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA094Accident · No injuriesLimited investigationFinal reportCessna 150H · Livingston, ALThe pilot's inadequate soft-field technique during the precautionary landing, which resulted in a nose-over. Contributing to the accident was the pilot's inadequate preflight inspection, which resulted in departure with an open fuel port and the subsequent…NTSB CEN14TA020Accident · Minor injuriesFinal reportBell OH-58A · Jefferson City, MOThe loss of engine power for reasons that could not be determined because postaccident examinations of the engine did not reveal any anomalies that would have precluded normal operation.