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 CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.NTSB DEN99LA139Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Elizabeth, COA forced landing on unsuitable terrain following a total loss of power for non mechanical reasons. Factors were the pilot's failure to follow emergency procedures for restarting the engine, operating the aircraft with known deficiencies, and inaccurate…NTSB ANC99FA106Accident · 2 fatalField investigationFinal reportCessna 180A · Kenai, AKThe pilot's intentional visual flight into known adverse weather. Factors associated with this accident were the reported low ceilings, obscuration, high winds, and turbulence.NTSB MIA99LA213Accident · No injuriesLimited investigationFinal reportWilliam Jay Kinney Challenger II · Pahokee, FLfailure of the engine to propeller drive belt for undetermined reasons, resulting in loss of engine power, and a forced landing to unsuitable terrain.NTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…NTSB CHI99LA272Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · North Platte, NEThe pilot's improper inflight planning decision which resulted in fuel exhaustion. A factor associated with the accident was the dark night conditions.NTSB NYC99FA187Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · North Lima, OHThe pilot's loss of control of the airplane during a turn. Factors include the pilot's failure maintain sufficient airspeed, and his failure to maintain the airplane in proper trim.NTSB MIA99LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Greenville, SCA total loss of engine power while in descent for landing due to fuel exhaustion as a result of the pilot's failure to properly plan and load the fuel required, and the subsequent collision with the terrain during a forced landing.NTSB ANC99LA101Accident · No injuriesLimited investigationFinal reportHaering Avid Flyer Avid Flyer · Anchorage, AKA loss of engine power due to blockage of the airplane fuel system, a delamination of the fiberglass fuel tanks, and the usage of an improper fuel. A factor associated with the accident was the failure of the kit manufacturer to inform the pilot/owner against…NTSB CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB FTW99LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Sanger, TXThe failure of the pilot-in-command to maintain clearance with the power line.NTSB FTW99LA206Accident · No injuriesLimited investigationFinal reportMooney M20J · Mount Pleasant, TXThe separation of the fuel line fitting as a result of fatigue. A factors was the lack of suitable terrain for a forced landing.NTSB DEN99LA131Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Fairplay, COA partial loss of engine power due to a partial failure of the turbocharger.NTSB MIA99TA206Accident · No injuriesFinal reportHughes OH-6A · Aguadilla, PRAn unidentified foreign object passing through the oil cooler blower assembly resulting in fracture and seizure of the oil cooler blower, and slowing of the main transmission and main rotor, which resulted in the pilot being unable to arrest the descent…NTSB ANC99LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-269B · Anchorage, AKThe failure of a turbine blade, and subsequent penetration of the shroud (containment ring). A factor associated with the accident was the FAA's insufficient design standards/requirements addressed in an FAA Air Worthiness Directive, which called for a…NTSB MIA99LA205Accident · No injuriesLimited investigationFinal reportCessna R172K · Pontotoc, MSa complete loss of engine power due to the failure of the oil pressure pump, resulting in oil starvation, a forced landing and subsequent nose over.NTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.NTSB CHI99LA257Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Jetmore, KSThe pilot's use of improper procedures by not following the helicopter manufacturer's recommended engine RPM reduction procedures during autorotations. A factor was the pilot not attaining the proper rotor RPM during the autorotation practice.NTSB NYC99LA184Accident · No injuriesLimited investigationFinal reportTroy Pietenpol · Collins, OHIn-flight separation of the propeller.NTSB CHI99LA253Accident · No injuriesLimited investigationFinal reportBeech B36TC · Brookfield, MOthe total mechanical failure of the engine crankshaft due to fatigue. A factor was the ditch encountered on landing.NTSB NYC99LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Manville, NJThe pilot's failure to follow the checklist and improper use of the carburetor heat. A factor in the accident was determined to be the density altitude.NTSB LAX99LA256Accident · No injuriesLimited investigationFinal reportCessna 172E · Emeryville, CAThe pilot's inadequate in-flight planning and inadequate fuel consumption calculations, resulting in a total loss of engine power due to fuel exhaustion. Factors were the pilot's failure to have all appropriate flight manuals aboard the airplane and the low…NTSB DEN99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Limon, COThe pilot's selection of the wrong runway for takeoff. Factors were a direct tailwind and high density altitude that deteriorated the airplane's climb capability, and unsuitable terrain on which to make a forced landing.NTSB ANC99LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Mcgrath, AKThe pilot's improper management of the fuel supply, and subsequent fuel starvation. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.NTSB CHI99LA261Accident · Serious injuriesLimited investigationFinal reportHodre-Buull-Kolb Mark III · Plymouth, MNThe failure of the airplane's rudder control pulley due to corrosion and inadequate maintenance inspection of the airplane by the owner/pilot mechanic of the airplane.NTSB ANC99LA093Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingham, AKThe inadequate preflight by the pilot, which failed to detect water contamination of the airplane's fuel.NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.NTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…NTSB FTW99LA191Accident · No injuriesLimited investigationFinal reportBell OH-58A · Bastrop, LAThe failure of the refueling truck's filter to separate water resulting in the water contamination in the helicopter's fuel system and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.NTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.NTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.NTSB NYC99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Isle Of Wight, VAThe improper visual inspection of overhauled engine components by maintenance personnel.NTSB DEN99LA117Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hobbs, NMThe pilot's inadequate in-flight planning. Factors were the loss of thermal lift, the subsequent stall/spin, and the fence post that he impacted.NTSB MIA99LA195Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Lake City, FLthe improper maintenance and inspection of the propeller system, which resulted in loose and improperly torqued bolts, causing the subsequent failure of a propeller blade.NTSB LAX99LA246Accident · No injuriesLimited investigationFinal reportSmith Avid Stol Hauler · S. Lake Tahoe, CAA loss of engine power for undetermined reasons.NTSB IAD99FA052Accident · Serious injuriesField investigationFinal reportBoeing 737-824 · Atlantic Ocean (Atlantic Ocean)the aircrew's inadvertent encounter with unforecast clear air turbulence.NTSB SEA99LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cottage Grove, ORThe pilot's inadequate management of fuel which led to fuel starvation.. A related factor was the unsuitable terrain.NTSB SEA99LA108Accident · Serious injuriesLimited investigationFinal reportWilliamson/Williamson RV-4 · Coos Bay, ORInadequate aircraft preflight inspection (engine air inlet cover not removed) by the pilot, resulting in obstruction of the carburetor air inlet in flight and consequent inflight engine stoppage. Factors contributing to the accident included a vehicle…NTSB NYC99LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, VAThe pilot's failure to adequately calculate required fuel for the flight, which resulted in a total loss of engine power.NTSB LAX99LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Luis Obispo, CAA loss of engine power due to contamination of the induction system and the carburetor throat. Factors in the accident were a prior undetected carburetor fire, which caused a deterioration in the air duct material.NTSB CHI99LA226Accident · No injuriesLimited investigationFinal reportCessna 177RG · Weldon Springs, MOthe loss of engine oil for undetermined reasons. A factor was the trees.NTSB CHI99LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Addison, ILThe pilot's improper fuel selector positioning resulting in fuel starvation during cruise.NTSB CHI99LA212Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lyons, KSThe pilot's inadequate fuel management leading to fuel exhaustion.NTSB CHI99LA209Accident · No injuriesLimited investigationFinal reportCessna 180A · White Bear Lake, MNthe pilot's inability to get the airplane to climb for undetermined reason, and the pilot landing the floatplane on the lake with the wheels extended. Factors contributing to this accident were the pilot's failure to perform a before landing checklist,…NTSB CHI99LA210Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Jacksonville, ILA material defect in the sloshing compound. Factors were the blocked fuel system, inspection not identifying material defect, and the crop field.NTSB SEA99LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Garden Valley, IDLoss of engine power due to fuel exhaustion because the pilot failed to refuel the airplane. A ditch in the landing area was a contributing factor in the accident.NTSB FTW99LA179Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Theriot, LAThe pilot's inadequate preflight inspection which led to a contaminated fuel supply and subsequent loss of engine power. A factor was the lack of suitable terrain available for the forced landing.