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 CEN13CA206Accident · No injuriesData collectionFinal reportCessna T206H · Sabinal, TXThe pilot’s failure to properly identify the airstrip, which resulted in him landing the airplane off of the airstrip in soft soil causing the nose over.NTSB CEN13LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Forrest City, ARThe in-flight separation of the left aileron's push-pull rod and hardware. Contributing to the accident was the failure of maintenance personnel to apply proper torque to the self-locking nuts.NTSB CEN13LA155Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Tulsa, OKThe line technician’s failure to remove the refueling mat from the helicopter fuselage following servicing, which resulted in the mat striking the tail rotor in flight, and the pilot’s inadequate preflight inspection.NTSB ERA13LA126Accident · No injuriesLimited investigationFinal reportMccowan Steve A Shttd · Montrose, GAA total loss of engine power during cruise flight due to the separation of the No. 2 piston connecting rod.NTSB WPR13LA108Accident · No injuriesLimited investigationFinal reportCessna 175B · Wellsville, UTA loss of engine power during cruise flight due to carburetor ice.NTSB WPR13LA109Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bountiful, UTA total loss of engine power during initial climb 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 CEN13LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Victoria, TXThe mechanical failure of the engine power section, which resulted in a loss of engine power.NTSB ERA13LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Yonkers, NYA partial loss of engine power for reasons that could not be determined because examination of the engine and associated components did not reveal any mechanical malfunction or failure that would have precluded normal operation.NTSB ERA13LA119Accident · Serious injuriesLimited investigationFinal reportShoemaker James B KR-2 · Palmetto, FLThe total loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB WPR13LA101Accident · No injuriesLimited investigationFinal reportCessna 150L · Matlock, WAA partial loss of engine power after a descent to a lower altitude due to the student pilot's delayed action in applying carburetor heat while operating in conditions conducive to carburetor icing.NTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.NTSB WPR13LA102Accident · No injuriesLimited investigationFinal reportCessna 172RG · Redmond, ORFailure of the left main landing gear pivot assembly during the landing approach.NTSB WPR13LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rock Springs, WYThe pilot's inadvertent movement of the fuel selector valve beyond its tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector interlock mechanism.NTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…NTSB ERA13LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Winder, GAA total loss of engine power due to a cracked fuel pump line fitting O-ring seal at the inlet to the engine driven fuel pump. Contributing to the accident was the failure of the aircraft operator to comply with the engine manufacturer’s recommended time…NTSB ERA13LA112Accident · No injuriesLimited investigationFinal reportCessna T182 · Brandon, FLFailure of the No. 2 cylinder’s rod bearing, which resulted in a total loss of engine power.NTSB CEN13CA134Accident · No injuriesData collectionFinal reportMooney M20C · Moriarty, NMThe pilot’s improper fuel management, which resulted in a loss of engine power during cruise flight due to fuel starvation.NTSB WPR13LA087Accident · Serious injuriesLimited investigationFinal reportBell OH-58C · Riverdale, CAA flight control malfunction while maneuvering for reasons that could not be determined because it was not possible to establish whether observed damage to the flight control assembly was the result of wreckage recovery efforts or a preexisting condition.NTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.NTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.NTSB CEN13CA124Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Menard, TXThe helicopter landed hard during a forced landing.NTSB ERA13FA096Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Leesburg, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of power in both engines during cruise flight. Contributing to the accident was the pilot’s use of prescription and illicit drugs, which likely impaired…NTSB ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB ERA13LA094Accident · No injuriesLimited investigationFinal reportWragg George Skybolt · Sarasota, FLThe pilot's inadequate preflight planning and failure to monitor the fuel quantity during flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.NTSB ERA13LA084Accident · Minor injuriesLimited investigationFinal reportMerritt Leslie R Kelly D · Brandon, MSA total loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA097Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Moody, TXThe total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb 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 CEN13LA095Accident · No injuriesLimited investigationFinal reportMooney M20E · Gurdon, ARThe total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.NTSB ERA13LA072Accident · Serious injuriesLimited investigationFinal reportHansen David Daniel RV-4 · Carthage, NCA partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…NTSB CEN13FA080Accident · Minor injuriesField investigationFinal reportCessna 208B · Bryans Corner, OKThe total loss of engine power as a result of a fractured compressor turbine blade due to fatigue cracking.NTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.NTSB CEN13LA076Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lansing, MIA loss of engine power due to the loss of fuel flow through the airplane's fuel tank selector valve.NTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.NTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…NTSB ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.NTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.NTSB ERA13LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canton, GAA partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.NTSB ERA13LA053Accident · No injuriesLimited investigationFinal reportCessna 210 · Jasper, GAA loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…NTSB ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.NTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.NTSB CEN13FA049Accident · 1 fatalField investigationFinal reportCessna 208B · Wichita, KSThe total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.NTSB ERA13LA045Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alexander City, ALThe pilot’s delayed decision to initiate an autorotation and her subsequent improper conduct of the autorotation, which resulted in a hard landing, after the helicopter started vibrating for reasons that could not be determined because postaccident…NTSB ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…NTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.NTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.