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 WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB GAA16CA020Accident · No injuriesData collectionFinal reportBeech A36 · Jasper, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB CEN16LA012Accident · No injuriesLimited investigationFinal reportRefling RV8 · Bottineau, NDThe pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.NTSB ENG16IA001Incident · No injuriesIncident investigationFinal reportBoeing 747 · Russian airspace, JapanThe PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…NTSB CEN16FA001Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Huntsville, TXThe pilot's mismanagement off the fuel supply to the engine, which resulted in fuel starvation.NTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.NTSB ERA15LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28RT-201T · Dawson Springs, KYThe fatigue failure of a crankshaft counterweight, which resulted in a total loss of engine power during cruise flight.NTSB CEN15LA432Accident · 1 fatalLimited investigationFinal reportRans S18 · Shattuck, OKThe noncertificated pilot’s failure to maintain control of the unregistered airplane during initial climb and his subsequent exceedance of the airplane’s critical angle-of-attack, which resulted in a stall/spin.NTSB CEN15LA430Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Glenwood Springs, COA loss of engine power during cruise flight due to carburetor icing and the pilot's failure to apply carburetor heat, which resulted in a forced landing on rough/uneven terrain.NTSB CEN15WA429Accident · 4 fatalForeign investigationPiper PA28 · Sandstedt, GermanyOn September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…NTSB CEN15LA433Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fort Wayne, INThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB CEN15LA421Accident · Serious injuriesLimited investigationFinal reportLerch RV6A · Deckerville, MIThe in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.NTSB CEN15WA456Accident · 1 fatalForeign investigationAmateur Construction Glasair RG · Muhen, SwitzerlandOn September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.NTSB DCA15WA197Incident · No injuriesForeign investigationBoeing 737 · Frankfort, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB GAA15CA261Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lexington, NEThe pilot's improper fuel planning which resulted in fuel exhaustion, and loss of engine power. Additionally, the pilot's failure to maintain pitch control during the emergency landing, which resulted in an aerodynamic stall.NTSB DCA15WA203Incident · No injuriesForeign investigationAirbus A320 · Perth, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB CEN15WA454Accident · 2 fatalForeign investigationRobinson R44 · Foleyet, CanadaOn September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…NTSB ERA15LA345Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Atmore, ALA total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB CEN15FA400Accident · 4 fatalField investigationFinal reportCessna 310H · Silverton, COThe noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.NTSB ERA15LA338Accident · Serious injuriesLimited investigationFinal reportCessna R172 · Cresskill, NJMaintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts during installation of the engine cylinders, which resulted in the loosening of the components, loss of lubrication, failure of the crankshaft, and the…NTSB ERA15FA336Accident · 1 fatalField investigationFinal reportHenderson W A/Johnson W L RV 6A · Bon Aqua, TNThe pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.NTSB WPR15LA254Accident · Minor injuriesLimited investigationFinal reportRaudenbush Ernie Lancair Super ES · Winkelman, AZA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB ERA15WA371Accident · 2 fatalForeign investigationEmbraer EMB721 · Sao Felix do Xingu, BrazilOn August 30, 2015, about 1830 universal coordinated time, an Embraer EMB721, Brazilian registration PT-EPD, was substantially damaged during a forced landing after a loss of engine power near São Félix do Xingu Municipality, State of Pará, Brazil. The…NTSB ERA15LA333Accident · No injuriesLimited investigationFinal reportBeech E 90 · Fayetteville, TNA total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.NTSB CEN15IA385Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Joliet, ILA bird strike.NTSB ERA15WA347Accident · 3 fatalForeign investigationCessna TU206B · Lib Mandy, PeruNTSB CEN15LA379Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ketchum, OKThe separation of the tail rotor gearbox from the tailboom aft bulkhead due to overstress loads imposed by a blade imbalance from an in-flight impact with an undetermined object.NTSB ERA15LA323Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dorado, PRA short circuit of unknown origin, which resulted in electrical arcing in the engine compartment and smoke in the cockpit, which necessitated a precautionary landing to a field.NTSB ERA15CA327Accident · No injuriesData collectionFinal reportCessna 172 · Riviera Beach, FLThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to icing, which resulted in a total loss of power.NTSB DCA15WA213Accident · Serious injuriesForeign investigationAirbus A330 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving an AIRBUS A330 that occurred on August 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…NTSB CEN15LA396Accident · No injuriesLimited investigationFinal reportBurns Mini 500 · Butler, MOThe pilot's failure to attain a proper landing flare following an autorotation for reasons that could not be determined based on available information.NTSB CEN15LA395Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron Canada 429 · Port O'Connor, TXThe fatigue failure of the tail rotor pitch change link spherical bearing housing as a result of corrosion pitting.NTSB CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.NTSB WPR15FA247Accident · 2 fatalField investigationFinal reportCessna 172P · Townsend, MTThe non-instrument-rated pilot's decision to conduct a cross-country flight over a mountain range in dark night conditions with limited night flight experience, which resulted in a collision with mountainous terrain.NTSB CEN15LA369Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Bolivar, MOTotal electrical failure due to a failed voltage regulator and the pilot’s failure to maintain a proper airspeed during a precautionary landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA15LA318Accident · No injuriesLimited investigationFinal reportCessna 172K · Chiefland, FLThe partial loss of engine power during cruise flight for reasons that could not be determined because a postaccident airframe and engine examination and engine test run revealed no evidence of mechanical malfunctions or failures.NTSB GAA15CA234Accident · Minor injuriesData collectionFinal reportBurton Dennis W Sonex · Wolcottville, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, a forced off-airport landing, and nose over.NTSB ERA15FA313Accident · 1 fatalField investigationFinal reportBeech C35 · Hicksville, NYThe pilot's improper decision to delay turning toward a suitable runway once he realized that an engine failure had occurred, which resulted in his having inadequate altitude to glide to a suitable runway, and the New York terminal radar approach control…NTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.NTSB ANC15CA064Accident · No injuriesData collectionFinal reportChampion 7HC · Coldfoot, AKThe loss of engine power due to carburetor icing and the pilot's failure to recognize conditions favorable for carburetor icing and apply use of carburetor heat.