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 SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB MKC89LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tunas, MOEngine failure due to fuel exhaustion because of improper flight planning by the pilot.NTSB MKC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Excelsor Sprgs, MOThe catastrophic failure of the aircraft engine and the pilots failure to maintain directional control of the aircraft during the landing roll. Improper maintenance, the dark night conditions, and restricted visibility due to oil on the windscreen were…NTSB FTW89FA128Accident · 1 fatalField investigationFinal reportCessna P210N · Houma, LAIncapacitation of the 70 year old pilot, which led to the loss of control of the airplane.NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB ATL89FA174Accident · 1 fatalField investigationFinal reportPiper PA-30 · Springfield, TNThe pilot's decision to continue flight into an area of known adverse weather which resulted in his ability to maintain control of the airplane. Contributing factor(s) was: the adverse weather conditions.NTSB MIA89LA182Accident · No injuriesLimited investigationFinal reportCessna T188C · Hollandale, MSThe failure of the turbocharger due to an improperly installed retaining nut. The soft/wet terrain was a contributing factor.NTSB LAX89LA228Accident · No injuriesLimited investigationFinal reportCessna 150 · Kelseyville, CAInadequate preflight planning/preparations and the improper fuel consumption calculations by the pilot.NTSB LAX89DVM04Accident · Serious injuriesFinal reportProgress Aero R&D Discovery · Chualar, CAThe experimental aircraft's inadvertent entry into a non-recoverable flat spin during a slow airspeed test; the aerodynamic characteristics that produced the spin were not determined.NTSB NYC89LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Middletown, RIThe failure of both magnetos shortly after takeoff. .NTSB MKC89FA159Accident · 6 fatalField investigationFinal reportCessna U206 · Pettigrew, ARImproper planning/decision by the pilot, his VFR flight into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related the accident were: the adverse weather conditions, high terrain, the…NTSB BFO89LA053Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Ocean City, MDLoss of engine power from exhaust gas leakage into the carburetor inlet, causing engine air starvation, and material failure of the exhaust manifold. .NTSB ATL89FA173Accident · 4 fatalField investigationFinal reportCessna 210H · Piney Flats, TNThe pilot's failure to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft while attempting to recover from an uncontrolled descent. Factors related to the accident were: darkness,…NTSB NYC89LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Southampton, MAImproper maintenance which resulted in a section of the vertical stabilizer failing inflight.NTSB BFO89LA050Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Weirton, WVLoss of engine power due to water in the fuel and inadequate preflight inspection of the airplane by the pilot.NTSB NYC89DHA01Accident · No injuriesFinal reportVehafric Jungster ONE · Reading, PAThe failure of the pilot to properly use carburetor heat.NTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.NTSB DEN89FA154Accident · 2 fatalField investigationFinal reportCessna 310Q · Crestone, COImproper in-flight planning/decision by the pilot and his failure to attain sufficient altitude to safely clear the mountains. Contributing factors were: mountainous terrain, box canyon, and high density altitude.NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB LAX89LA235Accident · No injuriesLimited investigationFinal reportCessna 172E · Mariposa, CAStudent pilot's miscalculation of the fuel supply which led to a loss of engine power due to fuel exhaustion.NTSB FTW89LA118Accident · Minor injuriesLimited investigationFinal reportPiper PA-601B · Cleveland, TXA loss of engine power, due to fuel starvation because the plt misjudged his fuel supply and distribution of fuel per tanks, and as a result mismanaged the supply remaining.NTSB FTW89LA116Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXImproper planning/decision by the solo student pilot and inadequate supervision by the student's instructor pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the instructor pilot's lack of…NTSB DEN89FA146Accident · 1 fatalField investigationFinal reportBeech 35 · Glenrock, WYProper altitude not maintained by the pilot. The weather/night conditions and pilot fatigue were considered to be contributing factors.NTSB CHI89LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middletown, OHFuel starvation from improper movement of the fuel selector by the pilot and his improper use of emergency procedures during the attempted engine restart. Contributing factors were the pilot's lack of experience in this type of aircraft and the terrain…NTSB MKC89LA142Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waldenburg, ARThe total failure of the engine supercharger which resulted in a loss of engine power.NTSB FTW89LA115Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Waco, TXA deteriorated fuel cap, water contamination of the fuel, and the pilot's inadequate preflight of the aircraft. A factor related to the accident was: the dirt bank (berm).NTSB ANC89LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tuntutuliak, AKFailure of the engine crankshaft. A contributing factor to aircraft damage was a mud (dirt) bank which the aircraft hit during the emergency landing.NTSB MKC89LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Rapids, MNFailure of the pilot to properly secure the oil cap when he serviced the aircraft and oil starvation. Contributing factors were the terrain conditions.NTSB LAX89FA225Accident · 4 fatalField investigationFinal reportAerospatiale TB-21 · Newhall, CAFuel contamination, due to the pilot's lack of familiarity with the aircraft fuel system, and inadequate maintenance. A related factor was: inadequate transition training.NTSB CHI89LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Indianapolis, INFuel contamination from a deteriorating part in the carburetor. The trees and improper maintenance/servicing of the aircraft were probable contributing factors.NTSB SEA89LA115Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Battle Mountain, NVThe loss of engine power in flight due to a broken number two rocker arm. Contributing to the accident was the vehicle on the road which resulted in the pilot flaring prematurely.NTSB DEN89LA144Accident · No injuriesLimited investigationFinal reportBeauchesne/Wells Glasair TD · Moriarity, NMImproper installation of the propeller which resulted in severe vibration and failure of the propeller mounting bolts, & the separation of the propeller from the aircraft. Rough/uneven desert terrain contributed to the accident.NTSB ATL89FA166Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lithia Springs, GAInflight engine/wing fire due to a failure of the right engine's left exhaust tailpipe. The exhaust tailpipe failed in fatigue as a result of fluctuating stresses induced by a deteriorated engine mount in conjunction with unevenly distributed clamping loads…NTSB SEA89LA114Accident · 1 fatalLimited investigationFinal reportHughes Bensen B-8M · The Dalles, ORThe pilots poor judgement in attempting low level flight in a narrow valley during high wind conditions.NTSB SEA89FA113Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Stanley, IDPilot continued VFR flight into IMC conditions in mountainous terrain. Factors were snow squalls and obscured mountainous terrain in the area.NTSB NYC89LA151Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415C · Canaan, CTAn off airport landing in unsuitable terrain due to a power loss, caused by loose parts in the fuel pump.NTSB FTW89LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Minden, LAThe loss of engine power due to improper maintenance performed during an annual inspection 1.6 flying hours prior to the accident which resulted in the mixture control becoming disconnected.NTSB ATL89FA165Accident · 4 fatalField investigationFinal reportBeech B-60 · Gaston, SCThe pilot exercised questionable judgement in initiating a flight into an area of known thunderstorms. Further, either deliberately or inadvertantly entered a thunderstorm and overstressed the airframe structure resulting in an inflight separation of the…NTSB NYC89LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Niagara Falls, NYEngine failure due to oil starvation and collision with terrain during the forced landing. The oil starvation was caused by the oil leaking out of the drain because maintenance personnel failed to install the drain plug.NTSB MIA89FA177Accident · 1 fatalField investigationFinal reportUhley-Mason R.A.F. VARI-EZE · Lantana, FLPilots inadvertent turning off of the engine ignition switches resulting in engine failure.NTSB LAX89LA220Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Sacramento, CAFuel exhaustion due to the pilot's failure to accurately determine the fuel load prior to departure.NTSB LAX89LA216Accident · No injuriesLimited investigationFinal reportCessna 175K · Bagdad, AZTotal loss of engine power due to undetermined reasons.NTSB ATL89FA163Accident · 1 fatalField investigationFinal reportCessna 172F · Vernon, ALImproper maintenance of the spark plugs by the pilot/mechanic which resulted in a partial loss of engine power, and the pilot's failure to clear trees during an emergency landing in an open field resulting in an inadvertent stall.NTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…NTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.NTSB ANC89FA094Accident · 4 fatalField investigationFinal reportPiper PA-22 · Kenai, AKInadequate preflight by the pilot and fuel exhaustion.NTSB MKC89FA135Accident · 1 fatalField investigationFinal reportCessna A185F · Ely, MNLoss of engine power for an undetermined reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB MIA89FA176Accident · 1 fatalField investigationFinal reportBoeing A-75 · Daytona Beach, FLThe biplane pilot failed to see and avoid the collision with the banner being towed by the other airplane.NTSB ANC89FA092Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Puntilla Lake, AKThe pilot continued VFR flight into instrument meteorological conditions (IMC) and failed to maintain sufficient altitude to clear the mountainous terrain. The weather and terrain conditions were contributing factors.NTSB NYC89LA148Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dillsburg, PAThe engine stoppage caused by the lack of engine lubricant.