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 GAA18CA240Accident · No injuriesData collectionFinal reportBrown Joseph Sportsman GS-2 · Kalispell, MTThe pilot’s selection of an unsuitable snow-covered airstrip for landing, which resulted in a nose-over.NTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.NTSB CEN18LA146Accident · Minor injuriesLimited investigationFinal reportCessna T303 · Pine Ridge, SDThe airplane’s inadvertent encounter with severe icing conditions during descent, which resulted in structural icing, the pilot’s inability to maintain altitude, and an emergency landing. Contributing to the accident was an incomplete preflight weather…NTSB GAA18CA220Accident · No injuriesData collectionFinal reportPiper PA 22 · Shelby, MTThe pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.NTSB CEN18LA142Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado Springs, COThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA 24 · New Braunfels, TXA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA113Accident · No injuriesLimited investigationFinal reportFairchild Funk M62C F 23A · Columbia, TNThe pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power.NTSB CEN18LA125Accident · Minor injuriesLimited investigationFinal reportCub Crafters PA18 150 · Beggs, OKThe pilot's failure to verify that the fuel selector was properly set before takeoff, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR18LA111Accident · No injuriesLimited investigationFinal reportPflugradt Kitfox · Clatskanie, ORA partial loss of engine power due to an improperly secured throttle cable set screw.NTSB ERA18LA110Accident · Minor injuriesLimited investigationFinal reportBesarick Skybolt · Punta Gorda, FLA substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod.NTSB ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA18LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Key West, FLA partial loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN18LA124Accident · Serious injuriesLimited investigationFinal reportWhite Thorpe T 18 · Cleburne, TXThe loss of engine power due to fuel exhaustion.NTSB ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.NTSB ERA18MA099Accident · 5 fatalClass 1 · MajorFinal reportAmerican Eurocopter AS350B2 · New York, NYLiberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…NTSB CEN18LA119Accident · Serious injuriesClass 2 · LimitedFinal reportCzech Sport Piper Sport · Addison, TXThe operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock.NTSB CEN18LA118Accident · Minor injuriesLimited investigationFinal reportBereznak Lancair Legacy · Temple, TXThe failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation.NTSB GAA18CA160Accident · No injuriesData collectionFinal reportCessna 172 · England, ARThe pilot’s failure to detect water in the fuel system during the preflight inspection, which resulted in a loss of engine power during departure and a subsequent impact with terrain.NTSB CEN18LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Sinton, TXThe inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing.NTSB CEN18LA113Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Deport, TXA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot/owner's inadequate maintenance of the fuel caps.NTSB WPR18CA096Accident · Serious injuriesData collectionFinal reportBell 47G · Pixley, CAA total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…NTSB GAA18CA140Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Woodland, CAThe pilot’s distraction due to her malfunctioning iPad, which led to her inadvertent forward cyclic application.NTSB CEN18LA117Accident · No injuriesLimited investigationFinal reportBlack Donald Cozy III · Los Lunas, NMThe seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB CEN18LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Patterson, LAThe pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion.NTSB GAA18CA124Accident · No injuriesData collectionFinal reportCessna 150 · El Dorado, KSThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport landing and nose-over.NTSB ERA18TA076Accident · No injuriesFinal reportVertical Aviation Technologies 260L Hummingbird · Harrisville, NYThe failure of an electric fuel pump, which resulted in fuel starvation and a total loss of engine power during cruise flight.NTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA085Accident · No injuriesLimited investigationFinal reportQuartz Mountain Aerospace L-11E · Omaha, NEThe instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.NTSB CEN18LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBryk Steven L Velocity XL RG · Santa Fe, NMThe airplane’s inadvertent encounter with unforecasted icing conditions during cruise flight, which resulted in the accumulation of airframe icing, the airplane’s inability to maintain altitude, and a subsequent forced landing on rough terrain.NTSB CEN18LA076Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Longmont, COA total loss of engine power for reasons that could not be determined because a postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-236 · Tishomingo, OKThe pilot’s inadequate preflight fuel planning and in-flight fuel monitoring and his decision to take off with an unverified amount of fuel, which resulted in fuel exhaustion and a subsequent impact with trees during an attempted forced landing.NTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB GAA18CA095Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot’s geographic disoriention during a night flight, which resulted in an off-airport landing.NTSB CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB WPR18LA050Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec · Caldwell, IDFailure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.NTSB WPR18LA049Accident · Serious injuriesLimited investigationFinal reportNorth American Navion · El Cajon, CAA 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 CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasNTSB ERA18LA062Accident · No injuriesLimited investigationFinal reportPiper PA32 · Oakland Park, FLThe loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB ERA18CA035Accident · No injuriesData collectionFinal reportDriggers Quillan E Titan Tornado · Mechanicsville, VAThe pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.NTSB CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.