NTSB investigations
35,883 cases where the phase of flight was Enroute.
Cases, newest first
Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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 case_mkey FROM case_phases WHERE main = 400)
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.
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
current_codes AS (
SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
),
phases AS (
SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
FROM current_codes WHERE n = 1
UNION ALL
SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
),
case_phases AS (
SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
)
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 case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN21LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Beloit, OHThe pilot’s inadequate preflight inspection and inflight planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA21WA002Accident · 2 fatalClass 5 · ForeignRobinson R44 · Passa Tres, Rio Claro, BrazilNTSB GAA21WA001Accident · 3 fatalClass 3 · ForeignPiper PA28RT · Ubate-Cundinamarca, ColombiaNTSB GAA21WA003Accident · 1 fatalClass 5 · ForeignPiper PA25 · Juan Jose Rios, MexicoNTSB CEN21WA011Accident · No injuriesClass 5 · ForeignCirrus SR22 · Langdorp, BelgiumNTSB ERA21LA031Accident · No injuriesClass 4 · LimitedFinal reportSparrowhawk II · North Myrtle Beach, SCA ruptured fuel line, which resulted in fuel starvation to the engine and a total loss of engine power.NTSB ERA21FA010Accident · 1 fatalClass 3 · FieldFinal reportCzech Sport Cruiser · Waterloo, ALThe improper configuration of the airplane’s fuel system, which resulted in a total loss of engine power due to fuel starvation following the failure of the electric fuel pump.NTSB ERA21LA009Accident · Minor injuriesClass 3 · LimitedFinal reportWatson Michael A Velocity Elite RG · Lady Lake, FLA total loss of engine power during cruise flight for undetermined reasons.NTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.NTSB CEN21LA010Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Bridgeport, TXThe pilot’s inadequate fuel planning, which led to fuel exhaustion and a subsequent total loss of engine power.NTSB CEN21LA001Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Cedaredge, COA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA21LA003Accident · 2 fatalClass 3 · LimitedFinal reportSocata TBM700 · Corfu, NYThe pilot’s failure to maintain control of the airplane for undetermined reasons during the descent to the destination airport.NTSB ERA21LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech BE-36 · Green Sea, SCThe pilot’s inadvertent placement of the fuel selector in an intermediate position, which starved the engine of fuel and resulted in a total loss of engine power.NTSB DCA21WA001Incident · No injuriesClass 5 · ForeignBoeing 787 · London, United KingdomNTSB ERA21LA005Accident · No injuriesClass 3 · LimitedFinal reportFokker DR1 · Wake, VAA total loss of engine power due to fuel starvation as the result of the improper installation of the ram air fuel vent tube, which resulted in the tube separating from the airplane during taxi and subsequent negative pressure inside the fuel tank.NTSB ENG21WA002IncidentClass 5 · ForeignAirbus A330 · Nawabshah, PakistanNTSB DCA21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777 · Anchorage, AKThe airplane’s encounter with severe turbulence while flying over a mountain range during cruise.NTSB ERA20LA341Accident · No injuriesClass 3 · LimitedFinal reportTecnam P92 · Centerville, MDThe fatigue failure of the No. 1 cylinder exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB WPR20LA319Accident · 1 fatalClass 3 · LimitedFinal reportCessna T182 · Santa Barbara, CAThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions.NTSB CEN20WA418Incident · No injuriesClass 4 · ForeignSikorsky S92 · Sola, NorwayNTSB CEN20LA420Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Terrell, TXFuel starvation due to a fuel system leak, which resulted in a loss of engine power and the subsequent forced landing on unsuitable terrain.NTSB CEN20LA422Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · St. Clairsville, OHThe pilots improper fuel planning that resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA328Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Hamilton, GAThe pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA326Accident · Serious injuriesClass 3 · LimitedFinal reportStearman E75 · Honea Path, SCThe partial loss of engine power due to the fatigue failure of an engine cylinder and the pilot’s subsequent decision to overfly several suitable forced-landing sites while attempting to return to the departure airstrip.NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Moosic, PAThe inadequate torquing of anchored-thru and free-thru studs during installation of the No. 2 cylinder, resulting in their fatigue fracture and subsequent total loss of engine power. Contributing to the undershoot landing was the pilot’s failure to divert to…NTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB WPR20LA311Accident · Serious injuriesClass 3 · LimitedFinal reportNorth American B25N · Stockton, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the erroneous fuel gauge indications and inadequate preflight planning and inspectionNTSB CEN20LA412Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Montrose, MOA total loss of engine power due to an electrical overload in the engine control unit wiring system; the electrical overload occurred as a result of improper installation by the airplane builder.NTSB CEN20LA402Accident · 4 fatalClass 3 · LimitedFinal reportPiper PA46 · Hilltop Lakes, TXThe loss of engine power for reasons that could not be determined and the pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot’s failure to establish and maintain a…NTSB DCA21WA017IncidentClass 5 · ForeignBombardier CL600 2C10 · Chihuahua City, MexicoNTSB ERA20LA320Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Newport, PAA total loss of engine power during cruise flight due to a disconnected carburetor mixture control cable which allowed the carburetor mixture lever to migrate to the cut-off position during flight.NTSB CEN20LA403Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Palatine, ILThe loss of partial engine power due to fuel starvation during departure which resulted in a forced landing and collision with a utility pole.NTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB DCA27WA007Incident · No injuriesClass 5 · ForeignFairchild SA227-AC · Gyor, HungaryNTSB ERA20LA313Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Jackson, TNThe pilot’s inadequate preflight 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.NTSB GAA20WA147Incident · No injuriesClass 5 · ForeignBellanca 8KCAB · Roskilde, DenmarkNTSB ERA20LA314Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH750 Cruzer · Boaz, ALThe pilot’s failure to maintain control of the airplane, which resulted in an aerodynamic stall and impact with trees and terrain. Contributing was the pilot’s continued visual flight rules flight into an area of low clouds.NTSB ERA20CA317Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA25 · Destin, FLThe pilot's failure to manage the available fuel supply which resulted in fuel starvation and a total loss of engine power.NTSB ERA20LA327Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · Weston, FLA total loss of engine power because of the overheating and failure of the connecting rod bearings due to a lack of lubrication for reasons that could not be determined.NTSB CEN20LA384Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Bonham, TXThe loss of engine power due to a disconnected fuel injector line that was not properly tightened during recent maintenance.NTSB CEN20LA380Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Canyon Lake, TXThe total loss of engine power for a reason that could not be determined based on available information.NTSB ANC20LA089Accident · No injuriesClass 3 · LimitedFinal reportEurocopter AS 350 · Fort Greely, AKFailure of the door lock due to interference between the door and a cargo box.NTSB CEN20LA385Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28-140 · Red Oak, IAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB CEN20LA379Accident · 4 fatalClass 3 · LimitedFinal reportCirrus SR22 · Chester, ARThe noninstrument-rated pilot’s continued flight into dark night instrument meteorological conditions which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB WPR20LA295Accident · 2 fatalClass 3 · LimitedFinal reportBeech 35 · Three Rivers, CAThe pilot’s controlled flight into terrain while operating in conditions of reduced visibility due to smoke.NTSB CEN20CA386Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA-38-112 · Reserve, LAThe loss of engine power for undetermined reasons.NTSB CEN20LA378Accident · No injuriesClass 3 · LimitedFinal reportCessna 340 · Oklahoma City, OKA failure of the windscreen for reasons that could not be determined based on available evidence.NTSB CEN20LA374Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Walker, MNThe pilot’s impairment from the effects of an undiagnosed brain tumor.NTSB CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.