NTSB investigations
3,368 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 CEN22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-10 · Beaver Dam, WIThe improperly secured spark plug boot that resulted in smoke in the cockpit and a subsequent off-airport landing.NTSB ERA22LA329Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Plant City, FLA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight fuel planning.NTSB CEN22LA343Accident · No injuriesClass 3 · LimitedFinal reportBeech E33A · Zena, OKThe pilot’s inadequate preflight inspection and fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA262Accident · No injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Three Forks, MTA loss of engine power due to degraded and incorrectly maintained ignition system components. Contributing to the accident was the pilot’s delay in turning the airplane towards the runway when the engine began to lose power.NTSB CEN22LA330Accident · No injuriesClass 3 · LimitedFinal reportBeech N35 · Wardsville, MOEngine failure due to oil starvation resulting from an oil leak at the improperly installed aftermarket oil filter adapter.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB CEN22LA320Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Kendleton, TXThe pilot’s improper in-flight planning and fuel management that resulted in the loss of engine power due to fuel exhaustion.NTSB ERA22LA326Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot’s loss of situational awareness (geographic position), which resulted in his inability to locate the intended landing runway and his decision to perform an off-airport landing.NTSB CEN22LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rogers, ARThe pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.NTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.NTSB ERA22LA298Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Akron, OHThe pilots’ improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.NTSB CEN22LA311Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOSport 2017 · Mead, OKA partial loss of engine power for reasons that could not be determined.NTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.NTSB CEN22LA283Accident · No injuriesClass 3 · LimitedFinal reportOsprey II · Bulverde, TXA loss of engine power due to fuel starvation due to a blockage of the fuel tank outlet port.NTSB GAA22WA214Accident · No injuriesClass 5 · ForeignCessna 182P · Benevides, BrazilNTSB ERA22LA309Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Lancaster, OHA partial loss of engine power due to the formation of carburetor ice.NTSB ERA22LA287Accident · Serious injuriesClass 3 · LimitedFinal reportMantell Allan T Lightning · Canandaigua, NYThe pilot’s performance of an off-airport landing shortly after takeoff for reasons that could not be determined.NTSB GAA22WA215Accident · Minor injuriesClass 4 · ForeignRobinson R44 · Rio das Ostras, BrazilNTSB WPR22LA219Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Davis, CAAn in-flight fire during the initial takeoff climb for reasons that could not be determined based on the available evidence.NTSB ERA22LA266Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Sarasota, FLThe pilot’s inadequate preflight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a loss of engine power on approach.NTSB WPR22LA213Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Auburn, WAA total loss of engine power due to fuel starvation.NTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.NTSB WPR22LA203Accident · No injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Hillsboro, ORA missing fuel filler cap O-ring, which resulted in a total loss of engine power due to water contamination in the fuel.NTSB WPR22LA202Accident · Minor injuriesClass 3 · LimitedFinal reportFischer Super Koala · Chelan, WAA total loss of engine power for undetermined reasons.NTSB ERA22LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 208 · Ellington, CTThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, an emergency landing, and runway excursion.NTSB ERA22LA258Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D1 · Pittsboro, NCThe student pilot, and flight instructor’s, inadequate preflight inspection, during which they failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB WPR22LA205Accident · No injuriesClass 4 · LimitedFinal reportBell HH-1H · Reno, NVThe pilot’s loss of control following the inadvertent placement of his foot behind the anti-torque pedal.NTSB ERA22LA254Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Tredyffin, PAThe loosening of the throttle arm from the throttle body, which resulted in the pilot’s inability to control the engine, and a subsequent forced landing.NTSB CEN22LA228Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Allport, ARA partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.NTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB WPR22FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna 172F · Show Low, AZThe pilot’s improper leaning of the engine during an extended period of time, which caused an exhaust valve to become stuck and led to the partial loss of engine power during the accident flight. Contributing to the accident was the pilot’s decision to…NTSB ERA22LA242Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7EC · Putnam Valley, NYA total loss of engine power during cruise flight due to fuel starvation resulting from obstructed forward and aft vent outlets in the left fuel tank.NTSB ERA22LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Caryville, FLAn in-flight loss of engine power on both engines for undetermined reasons.NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Marshall, OKThe pilot’s failure to manage fuel, which resulted in a loss of engine power to both engines due to fuel starvation.NTSB ERA22LA237Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA42 · Lehighton, PAThe flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.NTSB CEN22LA190Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · Houston, TXThe fixed-base operator’s incorrect fueling of the airplane, which resulted in a total loss of power in both engines.NTSB ERA22LA216Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA1 · Seneca, SCA dislodged air filter element, which restricted airflow to the carburetor resulting in a loss of engine power.NTSB CEN22LA189Accident · No injuriesClass 3 · LimitedFinal reportRaytheon A36 · Blanket, TXThe pilot’s failure to properly manage fuel while enroute, which resulted in a loss of engine power due to fuel starvation and a subsequent forced landing.NTSB ERA22LA200Accident · Serious injuriesClass 4 · LimitedFinal reportTitan T51 · Perry, FLThe pilot’s inadequate preflight inspection of the fuel quantity, which resulted in fuel exhaustion, a subsequent total loss of engine power, and an off-airport landing.NTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…NTSB WPR22LA152Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Balloons A55S · Safford, AZThe pilot’s decision to continue the balloon’s fast approach to an unsuitable confined landing site, which resulted in a collision with powerline wires.NTSB ERA22LA186Accident · Serious injuriesClass 3 · LimitedFinal reportHenry L Berrier JR Arion Lightning LS-1 · Mountain City, TNA total loss of engine power due to intermittent operation of both the engine-driven fuel pump and the electric boost pump. Contributing was the pilot’s delay in rejecting the takeoff, after the initial loss of engine power, which resulted in a collision with…NTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.NTSB ERA22LA174Accident · Minor injuriesClass 4 · LimitedFinal reportFpna A-22 Valor · Mascotte, FLThe pilot’s incorrect positioning of both wing fuel valves, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA172Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Melbourne, FLA loss of engine power due to oil starvation as a result of the failure of the No. 3 crankshaft journal bearing.NTSB ERA22LA168Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Myrtle Beach, SCVibration in the airframe and flight controls for reasons that could not be determined based on the available evidence.