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 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 CEN22LA311Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOSport 2017 · Mead, OKA partial loss of engine power for reasons that could not be determined.NTSB GAA22WA217IncidentClass 5 · ForeignPiper PA28 · Blackpool, United KingdomNTSB GAA22WA212AccidentClass 5 · ForeignSikorsky S76D · Mumbai, IndiaNTSB WPR22LA231Accident · Serious injuriesClass 3 · LimitedFinal reportJames C Geyman RV-9A · Missoula, MTThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the pilot’s failure to activate the auxiliary fuel boost pump, which inhibited a successful engine restart.NTSB ERA22LA291Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Warm Springs, GAThe loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.NTSB WPR22LA223Accident · No injuriesClass 4 · LimitedFinal reportDG Flugzeugbau DG 1000S · Lake Chelan, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight. Contributing to the accident was the pilot’s decision to overfly a suitable landing site which resulted in an off-field landing in a lake.NTSB WPR22LA225Accident · No injuriesClass 4 · LimitedFinal reportRolladen-Schneider LS-6 · Tahoe Vista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight and subsequent water ditching.NTSB GAA22WA215Accident · Minor injuriesClass 4 · ForeignRobinson R44 · Rio das Ostras, BrazilNTSB ERA22LA277Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hunter · Wilmington, NCA bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.NTSB CEN22LA260Accident · Minor injuriesClass 3 · LimitedFinal reportSmith Miniplane DSA-1 · Union, NEThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22FA216Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Porterville, CAMaintenance personnel’s failure to properly secure the elevator control assembly hardware, which resulted in an in-flight disconnection of the elevator and elevator counterweight and the pilot’s inability to maintain pitch control.NTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB WPR22LA221Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Stockton, CATail rotor blade impact with an unidentified object, which resulted in the loss of control and subsequent rollover of the helicopter.NTSB CEN22LA253Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T206H · Austin, TXA total loss of engine power due to an engine fire that resulted from failure of the turbocharger exhaust clamp, which allowed hot exhaust gases to damage other vital engine components.NTSB ENG22WA032Incident · No injuriesClass 5 · ForeignBoeing 777 · Karachi, PakistanNTSB GAA22WA286AccidentClass 5 · ForeignDiamond DA40 · Fursatganj, IndiaNTSB CEN22LA247Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32R-301 · Olla, LAThe partial loss of engine power for undetermined reasons.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 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 ENG22WA030IncidentClass 5 · ForeignAirbus A320 · Tijuana, MexicoNTSB CEN22LA229Accident · No injuriesClass 4 · LimitedFinal reportFahey William J CH750 Cruzer · San Antonio, TXThe loss of engine power due to fuel starvation. Contributing to the fuel starvation was a faulty experimental fuel gauge.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 WPR22LA193Accident · No injuriesClass 3 · LimitedFinal reportVans RV-8 · Galice, ORThe in-flight failure of the crankshaft gear’s alignment dowel as a result of the retaining bolt not being installed, which lead to a total loss of engine power.NTSB CEN22FA217Accident · 1 fatalClass 3 · FieldFinal reportCessna 162 · Memphis, TNPilot incapacitation due to an acute cardiac event.NTSB ENG22WA031IncidentClass 5 · ForeignAirbus A321 · Apodaca, MexicoNTSB GAA22WA193Accident · 4 fatalClass 5 · ForeignCessna C182 · Slunj, CroatiaNTSB ERA22LA249Accident · Minor injuriesClass 3 · LimitedFinal reportAeronca 7AC · Melrose, TNA total loss of engine power due to carburetor icing.NTSB ENG22WA038Accident · 22 fatalClass 5 · ForeignDe Havilland DHC6 · Near Shikha, NepalNTSB CEN22LA227Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28RT-201T · Morgan, TXA partial loss of engine power due to a corrosion-related fatigue crack of the No. 3 cylinder barrel.NTSB DCA22WA190Accident · Serious injuriesClass 5 · ForeignBoeing 787-900 · Lahore, PakistanNTSB 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 DCA22LA125Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A320-232 · Springfield, MOThe flight’s encounter with clear air moderate turbulence.NTSB ERA22LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Caryville, FLAn in-flight loss of engine power on both engines for undetermined reasons.NTSB DCA22LA134Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-700 · Tacoma, WADuring cruise flight with no reported turbulence a passenger sustained a serious injury for an unknown reason.NTSB GAA22WA200Accident · 1 fatalClass 5 · ForeignCessna TU206 · Macizo Del AuyáN-Tepui, VenezuelaNTSB ERA22LA231Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS355 · Palm Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the unlatched engine cowling opening and being struck by a main rotor blade during flight. Contributing to the accident was the mechanic’s failure to properly secure the cowling following…NTSB GAA22WA182Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Lost City, AustraliaNTSB 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 CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.NTSB GAA22WA183Accident · 2 fatalClass 5 · ForeignCessna 208 · Boituva, BrazilNTSB 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 ERA22LA268Accident · No injuriesClass 3 · LimitedFinal reportWingren Norman Escapade · Brasstown, NCThe failure of the engine gearbox drive flange, which resulted in a nose gear collapse during the subsequent precautionary landing in tall grass.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 GAA22WA179AccidentClass 5 · ForeignBell 206 · Cruziero do Sul, BrazilNTSB WPR22FA172Accident · 2 fatalClass 3 · FieldFinal reportVans RV10 · Sausalito, CAThe pilot’s improper decision to continue a visual flight rules flight into an area of limited visibility conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA22LA220Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Tybee Island, GAA loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.NTSB GAA22WA186Accident · No injuriesClass 5 · ForeignCessna 182P · Trinidad, BoliviaNTSB WPR22FA169Accident · 2 fatalClass 3 · FieldFinal reportBearhawk LSA · Kalispell, MTAn excessive pitch control input for undetermined reasons while the airplane was operating above maneuvering speed, which led to a structural failure of the right wing during cruise flight. Contributing to the accident was the poor construction quality of the…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.