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 ERA11CA237Accident · No injuriesData collectionFinal reportCessna 182A · Lesage, WVA loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.NTSB WPR11LA193Accident · Minor injuriesLimited investigationFinal reportBartholomew Lancair 320 · Temple Bar, AZThe pilot did not use carburetor heat in cruise flight while operating in an area conducive to carburetor icing, which resulted in a loss of engine power.NTSB ERA11WA245Accident · 2 fatalForeign investigationBell 206B · Santo Andre City, BrazilOn April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…NTSB CEN11IA286Incident · No injuriesIncident investigationFinal reportCessna 560XL · Abbeville, LAThe pitch trim control cable failed due to fatigue, rendering the elevator trim inoperative.NTSB CEN11FA274Accident · Minor injuriesField investigationFinal reportBeech A36 · Monaville, TXA total loss of engine power for undetermined reasons.NTSB WPR11FA188Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Laramie, WYThe pilot’s failure to maintain airplane control and to recover from an aerodynamic stall, which resulted in a spin.NTSB ERA11WA251Accident · 3 fatalForeign investigationEurocopter AS-355-F2 · Alto Alegre, BrazilOn April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…NTSB WPR11FA186Accident · No injuriesField investigationFinal reportCessna 177RG · Gila Bend, AZA total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.NTSB WPR11CA197Accident · No injuriesData collectionFinal reportXtremeair Sbach 342 · Springerville, AZThe pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.NTSB ERA11LA230Accident · No injuriesLimited investigationFinal reportCessna 172P · Vega Baja, PRThe failure of the No. 2 cylinder exhaust valve resulting in a loss of engine power.NTSB DCA11MA039Accident · Minor injuriesMajor investigationFinal reportBoeing 737 · Yuma, AZthe improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…NTSB CEN11CA255Accident · No injuriesData collectionFinal reportCessna 182P · Humnoke, ARThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11FA263Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Fredricktown, MOThe pilot's decision to attempt to maintain visual flight by descending below an area of deteriorating forecast weather to an altitude that did not provide adequate terrain clearance.NTSB OPS11IA428Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Orlando, FLThe air traffic controllers’ application of inappropriate separation between the B737 and the Cirrus and their inappropriate use of airborne civilian aircraft for observation of other airborne aircraft. Contributing to the incident was the crew of the B737's…NTSB ERA11CA217Accident · No injuriesData collectionFinal reportCessna 150F · Hannawana Falls, NYThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA250Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Kansas City, MOAn in-flight encounter with convectively induced turbulence associated with developing thunderstorms under the flight path during the airplane's climb to cruise flight.NTSB ERA11WA252Incident · No injuriesForeign investigationReims-Cessna F-150 · Sotttomarina di Chioggia, ItalyOn March 25, 2011, about 1200 universal coordinated time, a Reims-Cessna F-150 airplane, Italian registration I-NOLV, had a reported engine failure while in cruise flight. The pilot decided to land on the shoreline in the vicinity of Sottomarina di Chioggia,…NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA11GA207Accident · 1 fatalFinal reportCessna A185F · Ashland, MEAn inadvertent encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.NTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.NTSB WPR11FA173Accident · 3 fatalField investigationFinal reportCessna P210 · Daggett, CAThe pilot's decision to conduct the flight into a region of reported moderate to severe turbulence and icing conditions, followed by a loss of airplane control and an aerodynamic spin from which the pilot did not recover.NTSB CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.NTSB ERA11LA197Accident · No injuriesLimited investigationFinal reportBurr Andrew E Xiv Rotorway Exec 162F · Lincoln, ALA total loss of engine power during cruise flight for undetermined reasons.NTSB CEN11CA241Accident · Minor injuriesData collectionFinal reportCessna 150M · Garland, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA237Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Austin, TXThe loss of engine power due to fuel starvation for undetermined reasons.NTSB ENG11IA021Incident · No injuriesIncident investigationFinal reportBombardier DHC 8 402 · Pittsburgh, PAthe flight crew's delay in shutting down the left engine following an engine oil pressure master warning, which led to a hard rub inside the engine that served as an ignition point for a titanium fire. Contributing to the event was a PW150 No. 5 seal design…NTSB WPR11LA167Accident · No injuriesLimited investigationFinal reportRotorway A600 · Chandler, AZA design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.NTSB ERA11LA190Accident · No injuriesLimited investigationFinal reportCessna 182P · Alachua, FLA loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.NTSB WPR11LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Agoura Hills, CAThe loss of engine power during cruise flight for undetermined reasons.NTSB ERA11FA185Accident · 1 fatalField investigationFinal reportCessna 310R · Smyrna, TNThe pilot's improper response to a known autopilot pitch divergence anomaly. Contributing to the accident was the pilot's decision to perform a test flight on a system for which he lacked a complete working knowledge.NTSB CEN11FA227Accident · No injuriesField investigationFinal reportLancair LC41-550FG · Carbondale, ILThe fatigue fracture and subsequent failure of the No. 2 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.NTSB ERA11IA184Incident · No injuriesIncident investigationFinal reportCessna 560XL · Haynesville, VAThe manufacturer's inadequate design fix for previously known tailcone stinger water ingestion and retention.NTSB CEN11LA226Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Bulverde, TXThe in-flight separation of the fuel cap, which impacted the helicopter’s tail rotor and resulted in the loss of tail rotor thrust. Contributing to the accident was the inadequate preflight inspection by both pilots, who did not ensure that the fuel cap was…NTSB WPR11FA156Accident · 2 fatalField investigationFinal reportDouglas AD-4N · Twin Falls, IDThe non-instrument-rated pilot’s encounter with localized instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA11FA182Accident · 1 fatalField investigationFinal reportDiamond DA-40 · Allagash, METhe pilot's inadvertent encounter with icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing was the pilots’ inadequate preflight weather planning.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.NTSB ERA11LA179Accident · No injuriesLimited investigationFinal reportBeech C23 · Carrollton, GAThe mechanic's failure to re-connect a fuel line following an annual inspection. Contributing to the accident was the pilot's improper decision to depart with a known mechanical deficiency.NTSB WPR11LA149Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Naches, WAThe airplane's encounter with moderate turbulence at a higher altitude than the flight crew expected, resulting in an injury to a cabin crewmember.NTSB WPR11FA147Accident · 1 fatalField investigationFinal reportNeefjes Lancair 360 MK-II · Milford, UTThe pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…NTSB CEN11FA202Accident · Minor injuriesField investigationFinal reportCessna T210M · Independence, MOLatent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…NTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.NTSB ERA11WA211Accident · 6 fatalForeign investigationCessna 340 · Tachira, VenezuelaOn February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…NTSB WPR11LA140Accident · No injuriesLimited investigationFinal reportRearwin 8135 · Casa Grande, AZThe partial loss of engine power due to the separation of an exhaust valve rocker box as a result of the failure of the rocker box attaching studs.NTSB ERA11WA159Accident · 1 fatalForeign investigationRobinson R44 · Canne della Battaglia, ItalyOn February 18, 2011, about 0706 universal coordinated time, a Robinson R44, French registration F-GUJB, crashed after an in-flight separation of the tail rotor from the fuselage. The pilot was killed. The flight departed Bari, Italy, for Foggia Airport…NTSB ERA11WA155Accident · 4 fatalForeign investigationBell 206 · Vereda Galan, ColombiaOn February 18, 2011, about 0415 universal coordinated time, a Bell 206-B, Colombian registration HK-4594, operated by Heliservice LTDA, crashed in mountainous terrain near Vereda Galan, Colombia, and was consumed by a post crash fire. Instrument…NTSB ERA11LA150Accident · Minor injuriesLimited investigationFinal reportFlaglor Tom Kolb Aircraft MK III · Stetson, METhe in-flight failure of the No. 1 composite propeller blade due to fatigue, which resulted in a violent vibration, loss of engine power, and a subsequent forced landing to unsuitable terrain.NTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.NTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.NTSB ERA11LA173Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Anderson, SCThe total loss of engine power due to the formation of carburetor ice.