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 WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB CEN09LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Shelbyville, INThe loss of engine power during cruise flight due to fuel contamination. Also causal was the pilot's decision to conduct the flight with known contaminants in the fuel.NTSB CEN09CA218Accident · No injuriesData collectionFinal reportBell 222 · Milliken, COThe separation of the left engine cowling for undetermined reasons.NTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.NTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.NTSB WPR09LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Oceanside, CAA total loss of engine power in flight due to the fatigue failure of the No. 4 cylinder.NTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneNTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.NTSB CEN09FA193Accident · 1 fatalField investigationFinal reportBell 206-L4 · Moundridge, KSInflight collision with terrain for undetermined reasons.NTSB WPR09LA149Accident · 1 fatalLimited investigationFinal reportCessna 172N · Oceanside, CAA loss of aircraft control for undetermined reasons.NTSB ERA09IA186Incident · Minor injuriesIncident investigationFinal reportAgusta A109E · Gainesville, FLAn inadvertent in-flight collision with a duck.NTSB ERA09CA195Accident · No injuriesData collectionFinal reportCessna 172P · Cleveland, MSThe inadvertent encounter with a bird in flight.NTSB ERA09LA182Accident · 1 fatalLimited investigationFinal reportMoore Glenn Moronca · Burgaw, NCA partial loss of engine power due to fuel contamination as a result of the pilot's operation of the airplane with a deteriorated fuel tank.NTSB WPR09IA140Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Peach Springs, AZA loss of engine power due to the failure of the number three engine bearing as a result of oil starvation due to coked oil obstructing the oil passages.NTSB WPR09FA141Accident · 1 fatalField investigationFinal reportStephenson Zodiac 601 XL · Antelope Island, UTThe in-flight failure of both wings due to aileron flutter. The aileron flutter was the result of inadequate wing stiffness and the lack of aileron counterbalances.NTSB WPR09CA137Accident · No injuriesData collectionFinal reportRudolph Ralph Monroe Starlite · Coachella, CAA total loss of engine power due to oil starvation to the rear crankshaft journal.NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB CEN09WA174Accident · 4 fatalClass 5 · ForeignCirrus Design SR 22 · Itzehoe, GermanyOn February 24, 2009, at 1600 coordinated universal time, a Cirrus Design Corporation SR22 , German registered D-EPDK, was destroyed when it impacted terrain under unknown circumstances near Itzehoe Germany. Visual meteorological conditions prevailed at the…NTSB WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanNTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…NTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…NTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.NTSB WPR09CA114Accident · No injuriesData collectionFinal reportSchweizer G-164B · Buttonwillow, CAA loss of engine power due to the number four cylinder base nuts becoming loose, allowing the cylinder to detach from the engine case. Contributing to the accident was the pilot's impaired visibility due to smoke during the forced landing.NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB ERA09MA157Accident · 6 fatalMajor investigationFinal reportCessna 206H · Quebradillas, PRThe pilot exceeded the design limits of the airplane, which resulted in an in-flight break up while maneuvering in adverse weather conditions.NTSB ERA09RA161Accident · 2 fatalForeign investigationCessna 650 · Rome, ItalyNone.NTSB WPR09FA112Accident · 3 fatalField investigationFinal reportBeech A36 · Avalon, CAThe pilot’s failure to follow the published instrument departure procedures during the climb to cruise, and loss of control in instrument meteorological conditions. Contributing to the accident was the pilot’s lack of total experience in instrument…NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.NTSB CEN09FA146Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Menomonie, WIThe pilot's failure to maintain control of the airplane while flying at night in instrument meteorological conditions.NTSB WPR09CA103Accident · No injuriesData collectionFinal reportAeronca 7BC · Half Moon Bay, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to perform an accurate visual fuel quantity check prior to initiating the flight.NTSB WPR09LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Oceanside, CAA defective alternator wire splice that resulted in an intermittent electrical system malfunction and erroneous fuel gauge readings, and, a loss of engine power for an undetermined reason.NTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.NTSB ERA09IA140Incident · No injuriesIncident investigationFinal reportCessna 402C · Naples, FLThe pilot's failure to recognize that both engines were being supplied fuel only from the right main fuel tank, resulting in fuel starvation and a subsequent loss of engine power from both engines. Contributing to the incident were the pilot's inability to…NTSB CEN09LA143Accident · No injuriesLimited investigationFinal reportCessna 172E · Plano, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN09CA140Accident · No injuriesData collectionFinal reportCessna 172M · Little Rock, ARThe loss of engine power due to the missing nut on the bolt connecting the throttle cable and carburetor's lever arm.NTSB WPR09LA097Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Honolulu, HIAn oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.NTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.NTSB WPR09CA091Accident · No injuriesData collectionFinal reportSiemer James H Earthstar · Santa Ynez, CAA partial loss of engine power due to the rear cylinder's spark plug coming out of the cylinder head.NTSB WPR09CA090Accident · Minor injuriesData collectionFinal reportMulec Frank A FP-404 · Hilo, HIA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB CEN09CA136Accident · No injuriesData collectionFinal reportBeech 19 · Lafayette, INThe pilot's inadvertent encounter with icing conditions during initial climb. Contributing to the accident were the lack of visibility during the landing due to an ice covered windscreen, and the structural ice that adversely affected the flight…NTSB ERA09FA133Accident · No injuriesField investigationFinal reportPiper PA-46-500TP · Milton, FLThe pilot's intentional inflight abandonment of the airplane.NTSB WPR09FA076Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R44 II · West Valley City, UTThe pilot’s inadvertent VFR flight into IMC conditions, which resulted in his spatial disorientation and loss of control of the helicopter. Also causal was the flight instructor’s delay in taking remedial action.NTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.NTSB CEN09LA122Accident · No injuriesLimited investigationFinal reportBeech A36TC · Three Rivers, MIThe pilot's decision to continue the flight into an area with conditions that were conducive to icing and the loss of engine power due to induction icing.NTSB CEN09LA132Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5B · Milford, INA loss of engine thrust due to the separation of a section of one of the propeller blades as a result of fatigue failure of the propeller because of corrosion. Contributing to the accident was the failure of the mechanic to detect and address the propeller…NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…NTSB ERA09LA123Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Powder Springs, TNThe non-instrument rated pilot's decision to continue under visual flight rules into an area of instrument meteorological conditions, which resulted in an in-flight collision with terrain.