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 MIA93LA006Accident · 1 fatalLimited investigationFinal reportHarkness, Richard W. Adventure · New Smyrna Bch, FLThe failure of the pilot in command to maintain airspeed above stall speed following engine failure resulting in the aircraft stalling and descending uncontrolled to the ground. Contributing to the accident was the pilot in command's improper leaning of the…Oct 13, 1992 · N87RH · DestroyedNTSB CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.Oct 13, 1992 · N69223 · Substantial damageNTSB ANC93FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Talkeetna, AKThe pilot's continued visual flight into instrument meteorological conditions at night which resulted in a loss of airplane control, spatial disorientation, and an inflight breakup. Factors which contributed to the accident were: the adverse weather and the…Oct 12, 1992 · N16275 · DestroyedNTSB NYC93FA013Accident · 1 fatalField investigationFinal reportCessna 195 · Shenandoah, PAA loss of control due to pilot incapacitation.Oct 10, 1992 · N4308V · DestroyedNTSB ATL93LA007Accident · 1 fatalLimited investigationFinal reportBensen B-8M · Holly Ridge, NCThe pilot's failure to operate the flight controls properly.Oct 10, 1992 · N3777R · Substantial damageNTSB NYC93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Pulaski, VAThe improper decision by the non-instrument-rated pilot to continue VFR flight into known instrument meteorological conditions resulting in spatial disorientation and loss of control of the airplane. Factors which contributed to the accident were the actions…Oct 9, 1992 · N31953 · DestroyedNTSB LAX93LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Quartzsite, AZEngine failure for an undetermined reason. Contributing to this accident was the rough/uneven terrain.Oct 9, 1992 · N150G · Substantial damageNTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.Oct 8, 1992 · N8EN · 2 aircraft · Substantial damageNTSB FTW93FA008Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Chatham, LAThe inadvertent stall and spin. Factors were the power loss due to fuel starvation, the dark night, and his failure to use the boost pump for engine restart.Oct 8, 1992 · N153Q · Substantial damageNTSB ATL93LA010Accident · No injuriesLimited investigationFinal reportCessna 172P · Buford, GAFuel exhaustion due to the pilot's inadequate inflight planning.Oct 8, 1992 · N62527 · Substantial damageNTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.Oct 7, 1992 · N37SC · Substantial damageNTSB ANC93LA006Accident · No injuriesLimited investigationFinal reportCessna 150F · Denali, AKThe inadequate preflight planning and preparation by the student pilot, the student pilot's continued flight into known adverse weather and the pilot's failure to maintain directional control on the roadway landing. Factors relating to the accident were: the…Oct 7, 1992 · N8048F · Substantial damageNTSB MIA93LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Port St. Lucie, FLTotal loss of engine power due to fuel exhaustion caused by poor preflight planning preparation by the pilot in command.Oct 6, 1992 · N17803 · Substantial damageNTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).Oct 5, 1992 · N99256 · Substantial damageNTSB NYC93LA006Accident · Minor injuriesLimited investigationFinal reportSmitrovich SE-5A Replica · Harwinton, CTA forced landing in unsuitable terrain, following a power loss due to fuel exhaution. Factors related to the accident were the failure of the pilot to refuel the airplane prior to departure and his improper fuel consumption calculations which led to fuel…Oct 4, 1992 · N1869S · Substantial damageNTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.Oct 4, 1992 · N8773T · Substantial damageNTSB CHI93DCD01Accident · Serious injuriesFinal reportRichard O. Middlen Glasair III SH-3R · Larchwood, IAThe pilot-in-command's intentional low pass and his inadequate visual lookout.Oct 4, 1992 · N330RM · Substantial damageNTSB LAX93FA004Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Elko, NVThe failure of the pilot to obtain an adequate preflight weather brieifing and the pilot's decision to continue flight into forecast adverse weather conditions. Contributing to the accident was the prevailing icing, clouds, and rain weather conditions.Oct 3, 1992 · N33317 · DestroyedNTSB CHI93LA004Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mountain, WIThe pilot's failure to refuel the airplane.Oct 3, 1992 · N560C · Substantial damageNTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.Oct 2, 1992 · N8119F · Substantial damageNTSB FTW93FA002Accident · 1 fatalField investigationFinal reportClatanoff Rotorway Exec · Wimberley, TXThe delamination of the skin on a main rotor blade.Oct 2, 1992 · N41KC · DestroyedNTSB ATL93LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Aliceville, ALMaintenance personnel's failure to properly secure the fuel line from the fuel pump to the fuel injector during the engine installation, which resulted in a complete engine failure.Oct 2, 1992 · N8548P · Substantial damageNTSB LAX92FA410Accident · 2 fatalField investigationFinal reportRobinson R22-B · Martinez, CAAn undetermined divergence of the main rotor from its normal plane of rotation which resulted in rotor contact to the fuselage and passenger.Sep 30, 1992 · N8069X · DestroyedNTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.Sep 29, 1992 · N8274C · Substantial damageNTSB ATL92LA186Accident · No injuriesLimited investigationFinal reportCessna 150M · Nashville, TNThe student pilot's inadequate inflight planning, which resulted in fuel exhaustion. A factor was his geographical disorientation.Sep 29, 1992 · N7764U · Substantial damageNTSB SEA92LA216Accident · No injuriesLimited investigationFinal reportCessna 182L · Vancouver, WAThe partial loss of engine power from failure of the no 5 piston, and the soft terrain at the forced ldg site, resulting in collapse of the nose landing gear.Sep 26, 1992 · N42324 · Substantial damageNTSB LAX92LA403Accident · No injuriesLimited investigationFinal reportGolightly, Robert B. RV4 · Rialto, CAFuel starvation due to the pilot's improper management of the fuel system, and his failure to perform the emergency procedure of repositioning the fuel selector to a tank containing fuel.Sep 26, 1992 · N321RG · Substantial damageNTSB BFO92FA144Accident · 2 fatalField investigationFinal reportHughes 269C · East Bernstadt, KYInadequate maintenance inspection involving failure to detect wear of the clutch spring assembly, resulting in the uncoupling of engine power to the main transmission.Sep 25, 1992 · N9609F · DestroyedNTSB SEA92LA214Accident · No injuriesLimited investigationFinal reportCessna 320B · Lowell, IDRam induction air starvation of both engines and inability of the pilot in command to clear trees during the forced landing. Factors contributing to the accident were low ceilings and trees.Sep 24, 1992 · N9811L · DestroyedNTSB LAX92IA397Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 10-10 · San Francisco, CAA fractured compressor assembly.Sep 23, 1992 · N1845U · Minor damageNTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…Sep 23, 1992 · N43313 · DestroyedNTSB MIA92LA190Accident · Minor injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe pilot-in-command's failure to conduct a preflight inspection of the fuel tanks prior to takeoff.Sep 22, 1992 · N121PL · DestroyedNTSB FTW92DPG16Accident · No injuriesFinal reportGulfstream G-164B · Holly Grove, ARLoss of engine power undetermined. Factor was unsuitable terrain.Sep 22, 1992 · N8075K · Substantial damageNTSB FTW92LA230Accident · No injuriesLimited investigationFinal reportCessna 172P · Fulshear, TXThe pilot's failure to attain the proper point of touchdown. Factors were the popped circuit breaker, the inoperative alternator, and the darkness of the night.Sep 21, 1992 · N97489 · Substantial damageNTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.Sep 21, 1992 · N90BF · DestroyedNTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…Sep 21, 1992 · N99693 · DestroyedNTSB LAX92LA395Accident · Minor injuriesLimited investigationFinal reportAbrams/Nuding Quickie Q2 · Minden, NVFuel starvation for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.Sep 20, 1992 · N4AN · DestroyedNTSB SEA92LA210Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Arlington, WYThe pilot in command's failure to touch down at the proper landing point on the road. A factor contributing to the accident was high density altitude.Sep 18, 1992 · N9662S · DestroyedNTSB LAX92LA393Accident · 1 fatalLimited investigationFinal reportSparks-Schreder HP-140V · Avenal, CAThe loss of pitch and yaw control due to the separation of the ruddervator control cable from its clevis fork due to improper installation.Sep 18, 1992 · N704B · DestroyedNTSB FTW92LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Victoria, TXBlocked engine assembly breather tube and the pilot's continued operation with known maintenance discrepancies. Factors were oil on windsheild and reduced visibility due to oil on the windscreen..Sep 18, 1992 · N46084 · Substantial damageNTSB DEN92FA093Accident · 1 fatalField investigationFinal reportCessna 172M · Evanston, WYLoss of control for undetermined reasons.Sep 18, 1992 · N9632H · DestroyedNTSB CHI92DCA05Accident · Serious injuriesFinal reportRettberg Rans S-7 · Charleston, MOThe pilot-in-command's poor weather evaluation which resulted in a takeoff into adverse weather conditions and a loss of airplane control.Sep 18, 1992 · N199KR · Substantial damageNTSB ANC92LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKFuel system contamination by water and poor preflight inspection and preparation by the pilot in command. The lack of suitable terrain for an emergency float plane landing was a factor in this accident.Sep 18, 1992 · N226T · Substantial damageNTSB MIA92LA184Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Poplarville, MSA reported loss of engine power for undetermined reasons resulting in a forced landing and in flight collision with trees.Sep 17, 1992 · N8190K · Substantial damageNTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.Sep 17, 1992 · N39652 · DestroyedNTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.Sep 17, 1992 · N30076 · DestroyedNTSB BFO92LA142Accident · No injuriesLimited investigationFinal reportCessna 172N · Havre De Grace, MDThe pilot's improper use of carburetor heat control resulting in a total loss of engine power. Factors contributing to the accident include the existence of weather conditions conducive to carburetor icing and the rough terrain on which the aircraft was…Sep 17, 1992 · N7396E · Substantial damageNTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.Sep 16, 1992 · N1083X · DestroyedNTSB LAX92FA388Accident · 7 fatalField investigationFinal reportAerospatiale AS-350B · Hana, HIThe pilot inadequately evaluating the enroute weather conditions, and the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see and avoid the mountainous…Sep 16, 1992 · N350SM · DestroyedNTSB FTW92LA226Accident · No injuriesLimited investigationFinal reportBell 47-J2A · Booneville, ARThe pilot's failure to maintain adequate rotor RPM during autorotative landing. Factors were fuel exhaustion, the pilot's improper fuel consumption calculations, and the pilot not refueling the helicopter.Sep 16, 1992 · N291FW · Substantial damage