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 WPR15LA003Accident · No injuriesLimited investigationFinal reportCorben Baby Ace D · Lincoln, CAThe total loss of engine power due to fuel starvation, which resulted from debris restricting the fuel flow within the fuel system.NTSB ERA15LA006Accident · Serious injuriesLimited investigationFinal reportSocata TBM 700 · Fayetteville, GAThe pilot’s inadvertent deactivation of the yaw damper in flight, which resulted in a prolonged side-slip condition that led to fuel starvation and the eventual total loss of engine power. Contributing to the accident was the pilot’s failure to attempt to…NTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.NTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.NTSB ERA15FA003Accident · 1 fatalField investigationFinal reportMiller Raymond A Sonex Waiex · Palm Coast, FLA total loss of engine power during cruise flight for reasons that could not be determined due to the postaccident condition of the engine and its associated fuel and ignition systems.NTSB CEN15LA002Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodsboro, TXThe pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.NTSB CEN14LA526Accident · Serious injuriesLimited investigationFinal reportPreiss Vans RV-9A · Hobart, OKA loss of engine power due to fuel exhaustion, which resulted from the pilot's erroneous preflight fuel calculations and inadequate in-flight fuel management.NTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.NTSB WPR14CA389Accident · No injuriesData collectionFinal reportPiper PA25 - 260 · Mokuleia, HIThe pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC14LA085Accident · No injuriesLimited investigationFinal reportCessna TU206 · Deadhorse, AKThe application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.NTSB ERA14LA451Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Homosassa, FLA partial loss of engine power for reasons that could not be determined because engine examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB ERA14LA446Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Piscataquis County, METhe fatigue fracture of the No. 3 exhaust valve, which initiated at the outer surface of the valve stem and resulted in the subsequent total loss of engine power over terrain unsuitable for landing.NTSB CEN14LA519Accident · No injuriesLimited investigationFinal reportPiper PA 36-285 · Woodburn, INA loss of engine power during takeoff for reasons that could not be determined based on the available information.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.NTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB WPR14LA394Accident · No injuriesLimited investigationFinal reportLorentzen Lancair Legacy · Reno, NVThe shearing of mounting bolts that attached the right turbocharger to its mounting bracket during an air race, which resulted in hot exhaust gases leaking into the engine compartment and starting a fire.NTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.NTSB ERA14LA434Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Spruce Creek, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilots’ improper preflight and in-flight fuel planning.NTSB CEN14LA495Accident · No injuriesLimited investigationFinal reportNolin Vans RV-10 · Houston, TXThe total loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA14CA426Accident · Serious injuriesData collectionFinal reportSchleicher ASW 19B · Avoca, NYThe pilot's decision to attempt a return to his departure airport which resulted in the glider's encounter with atmospheric conditions where the lift was not sufficient to maintain flight and an off-airport landing.NTSB CEN14LA486Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Langola Township, MNMaintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.NTSB ERA14LA425Accident · Minor injuriesLimited investigationFinal reportNavion Navion · Rock Hill, SCThe pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.NTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.NTSB CEN14LA472Accident · No injuriesLimited investigationFinal reportOhlgren Brent E RV-6A · Marshalltown, IAA loss of engine power due to fuel exhaustion as a result of the pilot's misjudgment of the amount of fuel onboard prior to flight.NTSB CEN14FA468Accident · 2 fatalField investigationFinal reportSchafer Rick W Foxtrot 4 · Abilene, TXThe pilot's decision to attempt a steep turn to return to the airport after reporting an emergency. The reason for the emergency could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that…NTSB ERA14LA411Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Creedmoor, NCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s impairment due to alcohol ingestion.NTSB CEN14LA461Accident · No injuriesLimited investigationFinal reportCessna 310K · El Dorado, KSA fatigue failure of the left engine’s throttle cable, which resulted in the loss of left engine power.NTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.NTSB ERA14LA404Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Gaithersburg, MDThe loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.NTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.NTSB ERA14LA402Accident · Minor injuriesLimited investigationFinal reportThibault Michael L RV4 · Polk Township, PAA total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB ERA14LA401Accident · No injuriesLimited investigationFinal reportCessna 150G · Pittstown, NJA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA479Accident · No injuriesData collectionFinal reportQuicksilver 2S · Frontenac, MNThe loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.NTSB CEN14LA439Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Wray, COA loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…NTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB ANC14LA065Accident · No injuriesLimited investigationFinal reportTerry W. Thayer Zenith Stol CH701 · Nikiski, AKThe pilot’s improper positioning of the fuel selector valves, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow preflight checklists.NTSB ERA14LA392Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Itta Bena, MSA total loss of engine power during maneuvering due to an obstruction from air intake filter material being ingested into the carburetor, which resulted in a forced landing.NTSB ERA14LA389Accident · Minor injuriesLimited investigationFinal reportCessna T206H · Wiggins, MSA loosening of the engine throttle cable from its support clamp during flight, which resulted in a loss of throttle control.NTSB ERA14LA388Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Buffalo, NYA total loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine test run revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN14LA425Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Braithwaite, LAThe pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.NTSB ERA14LA383Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S · Sarasota, FLA total loss of engine power due to fuel exhaustion, which resulted from the flight instructor's inadequate preflight fuel planning.NTSB WPR14LA340Accident · No injuriesLimited investigationFinal reportHughes 269C · Darrington, WAMaintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.NTSB WPR14LA337Accident · No injuriesLimited investigationFinal reportRyan Navion · Fresno, CAA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA14LA382Accident · Minor injuriesLimited investigationFinal reportJackson Jeremiah D Vans RV6A · West Palm Beach, FLThe pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…NTSB ERA14LA378Accident · Minor injuriesLimited investigationFinal reportBirchler Boyd Eagle 540 · Standish, METhe total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14CA482Accident · No injuriesData collectionFinal reportBeech 95 B55 (T42A) · Bremond, TXMismanagement of fuel, which resulted in a total loss of power due to fuel starvation.NTSB WPR14CA333Accident · Minor injuriesData collectionFinal reportKitfox Series 5 · Kamiah, IDA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel shutoff valves for each fuel tank before takeoff.NTSB CEN14LA412Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28F · Tomah, WIA loss of engine power due to the malfunction of the No. 4 cylinder intake valve.