NTSB investigations
35,885 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 DEN00LA145Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Duchesne, UTThe pilot's use of excessive braking on soft terrain. Factors included fuel starvation, the fuel selector valve not engaging properly, the pilot's incorrect positioning of the fuel selector valve, and the soft terrain on which the forced landing was made.NTSB CHI00LA246Accident · Minor injuriesLimited investigationFinal reportSummers RV4 · Bismarck, NDInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion. A factor associated with the accident was the drainage ditch that the airplane contacted.NTSB LAX00LA288Accident · No injuriesLimited investigationFinal reportBell 47D · Stockton, CAThe pilot's inadequate planning by which he miscalculated fuel consumption which resulted in fuel exhaustion.NTSB IAD00LA071Accident · No injuriesLimited investigationFinal reportShowalter Rotorway 152 · Ravenna, OHThe pilot/owner's inadequate installation of an ignition lead that resulted in a partial loss of engine power and forced landing to unsuitable terrain. A factor in the accident was the soybean crop in the forced landing site.NTSB CHI00LA243Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Osborne, KSThe unsuitable terrain for landing encountered by the pilot during the forced landing. Factors were the failure of the number four piston and cylinder, the soft terrain, and the main landing gear overload and subsequent collapse.NTSB DEN00LA144Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMFuel exhaustion and the pilot's failure the refuel the airplane. Factors were the road signs.NTSB SEA00LA150Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oregon City, ORA loss of engine power for undetermined reason(s). A factor was the rough/uneven terrain.NTSB NYC00LA214Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wildwood, NJThe partial loss of power caused by detonation of the #3 piston.NTSB LAX00LA284Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Morgan Hill, CAA loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight inspection and failure to verify the fuel supply onboard the airplane.NTSB FTW00LA222Accident · Serious injuriesLimited investigationFinal reportRomero SEA REY · Tulsa, OKThe loss of control by the pilot due to incapacitation for unknown reasons.NTSB CHI00LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 737-322 · Chicago, ILthe evasive maneuver performed by the pilot. A factor was the activation of the collision avoidance system.NTSB CHI00LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Burlington, WIloss of engine power for undetermined reasons and the pilot's failure to maintain clearance from the fence during the forced landing attempt. Factors relating to the accident were the pilot's improper in-flight planning and decision to turn back toward the…NTSB CHI00LA238Accident · No injuriesLimited investigationFinal reportBeech BE-A35 · Poplar Bluff, MOthe pilot exceeded the VNE speed restriction of 144 MPH. Factors included the ruddervator flutter and the out of balance ruddervators.NTSB SEA00LA146Accident · No injuriesLimited investigationFinal reportJonas Falcon XP · Pendleton, ORA loss of engine power for undetermined reasons. A factor was rough/uneven terrain in the forced landing area.NTSB CHI00FA227Accident · 4 fatalField investigationFinal reportCessna 182A · Sauk City, WIVFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.NTSB ATL00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Charleston, SCThe pilot's inadequate evaluation of weather information, and his delay in taking remedial action that resulted in the in-flight encounter with severe weather.NTSB NYC00FA210Accident · 1 fatalField investigationFinal reportMooney M20E · Lunenburg, MAThe pilot's inadequate preflight planning which resulted in exhaustion of the fuel supply.NTSB NYC00FA209Accident · 1 fatalField investigationFinal reportCessna 210D · Ashland, VAThe failure of the pilot to maintain control of the airplane due to spatial disorientation. Factors were the dark night, low ceiling and fog.NTSB LAX00LA278Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons.NTSB SEA00FA142Accident · 1 fatalField investigationFinal reportCessna TU-206G · Pistol Creek, IDA loss of engine power due to the fracture of the #2 cylinder intake valve stem and the puncturing of the #2 piston dome by the intake valve head. Factors include no suitable landing site within the maneuvering abilities of the aircraft, and coniferous trees…NTSB MIA00LA225Accident · No injuriesLimited investigationFinal reportCessna 421A · Homewood, MSThe inadequate installation of the right propeller by the mechanic for his failure to properly torque the eight nuts resulting in fatigue failure of the studs and separation of the right propeller during cruise flight. Findings in the investigation were 1)…NTSB CHI00LA223Accident · No injuriesLimited investigationFinal reportCessna 210N · Harrisburg, ILThe power loss for undetermined reasons and unsuitable terrain.NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB SEA00LA143Accident · Serious injuriesLimited investigationFinal reportJim Weseman Challenger II · Chiloquin, ORLoss of engine power for undetermined reasons. Unsuitable terrain and the pilot's failure to maintain aircraft control were factors.NTSB LAX00LA277Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Boulder City, NVThe fatigue fracture and separation of the No. 6 cylinder fuel injector line due to the company maintenance personnel's failure to comply with an Airworthiness Directive. A factor in the accident was the company's decision to operate the aircraft in…NTSB CHI00IA221Incident · No injuriesIncident investigationFinal reportAerospatiale ATR 42-300 · Champaign, ILThe failure of the aileron trim switch due to foreign material contamination.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.NTSB LAX00MA273Accident · 7 fatalMajor investigationFinal reportAerospatiale AS 355F1 · Kahului, Maui, HIThe pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…NTSB LAX00LA275Accident · Minor injuriesLimited investigationFinal reportSteel/Vans RV6 · Winnemucca, NVA loss of power due to overheating resulting from the failure of the engine build-up facility to install a vernatherm.NTSB ANC00FA093Accident · 1 fatalField investigationFinal reportCessna 180 · Thorne Bay, AKThe pilot-in-command's inadvertent stalling of the airplane.NTSB NYC00MA201Accident · 2 fatalMajor investigationFinal reportGrumman G-159 · Linneus, METhe pilot-in-command's failure to maintain minimum control airspeed, which resulted in a loss of control. Factors in this accident were clouds, and a loss of engine power for undetermined reasons, while in cruise flight above the airplane's single engine…NTSB LAX00IA272Incident · No injuriesIncident investigationFinal reportCanadair CL-65 · Monterey, CAFatigue failure of the bell gear in the horizontal stabilizer trim actuator system.NTSB IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.NTSB NYC00LA200Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Richfield Sprng, NYFailure of the number two cylinder main bearing for undetermined reasons.NTSB MIA00FA221Accident · 1 fatalField investigationFinal reportBeech 58 · Hernando, MSThe arcing of an electrical wire behind the instrument panel and the associated cracking of fuel and oil lines. Also causal was the pilot's inappropriate remedial action not in accordance with the emergency checklist.NTSB CHI00LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, WIthe blocked lubricating system and unsuitable terrain.NTSB CHI00LA201Accident · Minor injuriesLimited investigationFinal reportWitlock CIRCA-NIEUPORT 12 · Peotone, ILthe carburetor icing conditions and the fact that the aircraft was not equipped with carburetor heat protection. A factor to the accident was the crops.NTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA143Accident · No injuriesLimited investigationFinal reportMooney M20J · Espanola, NMThe lack of suitable terrain for a forced landing. A factor was a complete loss of power due to mechanical failure.NTSB CHI00LA207Accident · Serious injuriesLimited investigationFinal reportChilian Kitfox 1200 IV · Lowell, INthe incapacitation of the pilot. Factors to the accident were the failure of the pilot to maintain flying speed and the subsequent stall.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC00LA195Accident · No injuriesLimited investigationFinal reportFairchild M-62 · Grafton, OHThe pilot's failure to maintain control of the airplane while taking off.NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.NTSB ANC00LA084Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Chickaloon, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was rough/uneven terrain.NTSB SEA00FA132Accident · 3 fatalField investigationFinal reportCessna 180F · Gold Bar, WAThe non-instrument rated pilot's attempted VFR flight in instrument meteorological conditions. Contributing factors were mountainous terrain and cloud, low ceiling and obscuration conditions.NTSB SEA00FA127Accident · 1 fatalField investigationFinal reportCessna 175 · Molalla, ORFailure to maintain clearance from mountainous/hilly terrain.NTSB MIA00FA208Accident · 1 fatalField investigationFinal reportCessna 402C · Vieques, PRThe airplanes entry into an uncontrolled descent for undetermined reasons from which it crashed into the ocean.