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 ATL92LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Jasper, TNThe fractured valve which resulted in a total loss of engine power, while flying over terrain that was not suitable for a forced landing. A factor was the densely wooded, mountainous terrain.Sep 15, 1992 · N8005C · Substantial damageNTSB LAX92LA385Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ojai, CAThe pilot's failure to maintain adequate main rotor RPM to cushion the landing. Contributing to the accident was the loss of engine power for undetermined reasons and the existing high density altitude.Sep 14, 1992 · N4079S · Substantial damageNTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.Sep 13, 1992 · N7057Y · Substantial damageNTSB LAX92LA384Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 Beta · Colfax, CAThe pilot poor in-flight decision to fly at a low altitude and his inadequate visual look-out. The cable (static wire) contributed to this accident.Sep 13, 1992 · N649MB · Substantial damageNTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.Sep 13, 1992 · N738KX · Substantial damageNTSB LAX92LA383Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe pilot/passenger's failure to maintain adequate rotor RPM and the pilot-in-command's inadequate supervision of the flight.Sep 12, 1992 · N58164 · Substantial damageNTSB LAX92LA382Accident · No injuriesLimited investigationFinal reportCessna 172N · Fillmore, CAThe first pilot's poor inflight decision to fly into a box canyon. Contributing to this accident was the box canyon and the downdraft.Sep 12, 1992 · N2212W · Substantial damageNTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.Sep 12, 1992 · N5361K · Substantial damageNTSB DCA92MA049Accident · 6 fatalClass 1 · MajorFinal reportMitsubishi MU-2B-60 · Greenwood, INThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the pilots of the MU-2 and the PA-32 from recognizing a collision hazard and taking actions to avoid the midair collision.…Sep 11, 1992 · N74FB · 2 aircraft · DestroyedNTSB CHI92LA273Accident · Minor injuriesLimited investigationFinal reportAlon 415-A2 · Sabetha, KSThe pilot's failure to use carburetor heat.Sep 11, 1992 · N6555Q · Substantial damageNTSB BFO92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Brandenburg, KYThe pilot's in-flight planning/decision which resulted in fuel exhaustion.Sep 11, 1992 · N83628 · Substantial damageNTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.Sep 11, 1992 · N6105G · Substantial damageNTSB BFO92FA135Accident · 2 fatalField investigationFinal reportBeech G35 · Hillsville, VALoss of engine power for an undetermined reason and failure of the pilot to maintain airspeed, which resulted in a stall/spin.Sep 11, 1992 · N4526D · DestroyedNTSB ANC92LA167Accident · No injuriesLimited investigationFinal reportCessna 150 · Bethel, AKThe carburetor icing conditions and the delay by the pilot in command/cfi in using carburetor heat.Sep 10, 1992 · N7763F · Substantial damageNTSB SEA92LA202Accident · Serious injuriesLimited investigationFinal reportQuicksilver MXL II · Cave Junction, ORThe pilot's poor visual lookout. Factors include a static wire in the area of flight.Sep 9, 1992 · UNREG · Substantial damageNTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Sep 9, 1992 · N24600 · Substantial damageNTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, self-induced pressure…Sep 9, 1992 · N5533N · DestroyedNTSB ANC92FA159Accident · Serious injuriesField investigationFinal reportHughes 369D · Nunavaugaluk Lk, AKThe separation of the tail rotor abrasion strip and the subsequent total loss of the tail rotor. Factors contributing to the accident were: insufficient manufacturer's maintenance design changes, inadequate aircraft equipment design by the manufacturer and…Sep 9, 1992 · N8697F · Substantial damageNTSB LAX92LA377Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, CAThe unknown pilots improper use of the throttles which resulted in the overboosting of the engine. Contributing to the accident was the maintenance personnel improper maintenance in adjusting the turbocharger wastegate and the oil leaking from the engine…Sep 8, 1992 · N20926 · DestroyedNTSB MIA92LA176Accident · No injuriesLimited investigationFinal reportCessna 172I · Navarre, FLFailure of the pilot-in-command to maintain directional control after touchdown during the forced landing following partial loss of engine power during cruise flight. Contributing to the accident was the divertion of attention of the pilot in command to the…Sep 7, 1992 · N35302 · Substantial damageNTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.Sep 7, 1992 · N400RD · Substantial damageNTSB FTW92FA223Accident · 1 fatalField investigationFinal reportPiper PA-30 · Broussard, LAPilot's decision to fly into known adverse weather and the resultant in flight break up of the airplane.Sep 6, 1992 · N7065Y · DestroyedNTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.Sep 5, 1992 · N32677 · Substantial damageNTSB CHI92LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Moran, MIThe pilot-in-command's improper selection of fuel tank resulting in fuel starvation. A factor was the pilot-in-command's encounter with unsuitable terrain.Sep 5, 1992 · N5572J · Substantial damageNTSB CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.Sep 5, 1992 · N2935W · Substantial damageNTSB ANC92LA157Accident · No injuriesLimited investigationFinal reportSikorsky S-58G · Port Alsworth, AKInflight engine compartment fire and post landing fire of undetermined origin.Sep 5, 1992 · N822G · DestroyedNTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the light conditions at dusk (or darkness), and the pilot's lack…Sep 4, 1992 · N3847S · DestroyedNTSB SEA92LA194Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · The Dalles, ORA misjudged approach. Factors to the accident were: inaccurate fuel consumption calculations and fuel exhaustion.Sep 2, 1992 · N1005B · Substantial damageNTSB ANC92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Fort Yukon, AKFatigue failure of an engine cylinder precipitated by the pilot-in-command intentionally exceeding the engine performance ratings in order to sustain flight in the grossly overweight condition. A factor contributing to the accident was the high grass. A…Sep 2, 1992 · N8070Z · Substantial damageNTSB ATL92LA170Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisburg, NCThe passenger's inadvertent interference with the flight controls.Sep 1, 1992 · N7317D · Substantial damageNTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.Aug 31, 1992 · N245AE · No damageNTSB MIA92LA169Accident · No injuriesLimited investigationFinal reportCessna 425 · Greenwood, MSFailure of the pilot-in-command to maintain his descent rate resulting in an undershoot. Contributing to the accident was the chip detector failure due to improper quality control by the manufacturer.Aug 30, 1992 · N425TV · Substantial damageNTSB CHI92LA258Accident · Minor injuriesLimited investigationFinal reportChristen Industries S2B · Alton, ILThe pilot's failure to accomplish refueling.Aug 29, 1992 · N60468 · Substantial damageNTSB LAX92LA368Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe shutdown of the engine due to the failure of the muffler and the resulting heat induced shorting of the magneto ground wires, and the inadequate maintenance inspection of the muffler and the engine exhaust system.Aug 28, 1992 · N211AF · Substantial damageNTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.Aug 28, 1992 · N845AX · Minor damageNTSB SEA92LA191Accident · No injuriesLimited investigationFinal reportHelio H-391B · Edmonds, WAThe partial loss of engine power when an exhaust valve seized in the open position and the water where the pilot was forced to land, which resulted in an acft nose over on touchdown.Aug 26, 1992 · N4431U · DestroyedNTSB ANC92GA155Accident · No injuriesFinal reportBell 206B · Fairbanks, AKPoor maintenance and inspection procedures by the contract maintenance personnel, as well as improper maintenance and installation of the fuel line by the contract maintenance personnel. Factors relating to the accident were the turboshaft engine vibrations…Aug 25, 1992 · N83139 · Substantial damageNTSB LAX92LA361Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Morgan Hill, CAA loss of engine power due to carburetor ice and the failure of the pilot to use carburetor heat.Aug 23, 1992 · N707CW · Substantial damageNTSB LAX92LA360Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Big Bear, CAThe pilots decision to attempt crossing a ridge line at an altitude insufficient to allow for contingency actions in the event of an encounter with down drafts or turbulence. Factors in the accident were the high density altitude and the flight's encounter…Aug 23, 1992 · N20BN · DestroyedNTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1992 · N1672Y · Substantial damageNTSB ANC92LA142Accident · No injuriesLimited investigationFinal reportCessna 140 · Wasilla, AKThe partial loss of engine power due to the separation of the right hand exhaust stack. Contributing to the accident was the unsuitable terrain on which the forced landing was made.Aug 23, 1992 · N77073 · Substantial damageNTSB ANC92FA141Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKPilot in command's intentional flight into known adverse weather conditions. Factors relating to the accident were: the pilot's disregard for adverse weather advisory, weather conditions (clouds) and mountainous terrain.Aug 23, 1992 · N9829X · DestroyedNTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.Aug 22, 1992 · N3985W · Substantial damageNTSB ANC92LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Chicken, AKThe pilot's selection of unsuitable terrain. Contributing factors were the pilot inadvertently became lost/disoriented, her lack of total expereince, her lack of familiarity with the geographical area, the poor lighting condition (dusk), and the weather…Aug 22, 1992 · N60725 · Substantial damageNTSB NYC92LA179Accident · No injuriesLimited investigationFinal reportBenson-Callaway B-80 · Paducah, KYThe loss of engine power for undetermined reasons resulting in a forced landing on unsuitable terrain.Aug 19, 1992 · N852DC · Substantial damageNTSB NYC92LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Salem, CTThe pilot's inaccurate fuel calculations and his improper decision to takeoff with a known limited fuel supply resulting in fuel exhaustion and subsequent forced landing. Factors related to the accident were the pilot's lack of total flight experience and his…Aug 19, 1992 · N2519B · Substantial damageNTSB FTW92DPG15Accident · No injuriesFinal reportBell-Transworld 47G-2 · Birdeye, ARFuel contamination. A factor was the high density altitude.Aug 19, 1992 · N9238Z · Substantial damageNTSB ANC92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe loss of engine power due to fuel starvation associated with fuel contamination due to an inadequate aircraft preflight by the pilot. The unsuitable terrain encountered during the landing was a factor.Aug 19, 1992 · N7509K · Substantial damageNTSB NYC92LA166Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2-60 · Philadelphia, PAThe in-flight separation of a propeller blade as a result of fatigue cracking initiated from multiple sites located at corrosion pits in the balancing hole. Contributing factors in the accident were: the failure to detect the corrosion during the last…Aug 18, 1992 · N66LA · Substantial damageNTSB LAX92FA356Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Incline Village, NVWas the pilot's in flight loss of airplane control due to physical incapacitation.Aug 17, 1992 · N2406J · Destroyed