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 GAA21WA116Accident · 2 fatalClass 4 · ForeignRobinson R66 · Dvina Bay, RussiaNTSB CEN21FA220Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · St. Louis, MIThe pilot’s failure to maintain adequate visual lookout to ensure clearance from the radio tower and its guy wires. Contributing to the accident was the pilot’s unnecessary use of his mobile device during the flight, which diminished his attention/monitoring…NTSB CEN21LA232Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Whitewater, WIAn inflight instrument malfunction for reasons that could not be determined based on available information, which led to the pilot’s decision to activate the airframe parachute system.NTSB WPR21LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Lake Arrowhead, CAA total loss of engine power due to a malfunction of the fuel flow manifold valve.NTSB GAA21WA125Accident · Serious injuriesClass 5 · ForeignCessna 182 · Pocone, BrazilNTSB CEN21LA221Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Pinckneyville, ILThe total loss of engine power due to oil starvation. The reason for the oil starvation could not be determined based on available evidence.NTSB ENG21WA026IncidentClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesNTSB CEN21LA213Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Merrill, WIThe loss of engine power due to tappet failure.NTSB ANC21LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Gakona, AKThe pilot’s decision to initiate a flight with a failed mixture control cable which resulted in a total loss of engine power.NTSB ANC21LA038Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F-28F · Palmer, AKA loss of drive to the rotor system due to the disengagement of the main belt drive tensioning system, which resulted in a forced landing. The disengagement was due to inadequate clearance between the clutch handle and the roll pin in the handle bellcrank…NTSB GAA21WA124Accident · No injuriesClass 5 · ForeignRobinson R44 · Belo Horizonte, BrazilNTSB GAA21WA113Accident · No injuriesClass 5 · ForeignCessna F177RG · Pucallpa, Ucayali, PeruNTSB ERA21FA212Accident · 1 fatalClass 3 · FieldFinal reportTed Smith Aerostar 600 · La Belle, FLThe pilot's inadvertent shutdown of the left engine following an intentional shutdown of the right engine while practicing one engine inoperative (OEI) procedures. Contributing to the accident was the pilot’s decision to conduct OEI training at low altitude.NTSB DCA21WA129IncidentClass 5 · ForeignAirbus A330 · Karachi, PakistanNTSB GAA21WA104Accident · 2 fatalClass 5 · ForeignRobinson R22 · Durban, South AfricaNTSB ERA21LA213Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · Okeechobee, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB GAA21WA102Incident · No injuriesClass 5 · ForeignCessna 150 · Fernandópolis - SP, BrazilNTSB CEN21LA231Accident · No injuriesClass 3 · LimitedFinal reportCessna 150J · Madison, ARThe pilot’s improper fuel planning which led to fuel exhaustion, and a total loss of engine power.NTSB GAA21WA101Accident · 4 fatalClass 5 · ForeignCessna 172 · Grasmere, South AfricaNTSB GAA21WA094Accident · Serious injuriesClass 5 · ForeignCessna 182 · Chiguao, VenezuelaNTSB ERA21LA191Accident · 1 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 · Forkston, PAThe pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.NTSB CEN21FA198Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-46-310P · Danville, ARThe pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.NTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB GAA21WA089Accident · 1 fatalClass 5 · ForeignVans RV7A · Columbia, AustraliaNTSB ERA21LA197Accident · No injuriesClass 4 · LimitedFinal reportCessna 402C · New Bedford, MAAn inadvertent collision with a bird during descent, resulting in substantial damage to the vertical stabilizer.NTSB ERA21FA189Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28RT-201T · Brownsville, TNThe student pilot’s continued visual flight rules flight into night instrument meteorological conditions, which resulted in spatial disorientation and a rapid uncontrolled descent into terrain. Contributing to the accident were the self-induced and external…NTSB ERA21LA190Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Eufaula, ALA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN21FA195Accident · 1 fatalClass 3 · FieldFinal reportCessna 340A · Tatum, TXThe pilot’s loss of airplane control for undetermined reasons.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe 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 GAA21WA085Accident · No injuriesClass 5 · ForeignCessna 550 · Eelde, NetherlandsNTSB GAA21WA074Accident · No injuriesClass 5 · ForeignPiper J3 · Epse, NetherlandsNTSB WPR21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 182H · Blakely Island, WAA total loss of engine power during climb for reasons that could not be determined which resulted in a forced water landing.NTSB DCA21LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7 · Boulder, COa bird strike.NTSB GAA21WA072Accident · No injuriesClass 3 · ForeignBell 206 · Region de Los Lagos, ChileNTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…NTSB ERA21LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Arcadia, FLA total loss of engine power for underdetermined reasons.NTSB GAA21WA091AccidentClass 4 · ForeignAir Tractor AT401 · Planura, BrazilNTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB ERA21LA166Accident · Serious injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Fort Pierce, FLA total loss of engine power for reasons that could not be determined based on available information.NTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.NTSB WPR21LA145Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Marana, AZA total loss of engine power resulting from a catastrophic engine failure caused by a shift of the No. 2 main bearing and bearing seal, which resulted in oil starvation to the crankshaft; the reason for the bearing and bearing seal shift could not be…NTSB GAA21WA057AccidentClass 5 · ForeignPartenavia P68 · Bhopal, IndiaNTSB DCA21WA111Incident · No injuriesClass 5 · ForeignAirbus A320 · Lima, PeruNTSB WPR21LA141Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20B · Animas, NMThe pilot’s delayed use in the operation of carburetor heat which resulted in a loss of engine power due to carburetor icing.NTSB ENG21WA051Incident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Aoki Village, JapanNTSB ENG21WA019IncidentClass 5 · ForeignBoeing 747 · Dubai, United Arab EmiratesNTSB CEN21LA171Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Wanatah, INThe pilots’ fuel mismanagement, which resulted in fuel starvation and a total loss of engine power to both engines.NTSB GAA21WA056Accident · 2 fatalClass 5 · ForeignCessna 208 · Ndetani, KenyaNTSB GAA21WA054Accident · 4 fatalClass 5 · ForeignBell 206 · XIa Men City, ChinaNTSB WPR21LA142Accident · No injuriesClass 3 · LimitedFinal reportDavis Dan B Lancair Evolution · Phoenix, AZA malfunction of the main cabin door latching mechanism for reasons that could not be determined based on the available information.