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 LAX99FA125Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lytle Creek, CAthe pilot's inadvertent visual flight into instrument meteorological conditions resulting in impact with high terrain.NTSB ATL99LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bunn Level, NCThe loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.NTSB DEN99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Agate, COThe development of carburetor ice resulting in a partial loss of engine power. Factors were the weather conditions favorable for carburetor icing, the dark night conditions, and the lack of suitable terrain for landing.NTSB NYC99FA074Accident · 2 fatalField investigationFinal reportCessna 340A · Chesapeake, VAThe pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.NTSB DEN99LA054Accident · No injuriesLimited investigationFinal reportCessna 320D · Broomfield, COA partial loss of power on the left engine for undetermined reasons. A factor was the pilot's failure to maintain directional control of the aircraft during landing flare/touchdown.NTSB ANC99LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Fairbanks, AKThe loss of engine power for an undetermined reason.NTSB CHI99LA109Accident · No injuriesLimited investigationFinal reportPiper J5A · Wausau, WIthe loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.NTSB DEN99IA053Incident · No injuriesIncident investigationFinal reportGulfstream G-IV · Durango, COThe failure of the number four fuel line. Factors were the chaffing of the alternator's electrical wires on the number four fuel line, and the subsequent fire in the number one engine nacelle.NTSB NYC99FA071Accident · 1 fatalField investigationFinal reportMooney M20K · Counts, VAThe pilot's failure to maintain control of the airplane.NTSB MIA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mt. Vernon, GAThe pilot's improper flare that resulted in a hard landing in an open field. A factor was the high output flow of the fuel injector servo that resulted in a loss of engine power and the forced landing.NTSB CHI99FA105Accident · 1 fatalField investigationFinal reportBeech C-45G · Romulus, MIthe aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.NTSB NYC99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Richmond, VAThe pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.NTSB MIA99LA100Accident · No injuriesLimited investigationFinal reportMooney 20G · Naples, FLthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a off airport forced landing. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…NTSB NYC99LA069Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340A · Atlantic City, NJUnanticipated in-flight turbulence.NTSB MIA99LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)a loss of engine power for an undetermined reason, resulting in a forced landing in water, and subsequent sinking of the airplane.NTSB CHI99IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Salina, KSThe ARTCC personnel failed to maintain radio communications with both airplanes and failed to maintain IFR separation standards. Factors relating to the incident were the FAA does not require cargo airplanes to be equipped with TCAS and neither airplane was…NTSB MIA99LA093Accident · No injuriesLimited investigationFinal reportScott A. George Jr. Fisher Celebrity · Simpsonville, SCThe unsuitable terrain encountered during the forced landing. Contributing to the accident was the total loss of engine power due to the failure of a plastic 90-degree fitting at the inlet fitting of the carburetor.NTSB NYC99LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Wolfeboro, NHThe pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.NTSB LAX99LA113Accident · 1 fatalLimited investigationFinal reportCessna P210N · Pacific Ocean (Pacific Ocean)A loss of engine oil pressure and ensuing loss of engine power for undetermined reasons.NTSB DEN99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-23C-250 · Lamar, COThe pilot's improper use of the airplane's fuel tank selector switches. Factors were the fuel starvation to both engines, the pilot's lack of sleep, and the soft terrain.NTSB LAX99LA111Accident · Minor injuriesLimited investigationFinal reportCooper Vans RV-6 · Vacaville, CAThe failure of the engine assembler to apply the proper torque on the connecting rods bolts, which led to fatigue cracking and ultimately fracture of the rod bolts.NTSB FTW99LA085Accident · Minor injuriesLimited investigationFinal reportEurocopter Colibri EC120B · Springtown, TXThe improper touchdown executed by the pilot. Factors were the tail wind condition, and the manufacturer's inadequate design of the P3 pipe supports, which resulted in a fatigue fracture of the P3 pipe.NTSB MIA99LA091Accident · No injuriesLimited investigationFinal reportMooney M20J · St. Cloud, FLThe improper installation of the propeller by maintenance personnel resulting in fretting of the face of the propeller hub and fatigue failure of the No. 1 propeller blade. Also, the unsuitable terrain encountered during the descent for the forced landing.NTSB DEN99LA042Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Telluride, COA loss of engine power due to the ingestion of air in the fuel line, the pilot's failure to purge the fuel line of unwanted air prior to flight as outlined in the Airplane Flight Manual, and inadequate altitude in which to glide to the airport.NTSB NYC99LA065Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Bristol, CTThe partial loss of power due to the failure of a fatigued connecting rod bolt.NTSB LAX99FA106Accident · Minor injuriesField investigationFinal reportCessna 172N · El Monte, CAAn in-flight fuel fire in the left forward doorpost due to an electrical arc from an adjacent map light switch puncturing a main fuel feed line. The manufacturer's inadequate design in routing the fuel line in close proximity to electrical arc sources in the…NTSB LAX99LA103Accident · No injuriesLimited investigationFinal reportZivko Aeronautics Edge 540 · Livermore, CAThe manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…NTSB LAX99FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Coalinga, CAthe pilot's inadvertant visual flight into instrument meteorological conditions.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB NYC99LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale 355 · Toledo, OHThe pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.NTSB DEN99IA038Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Aspen, COThe inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.NTSB MIA99LA079Accident · Minor injuriesLimited investigationFinal reportWolf Seawind 3000 · Bradenton, FLTotal loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB FTW99LA079Accident · No injuriesLimited investigationFinal reportMiller/Bell TR-1 · Hiwasse, ARThe pilot's inadequate compensation for prevailing wind conditions. Factors were the crosswind, the lack of suitable terrain, and the separation of the adell clamp for the oil cooler inlet line.NTSB ATL99LA049Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Raleigh, NCThe flight encountered clear air turbulence while descending through 17,000 feet mean sea level (MSL).NTSB DEN99LA037Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Climax, COThe flight's encounter with turbulence.NTSB CHI99FA089Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Belle Fourche, SDinadequate preflight planning/preparation, refueling not performed, and aircraft control not maintained by the pilot. The inadvertent stall by the pilot was an additional cause. Fuel exhaustion was a contributing factor.NTSB NYC99IA056Incident · No injuriesIncident investigationFinal reportPiper PA42-1000 · Lexington, KYImproper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.NTSB LAX99FA102Accident · 1 fatalField investigationFinal reportNorth American T-28B · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.NTSB LAX99FA090Accident · 1 fatalField investigationFinal reportNorth American T-28C · Joshua Tree, CAThe pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.NTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.NTSB CHI99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Paxton, ILthe inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.NTSB FTW99LA078Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Daingerfield, TXAn undetermined airframe malfunction which rendered the aircraft uncontrollable.NTSB LAX99LA087Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Las Vegas, NVThe injured passenger's failure to follow the instructions of the cabin attendants.NTSB LAX99IA085Incident · No injuriesIncident investigationFinal reportAerospatiale AS350B · Grand Canyon Pk, AZThe in-flight separation of a side window for undetermined reasons.NTSB CHI99FA079Accident · 1 fatalField investigationFinal reportCessna U-206G · Salem, MOthe spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.NTSB FTW99LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Wharton, TXThe pilot's failure to comply with the manufacturer's single engine landing checklist which resulted in the aircraft landing short of the runway.