OpenAirDocs.org

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.

NTSB FTW95LA098Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Placitas, NMThe pilot operated beyond the climb capability of the helicopter, resulting in inadequate altitude and terrain clearance over mountainous rising terrain. A factor was turbulence.Jan 22, 1995 · N269ME · Substantial damageNTSB SEA95LA040Accident · No injuriesLimited investigationFinal reportCessna A185E · Hillsboro, ORA loss of engine power for undetermined reasons.Jan 21, 1995 · N748 · Substantial damageNTSB CHI95FA071Accident · 2 fatalField investigationFinal reportBacon QUESTAIR-VENTURE · Des Moines, IAThe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall/spin. Factors were material defects in the material used to manufacture the crankshaft, resulting in the crankshaft fracturing after approximately 200 hours in…Jan 21, 1995 · N4QV · DestroyedNTSB FTW95LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Prescott, ARFuel exhaustion due to the pilot's failure to refuel. Factors were the pilot's disorientation and lack of suitable terrain for a forced landing.Jan 20, 1995 · N704CH · Substantial damageNTSB MIA95FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · York, SCThe noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…Jan 19, 1995 · N8423B · DestroyedNTSB ATL95LA042Accident · No injuriesLimited investigationFinal reportMatto KR-2A Modified · Boone, NCThe failure of the propeller retaining bolts for an undetermined reason, which resulted in the separation of the propeller from the engine. The rising, mountainous terrain was a factor.Jan 18, 1995 · N612W · Substantial damageNTSB BFO95LA027Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Clarion, PAThe failure of the right wing de-ice boot during operation in conditions of ice accumulation, which resulted in a loss of aircraft controllability during the approach/landing. The icing condition was a factor.Jan 16, 1995 · N7943Q · DestroyedNTSB LAX95FA079Accident · 2 fatalField investigationFinal reportBell 206B · Los Angeles, CAThe pilot's continued VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's and operator's failure to follow their established dispatch procedures, the pilot's poor judgment in initiating the flight,…Jan 15, 1995 · N2209P · DestroyedNTSB ANC95LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Anvik, AKThe pilot's failure to follow the procedure in the pilot's operating handbook concerning the uneven distribution of fuel, and starvation of the fuel intake line by unporting.Jan 15, 1995 · N6867X · Substantial damageNTSB SEA95FA037Accident · 3 fatalField investigationFinal reportCessna 172N · Blyn, WAThe pilot's VFR flight into instrument meteorological conditions. Factors in the accident were the weather conditions and the dark night.Jan 14, 1995 · N1535E · DestroyedNTSB LAX95FA077Accident · 1 fatalField investigationFinal reportCessna 208B · Pleasanton, CAfailure of the pilot-in-command to maintain visual contact with terrain and sufficient altitude for terrain clearance. Factors in the accident were the pilot's decision to initiate a descent 14 miles from the airport, and weather, specifically cloud…Jan 13, 1995 · N754FE · DestroyedNTSB CHI95IA066Incident · No injuriesIncident investigationFinal reportBeech 1900D · Williston, NDthe improper installation and inadequate quality assurance inspection of the elevator trim cable during original manufacture, which resulted in fraying and failure of the cable prior to the first routine scheduled inspection of the system.Jan 12, 1995 · N118UX · Minor damageNTSB ATL95FA044Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Spring City, TNThe pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.Jan 12, 1995 · N75PF · DestroyedNTSB ATL95FA036Accident · 4 fatalField investigationFinal reportCessna 414 · Augusta, GAThe loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.Jan 12, 1995 · N13SE · DestroyedNTSB NYC95FA049Accident · 1 fatalField investigationFinal reportBeech G35 · West Palm Beach, FLImproper top overhaul by maintenance personnel, and improperly torqued crackcase thru-bolts and cylinder deck studs at the number one cylinder, which led to fatigue failure of four of the bolts, failure and/or separation of the number one cylinder, and a…Jan 9, 1995 · N32TS · DestroyedNTSB MIA95LA056Accident · Minor injuriesLimited investigationFinal reportMooney 20J · St. Petersburg, FLThe failure of the No. 3 connecting rod bolt due to oil starvation for undetermined reasons. This resulted in a total loss of engine power, forced landing, and subsequent ditching.Jan 8, 1995 · N205MD · Substantial damageNTSB MIA95LA055Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Monroe, LAan in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.Jan 6, 1995 · N981DL · No damageNTSB FTW95FA084Accident · 1 fatalField investigationFinal reportPiper PA-30 · Georgetown, TXLoss of power in both engines and loss of aircraft control for unknown reasons.Jan 6, 1995 · N8398Y · DestroyedNTSB FTW95FA082Accident · 3 fatalField investigationFinal reportBeech A60 · Hurley, NMThe pilot's failure to maintain airspeed during a single engine approach resulting in an inadvertent stall. Factors were a fatigue separation of a shaft in the left engine turbocharger due to use of a Federal Aviation Administration approved overhaul…Jan 6, 1995 · N3LP · DestroyedNTSB LAX95LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe improper supervision of the student pilot by the instructor by allowing the student to inadvertently pull the mixture control handle too far out causing the engine to lose power. The wet terrain condition was a factor.Jan 5, 1995 · N25953 · Substantial damageNTSB CHI95LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Int'L Falls, MNengine oil exhaustion due to a frozen crankcase breather line and noncompliance with an airworthiness directive.Jan 4, 1995 · CFGDZ · Substantial damageNTSB BFO95FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Miamisburg, OHThe pilot's failure to switch fuel tanks which led to fuel starvation and subsequent loss of engine power.Jan 4, 1995 · N8435P · DestroyedNTSB MIA95LA054Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot's failure to maintain altitude while descending over a lake, resulting in an in-flight collision with water.Jan 3, 1995 · N6172 · Substantial damageNTSB LAX95FA072Accident · 1 fatalField investigationFinal reportCessna A185F · Tehachapi, CAThe noninstrument-rated pilot's continued flight into known adverse weather, and his failure to maintain adequate airspeed while maneuvering to reverse direction. Factors relating to the accident were: the mountainous terrain, and adverse weather conditions.Jan 3, 1995 · N94296 · DestroyedNTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.Jan 2, 1995 · N200AW · Substantial damageNTSB ATL95LA032Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Union City, TNThe improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.Jan 2, 1995 · N77FH · Substantial damageNTSB MIA95LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakeland, FLFatigue failure of the engine no.1 valve spring that jammed the intake valve open resulting in partial loss of engine power.Dec 31, 1994 · N4300S · Substantial damageNTSB LAX95LA067Accident · 1 fatalLimited investigationFinal reportHarris BD-10 · Gardnerville, NVthe in-flight overload failure of the left vertical stabilizer spars, at force levels substantially below the predicted ultimate failure loads, due to inadequate substantiation by the designer.Dec 31, 1994 · N9WZ · DestroyedNTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.Dec 31, 1994 · N2569G · DestroyedNTSB LAX95FA068Accident · 2 fatalField investigationFinal reportGrumman AA-5A · San Luis Obispo, CAthe pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…Dec 31, 1994 · N26443 · DestroyedNTSB CHI95LA064Accident · Minor injuriesLimited investigationFinal reportNorth American F-51D · Round Lake, ILfuel starvation resulting from exhaustion of the fuel supply in the left tank. A factor related to the accident was insufficient altitude to switch fuel tanks and effect an engine restart.Dec 29, 1994 · N51TK · Substantial damageNTSB SEA95LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Murphy, IDThe pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.Dec 28, 1994 · N9107X · DestroyedNTSB MIA95FA042Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Plant City, FLThe opening of the engine cowling latch in cruise flight for undetermined reasons. This resulted in the puncture of the engine oil cooler, total exhaustion of the engine oil, failure of the No. 6 connecting rod, rod bolts, forced landing while on final…Dec 28, 1994 · N33456 · DestroyedNTSB LAX95LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · North Las Vegas, NVthe pilot's improper in-flight planning and decisions, and his failure to initiate remedial actions in a timely fashion.Dec 27, 1994 · N7446G · Substantial damageNTSB FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.Dec 27, 1994 · N8112P · DestroyedNTSB MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.Dec 24, 1994 · N2829P · Substantial damageNTSB LAX95LA060Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Searchlight, NVthe pilot's intentional continued flight into instrument meteorological conditions in mountainous terrain.Dec 24, 1994 · N3836T · DestroyedNTSB FTW95LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · La Porte, TXLoss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.Dec 24, 1994 · N2820M · Substantial damageNTSB MIA95LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · La Belle, FLPartial loss of engine power due to total failure of the no. 3 cylinder exhaust valve for undetermined reasons. Also, unsuitable terrain encountered during the forced landing.Dec 23, 1994 · N41774 · Substantial damageNTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.Dec 23, 1994 · N3221J · Substantial damageNTSB CHI95FA061Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Rochester, MNFailure of the pilot to maintain control of the airplane, while climbing in instrument meteorological conditions (IMC) after takeoff. Factors related to the accident were: fog, low ceiling, the pilot's lack of recent instrument experience, and the excessive…Dec 22, 1994 · N133MA · DestroyedNTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.Dec 22, 1994 · N1620Y · DestroyedNTSB SEA95LA034Accident · No injuriesLimited investigationFinal reportCessna T210 · Kellogg, IDThe pilot's improper positioning of the fuel selector valve, his inadequate remedial action, and starvation of fuel to the engine. Factors include a sign post alongside the road on which the forced landing took place.Dec 21, 1994 · N4607Q · Substantial damageNTSB LAX95LA058Accident · Minor injuriesLimited investigationFinal reportRender LONG-EZ · Kailua-Kona, HIa delamination of the wooden propeller.Dec 21, 1994 · N3250K · DestroyedNTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.Dec 19, 1994 · N175MC · DestroyedNTSB FTW95LA068Accident · No injuriesLimited investigationFinal reportCessna A150L · Newark, TXThe loss of engine power due to undetermined reasons. Factors were the dark night and lack of suitable terrain to execute a forced landing.Dec 18, 1994 · N6030J · Substantial damageNTSB FTW95FA069Accident · 1 fatalField investigationFinal reportPiper PA-32RT · San Antonio, TXThe loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.Dec 18, 1994 · N21590 · DestroyedNTSB FTW95LA067Accident · Serious injuriesLimited investigationFinal reportTimothy J Brown Pitts S2SE · Grand Prairie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 17, 1994 · N604SB · DestroyedNTSB DCA95MA007Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Fresno, CA1) Improperly installed electrical wiring for special mission operations that led to an in-flight fire that caused airplane systems and structural damage and subsequent airplane control difficulties; 2) improper maintenance and inspection procedures followed…Dec 14, 1994 · N521PA · DestroyedNTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…Dec 13, 1994 · N33049 · Destroyed