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 SEA07LA255Accident · No injuriesLimited investigationFinal reportCessna 182G · Fairfield, IDThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight inspection. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC07FA217Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Syria, VAThe pilot's inadvertent flight into instrument meteorological conditions and his failure to maintain aircraft control. Contributing to the accident was the dark night conditions.NTSB MIA07CA141Accident · No injuriesData collectionFinal reportCessna 172 · Mooresville, NCThe inadequate preflight inspection of the airplane by the pilot-in-command for his failure to remove all water contamination from the fuel system.NTSB NYC07LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bernardsville, NJThe failure by unidentified maintenance personnel to follow appropriate procedures when attaching the No. 3 cylinder, which was replaced subsequent to the engine overhaul and not entered in the logbook, resulting in fatigue failures of the cylinder studs.NTSB MIA07CA142Accident · Minor injuriesData collectionFinal reportFurey Kitfox IV · Cowen, WVThe in-flight collision with a bird resulting in separation of the propeller.NTSB MIA07LA148Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lakeland, FLThe failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…NTSB MIA07LA140Accident · No injuriesLimited investigationFinal reportCessna 208B · Cross City, FLA total loss of engine power during cruise flight due to the fracture and separation of the compressor turbine blades for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC07LA207Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Goshen, NYA loss of engine power during cruise flight for undetermined reasons.NTSB MIA07FA137Accident · 5 fatalField investigationFinal reportBeech A36 · Elizabethton, TNThe poor in-flight planning by the pilot-in-command for flying towards rising terrain with inadequate clearance.NTSB LAX07CA262Accident · No injuriesData collectionFinal reportWessel Vortex · Mesa, AZFailure of the muffler's mounting strap and subsequent loss of engine power due to propeller blade separation during cruise flight. A contributing factor was the unsuitable terrain for a forced landing.NTSB LAX07CA261Accident · Minor injuriesData collectionFinal reportCessna T210N · San Jose, CAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation.NTSB SEA07LA245Accident · Serious injuriesLimited investigationFinal reportFitt Kitfox · Diamond Springs, CAOil starvation during climb due to an unidentified piece of plastic material blocking an oil supply tube and the pilot's inadequate maintenance of the lubricating system. Contributing to the accident was the rough terrain.NTSB DFW07CA194Accident · Minor injuriesData collectionFinal reportNicely Kitfox Model 5 · Guthrie, OKThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable landing terrain for the forced landing.NTSB DEN07LA148Accident · 2 fatalLimited investigationFinal reportElliott Cirrus VK30 · Watrous, NMThe pilot's failure to maintain control of the airplane during a forced landing that resulted in a hard landing. Contributing to the accident was the ruptured pressurized oil line.NTSB ATL07LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Danube, NYThe pilot's mismanagement of the fuel supply.NTSB LAX07LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lopez Island, WAA loss of engine power due to the fatigue failure of the left idler gear. Inadequate maintenance installation of the recently installed left magneto was also causal.NTSB NYC07LA201Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-31 · Markham, VAThe pilot's failure to maintain aircraft control. Contributing to the accident were a fuel leak as reported by the pilot, the pilot's diverted attention, a low cloud ceiling, and fog.NTSB CHI07LA273Accident · 1 fatalLimited investigationFinal reportTerpstra Exec 162F · Winamac, INThe inadequate installation of the horizontal stabilizer bracket by the pilot, the fatigue fracture seperation of vertical stabilizer bracket during cruise flight, and the aircraft control not possible by the pilot.NTSB ANC07LA086Accident · No injuriesLimited investigationFinal reportAeronca AR-15 · Clear, AKThe loss of engine power during cruise flight for an undetermined reason.NTSB ANC07LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Fairbanks, AKThe loss of engine power in cruise flight due to a lack of sufficient oil. A factor contributing to the accident was the pilot's improper in-flight decision to continue the flight after noting a loss of oil pressure.NTSB DFW07IA184Incident · Minor injuriesIncident investigationFinal reportBell 407 · Gulf of MexicoFatigue failure of the power turbine outer shaft for undetermined reasons.NTSB NYC07IA199Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Alton, ILThe component manufacturer's inadequate fabrication of the transient voltage suppressor.NTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.NTSB ENG07IA034Incident · No injuriesIncident investigationFinal reportLearjet · Salt Lake City, UTThe fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…NTSB DFW07CA185Accident · No injuriesData collectionFinal reportBell 206 · Houma, LAThe pilot's failure to properly secure all loose items prior to takeoff.NTSB NYC07LA189Accident · Minor injuriesLimited investigationFinal reportStout Gordon Glasair III · Captiva, FLA loss of engine power for undetermined reasons.NTSB MIA07LA132Accident · Minor injuriesLimited investigationFinal reportRoger A Dalke E.B. Jenny · Wakefield, VAThe pilot/owner's inadequate maintenance which resulted in a radiator leak, a loss of engine coolant, the engine overheating, and partial loss of engine power.NTSB DFW07LA172Accident · No injuriesLimited investigationFinal reportCessna 172C · Pascagoula, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA263Accident · Minor injuriesData collectionFinal reportCessna 180 · Princeton, MNThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the fuel siphoning from the right fuel tank.NTSB CHI07CA276Accident · No injuriesData collectionFinal reportGolden Eagle Chief · Hindsboro, ILThe loss of engine power due to the number seven cylinder's separation during cruise and the crops encountered during the forced landing leading to the airplane nosing over.NTSB CHI07CA259Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Creston, IAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel calculations.NTSB ANC07LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe improper [reversed] installation of the fuel selector handle by maintenance personnel.NTSB NYC07LA187Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Chamblee, GAThe pilot’s failure to utilize all of the power available following an engine failure. Contributing to the accident were the failure of the rear engine for undetermined reasons.NTSB CHI07LA252Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Knox, INThe in-flight encounter with turbulence.NTSB LAX07CA244Accident · No injuriesData collectionFinal reportBeech 36 · Jean, NVA loss of engine power for undetermined reasons.NTSB NYC07CA186Accident · No injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Greensboro, VTThe pilot's delayed decision to divert to a suitable landing area. Contributing to the accident was the uneven terrain of the forced landing site.NTSB LAX07CA232Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Eagle Point, ORFuel exhaustion due to the pilot's inadequate fuel consumption calculations.NTSB CHI07CA255Accident · No injuriesData collectionFinal reportButtles SNS-7 · Lapeer, MIThe fuel starvation for an undetermined reason, and the unsuitable terrain encountered during the forced landing. The trees were a factor.NTSB LAX07LA236Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Goleta, CAThe oil starvation and failure of the number one piston connecting rod and bearing that was due to the fragmentation of the number 2 main bearing, which then obstructed the engine oil pickup tube and restricted the flow of oil through the engine.NTSB DEN07LA133Accident · Serious injuriesLimited investigationFinal reportWalker Lancair IV · Sylvan Grove, KSA catastrophic engine failure due to oil starvation when an oil line to the turbocharger wastegate actuator came loose. Contributing factors in this accident were the unsuitable terrain on which to make a forced landing.NTSB LAX07LA233Accident · Minor injuriesLimited investigationFinal reportDehavilland DHC-1B · Olympia, WAThe loss of engine power due to water-contaminated fuel, and maintenance personnel's inadequate inspection of the fuel system.NTSB CHI07CA229Accident · Serious injuriesData collectionFinal reportNetz KIS TR2 · Willow Springs, MOThe improper installation of the aileron control pushrod which led to a separation of the pushrod and subsequent loss of aircraft control. A factor was the pilot not being able to control the airplane after the pushrod separation.NTSB ANC07LA071Accident · No injuriesLimited investigationFinal reportCessna 185E · Talkeetna, AKThe loss of engine power during cruise flight due to an improperly repaired airbox.NTSB DFW07LA173Accident · Serious injuriesLimited investigationFinal reportBell 206B · Grand Prairie, TXThe loss of engine power as result of the failure of one or more of the compressor blades for the 5th stage compressor for undetermined reasons. A contributing factor was the lack of suitable terrain for the pilot to execute a successful autorotation.NTSB CHI07LA240Accident · No injuriesLimited investigationFinal reportAircoupe F-1A · Greenwood, ILThe loss of engine power due to carburetor icing, which resulted in the pilot having to perform a forced landing to unsuitable terrain. Factors contributing to the accident were the carburetor icing conditions and the broken carbuerator heat lever.NTSB MIA07LA130Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus 912M · Suffolk, VAThe improper installation of the engine oil filter. A factor contributing to the accident was unsuitable terrain for a forced landing.NTSB LAX07LA234Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ramona, CAA total loss of engine power due to a short circuit between both magneto ground leads. A factor in the accident was the inadequate annual/100-hour maintenance inspection regarding the wires.NTSB NYC07LA178Accident · No injuriesLimited investigationFinal reportBeech B60 · Orlando, FLThe pilot's improper weather evaluation during cruise flight. Contributing to the accident was the air traffic controller's failure to issue in-flight weather avoidance assistance and the convective turbulence.NTSB NYC07LA177Accident · 1 fatalLimited investigationFinal reportBeech BE-23 · Science Hill, KYA loss of engine power for an undetermined reason.NTSB ANC07LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arecibo, PRThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during climb, and an off-airport forced landing.