NTSB investigations
35,883 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 ERA20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA20 · Luray, VAThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, and collision with terrain.NTSB ERA20LA297Accident · 2 fatalClass 3 · LimitedFinal reportRockwell 500 · Pembroke Park, FLA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the fatigue fracture of an electrical wire in the tank unit or fuel transmitter, which likely resulted in an inaccurate fuel quantity indication.NTSB DCA20WA141Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 24, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All…NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB CEN20WA434IncidentClass 5 · ForeignRaytheon Hawker · Le Bourget, FranceNTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB WPR21WA103AccidentClass 5 · ForeignCessna 150 · Kenitra, MoroccoNTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.NTSB WPR20CA273Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer SGS233 · Warner Springs, CAThe pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20CA335Accident · Serious injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Lafayette, INThe pilot's failure to monitor aircraft control, which resulted in a loss of control when a passenger inadvertently moved the control stick, and the pilot and other passenger's decision to unbuckle their restraints inflight.NTSB WPR20LA259Accident · Serious injuriesClass 3 · LimitedFinal reportRutan Vari EZE · Kelso Valley, CAThe pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA20WA129Accident · No injuriesForeign investigationHawker SEA Fury · Button End, Harston, Cambridgeshire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a HAWKER SEA FURY airplane that occurred on August 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB CEN20WA376Accident · 1 fatalForeign investigationCanadair CL215 1A10 · Lobios (Ourense), PortugalThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…NTSB ERA20LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA25 · Miami, FLA total loss of engine power due to carburetor ice that was not detected by the pilot.NTSB GAA20WA128Accident · 1 fatalForeign investigationRans S6 · Heathfield East Sussex, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB WPR20CA262Accident · Serious injuriesClass 4 · Data collectionFinal reportHead AX8 88 · Jackson, WYThe balloon pilot’s inability to maintain altitude during un-forecasted weather, which resulted in a hard landing.NTSB WPR20LA249Accident · 2 fatalClass 3 · LimitedFinal reportNorth American Navion · Cedar City, UTA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s improper fuel planning and failure to see and avoid the communications tower support guy wire.NTSB CEN20LA322Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Jonesboro, LALoss of engine power due to the use of improper fuel in the airplane by the non-certificated pilot.NTSB ANC20LA074Accident · 7 fatalClass 3 · LimitedFinal reportDe Havilland DHC-2 · Soldotna, AKThe failure of both pilots to see and avoid the other airplane. Contributing to the accident were (1) the PA-12 pilot’s decision to fly with a known severe vision deficiency that had resulted in denial of his most recent application for medical certification…NTSB WPR20LA246Accident · 2 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Elgin, NVThe trailing pilot’s failure to maintain separation from the lead airplane during a fire retardant deployment flight, which resulted in the trailing airplane flying through a plume of retardant and the trailing pilot’s subsequent loss of visibility that led…NTSB GAA20WA125Accident · 1 fatalForeign investigationCessna R172 · Tarapaca-Amazonas, ColombiaNTSB WPR20LA244Accident · 2 fatalClass 3 · LimitedFinal reportAmerican Eurocopter AS350 · Pioche, NVThe pilot’s failure to maintain altitude from terrain and subsequent loss of helicopter control due to entanglement of the external load cable with the tail rotor.NTSB ERA20LA262Accident · 2 fatalClass 3 · LimitedFinal reportBeech F33 · Malbis, ALThe noninstrument-rated pilot’s decision to depart in deteriorating weather conditions, which led to restricted visibility and the pilot’s loss of airplane control due to spatial disorientation. Contributing to the pilot’s poor decision-making was…NTSB CEN20LA314Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Houston, TXThe loss of engine power for a reason that could not be determined based on available evidence.NTSB ANC20WA073Accident · 1 fatalForeign investigationCessna 140 · Abbotsford, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 140 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB GAA20WA126Accident · 4 fatalForeign investigationCessna 172 · Blatten - VS, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB ERA20LA261Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Salinas, PRContamination and corrosion within the fuel system that resulted in a blockage, starvation of fuel to the engine, and the total loss of engine power.NTSB WPR20LA234Accident · No injuriesClass 3 · LimitedFinal reportMontana Coyote · Jamul, CAA total loss of engine power due to an obstructed fuel line and fuel starvation, which resulted in a forced landing and collision with a fence. Contributing to the accident was the long duration of aircraft storage that allowed for contaminants to develop and…NTSB WPR20WA241Incident · No injuriesForeign investigationCessna 441 · Djugun, AustraliaThe government of Australia has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on July 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…NTSB CEN20LA301Accident · No injuriesClass 3 · LimitedFinal reportVans RV4 · Idabel, OKThe pilot’s improper installation of an oil line, resulting in the loss of oil and subsequent total loss of engine power.NTSB CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA20LA258Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Pottstown, PAThe pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB CEN20LA292Accident · No injuriesClass 3 · LimitedFinal reportBeech A23-24 · Burns Flat, OKThe mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.NTSB CEN20LA291Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Arlington, TXThe pilot's failure to maintain directional control during a forced landing with a quartering tailwind, following a partial loss of engine power due to carburetor icing.NTSB CEN20LA290Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Loveland, OHThe loss of engine power due to fuel starvationNTSB ENG20WA039Incident · No injuriesForeign investigationHawker Siddeley HS125 · Port Harcourt, NigeriaOn July 16, 2020 a Hawker-Siddeley (Textron Aviation), powered by two Honeywell TFE731 5R-1H turbofan engines experienced a No. 1 (left engine) audible fire warning during cruise. The flight crew declared an emergency and made an uneventful landing at Port…NTSB CEN20LA288Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Independence, MOFailure of the No. 5 piston head and ring, which resulted in a total loss of engine power and the pilot’s decision to takeoff with a known mechanical issue.NTSB WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.NTSB DCA20WA131Accident · Serious injuriesForeign investigationBoeing 737 · Durban, South AfricaThe CAA of South Africa has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 14, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of ICAO…NTSB ERA20LA245Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Falmouth, KYThe pilot’s failure to ensure that an adequate supply of fuel was available for the flight, which resulted in total loss of engine power due to fuel exhaustion.NTSB DCA20WA132Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC of Mexico's investigation under the provisions of ICAO Annex…NTSB CEN20WA293Accident · Serious injuriesForeign investigationCessna FR172 · Galway, IrelandThe government of the Ireland has notified the NTSB of an accident involving a Cessna FR172K airplane that occurred on July 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…NTSB CEN20LA279Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Dalhart, TXThe total loss of engine power due to a failed fuel control unit bearing.NTSB DCA20CA122Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer ERJ170 · Plainfield, ILan encounter with convective turbulence.NTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…NTSB WPR20LA211Accident · 1 fatalClass 3 · LimitedFinal reportBell UH1H · Payson, AZA flight control malfunction due to either a hydraulic hardover or a flight control stiffness event, which resulted in a loss of control.