OpenAirDocs.org

NTSB investigations

35,883 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 WPR23LA283Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C35 · Rock Springs, WYMaintenance personnel’s failure to properly secure the propeller pitch control rod castellated nut hardware, which resulted in an in-flight failure of the pitch control bearing and subsequent loss of engine RPM and thrust.Jul 20, 2023 · N620D · Substantial damageNTSB ENG23LA034Incident · No injuriesClass 3 · LimitedFinal reportHall Lester R Legacy · Rochester, MNMechanically distressed reduction gears causing an engine overspeed and turbine blade tensile overload and subsequent uncontainment. Contributing to the uncontainment was the operator’s use of the engine after knowingly purchasing the engine in an…Jul 20, 2023 · N707MM · Minor damageNTSB CEN23LA344Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Oberlin, KSThe blockage of the left fuel tank vent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident of the pilot’s failure to use his checklist to address the loss of engine power.Jul 20, 2023 · N36900 · Substantial damageNTSB ANC23FA056Accident · 4 fatalClass 3 · FieldFinal reportBell 206-L4 · Wainwright, AKThe pilot's decision to fly at a low altitude over a large body of water toward featureless terrain, which resulted in a loss of visual clues and controlled flight into terrain.Jul 20, 2023 · N311MH · DestroyedNTSB GAA23WA211Accident · 6 fatalClass 5 · ForeignCessna 210 · San Luis Gaceno, ColombiaJul 19, 2023 · HK5138G · Substantial damageNTSB CEN23LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Gardner, KSA loss of engine power due to lead fouling of a spark plug.Jul 19, 2023 · N34KP · Substantial damageNTSB GAA23WA213Accident · 1 fatalClass 5 · ForeignCessna FR182 · Ferrara di Monte Baldo, ItalyJul 16, 2023 · D-EEMN · Substantial damageNTSB GAA23WA218Accident · Minor injuriesClass 4 · ForeignCessna 152 · União da Vitória, BrazilJul 14, 2023 · PR-CDI · Substantial damageNTSB GAA23WA277Accident · Serious injuriesClass 5 · ForeignCessna 172 · Novosibirsk,, RussiaJul 13, 2023 · RA-2018G · Substantial damageNTSB DCA23WA386IncidentClass 5 · ForeignBoeing 737 · Antalya, JordanJul 13, 2023 · JY-SOA · No damageNTSB ANC23LA053Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Ninilchik, AKA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft.Jul 13, 2023 · N83391 · Substantial damageNTSB ANC23LA051Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Ninilchik, AKA partial loss of engine power due to failure of the No. 1 cylinder intake valve head.Jul 13, 2023 · N97719 · Substantial damageNTSB DCA23LA378Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-214 · Inverness, FLAn inadvertent encounter with convectively induced turbulence during descent.Jul 12, 2023 · N249NV · No damageNTSB CEN23LA297Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Boelus, NELoss of engine power for reasons that could not be determined.Jul 12, 2023 · N151SR · Substantial damageNTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.Jul 11, 2023 · N271MG · Substantial damageNTSB DCA23WA472Incident · No injuriesClass 5 · ForeignAirbus A330 · overflying English Channel, United KingdomJul 11, 2023 · HB-JHL · No damageNTSB WPR23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · La Mesa, CAA total loss of engine power for undetermined reasons.Jul 9, 2023 · N1839R · Substantial damageNTSB WPR23LA263Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Marble Falls, TXA total loss of engine power due to fuel contamination from an unknown source.Jul 9, 2023 · N163RK · Substantial damageNTSB ERA23LA293Accident · Minor injuriesClass 3 · LimitedFinal reportHughes 369D · Waldorf, MDFatigue failure of the overrunning clutch outer race and a subsequent inflight loss of power due to abnormal bending loads as a result of improper reassembly of the clutch subassembly following maintenance and the presence of microcracks on the clutch’s outer…Jul 9, 2023 · N5027P · Substantial damageNTSB WPR23LA267Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Coquille Bay, ORThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with terrain.Jul 8, 2023 · N9507D · Substantial damageNTSB CEN23LA281Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Jeffersonville, INThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Jul 6, 2023 · N988CT · Substantial damageNTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.Jul 6, 2023 · N100PB · DestroyedNTSB GAA23WA210Incident · No injuriesClass 5 · ForeignCessna 206 · Esrum Sø, DenmarkJul 4, 2023 · LN-TEP · Minor damageNTSB ERA23LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman American Avn. AA5A · Redstone Arsenal, ALThe separation of the clamp assembly securing the throttle control cable outer housing, which resulted in the pilot’s inability to control the throttle.Jul 4, 2023 · N26387 · Substantial damageNTSB GAA23WA205Accident · 3 fatalClass 5 · ForeignPiper PA28R · GUaratuba, BrazilJul 3, 2023 · PT-JZC · Substantial damageNTSB WPR23LA249Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Meeks Bay, CAA loss of engine power for reasons that could not be determined based on the available information.Jul 1, 2023 · N4586R · Substantial damageNTSB CEN23LA273Accident · No injuriesClass 3 · LimitedFinal reportBerkut 540 · Cedar Rapids, IAA partial loss of engine power during the test flight due to multiple ignition system anomalies.Jul 1, 2023 · N567JS · Substantial damageNTSB GAA23WA190Accident · No injuriesClass 5 · ForeignCessna 150 · Gualeguay, Entre Rios, ArgentinaJun 28, 2023 · LV-JQA · Substantial damageNTSB DCA23WA350OccurrenceClass 5 · ForeignBoeing 777 · ChinaJun 28, 2023 · G-YMML · No damageNTSB GAA23WA274Accident · 1 fatalClass 5 · ForeignDB 6R · Ombersley Court, Worcestershire, United KingdomJun 25, 2023 · G-CMFS · Substantial damageNTSB CEN23LA267Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Rockport, TXThe failure of the left engine starter adapter gear, which resulted in catastrophic damage to other engine components, and the subsequent loss of engine power.Jun 24, 2023 · N123SM · Substantial damageNTSB WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.Jun 23, 2023 · N84385 · Substantial damageNTSB GAA23WA191Accident · Serious injuriesClass 5 · ForeignIcon A5 · Donam Port, North KoreaJun 23, 2023 · N764BA · DestroyedNTSB GAA23WA177Accident · 2 fatalClass 5 · ForeignSocata Rallye 180 · Arkösund, Norrköping, SwedenJun 18, 2023 · HA-BNSNTSB DCA23WA329IncidentClass 5 · ForeignBoeing 717 · Brisbane, AustraliaJun 18, 2023 · VH-NXN · No damageNTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.Jun 18, 2023 · N463HP · Substantial damageNTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.Jun 17, 2023 · N3508K · Substantial damageNTSB GAA23WA249AccidentClass 5 · ForeignKitfox Mk IV · Drimmelen, NetherlandsJun 17, 2023 · PH-DJM · Substantial damageNTSB ENG23LA030Incident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Sioux City, IAA No. 2 (right) engine failure due to a spinner fairing separation and subsequent impact with the fan blades that resulted in a midspan fracture of one fan blade. The spinner fairing separated as a result of a fatigue crack that originated from the heat…Jun 17, 2023 · N926TT · Minor damageNTSB DCA23WA328Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Singapore, SingaporeJun 15, 2023 · G-STBL · No damageNTSB DCA23WA333IncidentClass 5 · ForeignBoeing 737 · Heraklion, GreeceJun 14, 2023 · OK-TSO · No damageNTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.Jun 14, 2023 · N1025C · DestroyedNTSB ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.Jun 10, 2023 · N8725A · DestroyedNTSB GAA23WA165Accident · 1 fatalClass 4 · ForeignPiper PA-32R-301 · Stella Maris, BahamasJun 9, 2023 · N9253M · DestroyedNTSB WPR23LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Wishram, WAThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.Jun 7, 2023 · N7155F · Substantial damageNTSB GAA23WA164AccidentClass 5 · ForeignPiper PA-24-250 · Guadalajara, MexicoJun 6, 2023 · XB-GOONTSB ENG23WA029Incident · No injuriesClass 5 · ForeignSikorsky S92 · Sola, NorwayJun 5, 2023 · LN-OMI · No damageNTSB WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.Jun 4, 2023 · N77583 · Substantial damageNTSB ERA23FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna 560 · Montebello, VAPilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.Jun 4, 2023 · N611VG · DestroyedNTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.Jun 2, 2023 · N977RV · Destroyed