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 GAA23WA116Accident · No injuriesClass 5 · ForeignCirrus SR-22 · Massaranduba, BrazilMar 29, 2023 · PR-JJC · Substantial damageNTSB GAA23WA109Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Bournemouth, United KingdomMar 28, 2023 · G-FCSL · Substantial damageNTSB DCA23WA263IncidentClass 5 · ForeignBoeing 777 · Pacific Ocean, JapanMar 28, 2023 · 9V-SWQNTSB GAA23WA113Accident · No injuriesClass 5 · ForeignPiper PA34 · Boa Vista, BrazilMar 25, 2023 · PR-FDL · Substantial damageNTSB ERA23FA164Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Johns Island, SCThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s degraded judgement and…Mar 25, 2023 · N21480 · Substantial damageNTSB WPR23LA236Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Springfield, KYThe pilot’s failure to activate the pitot heat in a timely manner during flight into icing conditions, which resulted in a temporary failure of the flight instruments and a subsequent loss of control.Mar 24, 2023 · N146MS · Substantial damageNTSB ERA23LA162Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Travelers Rest, SCMaintenance personnel’s improper servicing of the magneto, which resulted in its accelerated wear, failure, and the total loss of engine power.Mar 23, 2023 · N13612 · Substantial damageNTSB GAA23WA106Incident · No injuriesClass 5 · ForeignCessna 172 · Madrid, SpainMar 22, 2023 · EC-GVD · Minor damageNTSB ENG23WA024Incident · No injuriesClass 5 · ForeignAirbus A320 · Kota Kinabalu, MalaysiaMar 22, 2023 · RP-C4106 · No damageNTSB DCA23WA236Accident · Serious injuriesClass 5 · ForeignBoeing 777 · Incheon, South KoreaMar 22, 2023 · HL8254 · No damageNTSB WPR23FA137Accident · 1 fatalClass 3 · FieldFinal reportCessna 182S · Alcova, WYThe airplane’s encounter with low level wind shear associated with moderate turbulence, which resulted in a loss of airplane control.Mar 21, 2023 · N314FR · Substantial damageNTSB DCA23LA213Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 777-224 · Sacramento, CAAn encounter with forecast convective turbulence during climb.Mar 21, 2023 · N79011 · No damageNTSB GAA23WA100Accident · 2 fatalClass 5 · ForeignDiamond DA40 · Gondia, IndiaMar 18, 2023 · VT-FGL · DestroyedNTSB WPR23LA129Accident · Serious injuriesClass 4 · LimitedFinal reportNavion Navion A · Mesa, AZThe pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision.Mar 17, 2023 · N610 · 2 aircraft · Substantial damageNTSB ERA23LA156Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Shoreham, NYA total loss of engine power for unknown reasons.Mar 17, 2023 · N5616S · Substantial damageNTSB ERA23LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 35-B33 · Scottsmoor, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion.Mar 14, 2023 · N5714K · Substantial damageNTSB GAA23WA098Incident · No injuriesClass 4 · ForeignCirrus SR22 · Sabara, BrazilMar 11, 2023 · PS-VAC · Minor damageNTSB ERA23LA148Accident · Serious injuriesClass 3 · LimitedFinal reportVelocity Velocity SE · Bahia Key, FLA total loss of engine power for undetermined reasons.Mar 11, 2023 · N343BD · Substantial damageNTSB ERA23LA147Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Franklin, NCThe pilot’s improper decision to review an aircraft logbook while enroute, which resulted in controlled flight into terrain.Mar 9, 2023 · N558MT · Substantial damageNTSB WPR23LA125Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International AC 690A · Bullhead City, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain.Mar 7, 2023 · N4PZ · Substantial damageNTSB WPR23FA143Accident · 1 fatalClass 3 · FieldFinal reportCessna T182T · Queets, WAThe pilot’s failure to maintain clearance from terrain for undetermined reasons.Mar 7, 2023 · N24289 · DestroyedNTSB ERA23LA173Accident · No injuriesClass 3 · LimitedFinal reportBeech P35 · Perry, FLMaintenance personnel’s incorrect torquing of the oil filter adapter jam nut, resulting in the failure of the adapter threads, a complete loss of oil, and subsequent total loss of engine power.Mar 5, 2023 · N9777Y · Substantial damageNTSB WPR23LA117Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Lampasas, TXImproper case hardening of the crankshaft timing gear, which resulted in the fatigue failure of the gear and a total loss of engine power.Mar 4, 2023 · N6532M · Substantial damageNTSB GAA23WA115Occurrence · No injuriesClass 5 · ForeignCirrus SR22 · Salto, UruguayMar 4, 2023 · LV-GZQ · No damageNTSB GAA23WA092Accident · Minor injuriesClass 5 · ForeignCessna 172 · Loreto, PeruMar 3, 2023 · OB-1100 · Substantial damageNTSB GAA23WA090Accident · 2 fatalClass 5 · ForeignAir Tractor AT402 · Fazenda Juína, Juína - MT, BrazilMar 3, 2023 · PS-JCB · Substantial damageNTSB ERA23LA135Accident · 1 fatalClass 2 · LimitedFinal reportBombardier BD-100-1A10 · Windsor Locks, CTThe flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…Mar 3, 2023 · N300ER · Minor damageNTSB ERA23LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Slaughters, KYMaintenance personnel’s failure to secure the fuel strainer bowl with safety wire, which resulted in the fuel strainer bowl leaking and starving the engine of fuel. Also causal was the obstruction of two fuel injector nozzles.Mar 2, 2023 · N9420N · Substantial damageNTSB GAA23WA087Accident · 2 fatalClass 5 · ForeignCessna 208 · Nakina, CanadaFeb 28, 2023 · C-GMVB · DestroyedNTSB ERA23FA131Accident · 1 fatalClass 3 · FieldFinal reportCessna 150G · Hillsville, VAThe pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into terrain.Feb 27, 2023 · N2991J · Substantial damageNTSB DCA23WA189OccurrenceClass 5 · ForeignBoeing 737 · Budapest, HungaryFeb 27, 2023 · OE-IWD · No damageNTSB GAA23WA102Accident · Serious injuriesClass 5 · ForeignQuicksilver GT500 · Flaminio Suárez, ColombiaFeb 26, 2023 · HJ-320 · Substantial damageNTSB WPR23MA113Accident · 5 fatalClass 2 · MajorFinal reportPilatus PC-12/45 · Stagecoach, NVThe pilot’s loss of control due to spatial disorientation while operating in night instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the disengagement of the autopilot for undetermined reasons, as…Feb 25, 2023 · N273SM · Substantial damageNTSB WPR23LA115Accident · No injuriesClass 4 · LimitedFinal reportAircraft Mfg & Development CH 2000 · Mulino, ORThe pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.Feb 25, 2023 · N8500Z · Substantial damageNTSB GAA23WA119Accident · 2 fatalClass 5 · ForeignRobinson R44 · Checkhov, RussiaFeb 17, 2023 · RA-04340 · DestroyedNTSB DCA23LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319-132 · New Orleans, LAThe flight’s encounter with convective turbulence.Feb 16, 2023 · N505NK · No damageNTSB GAA23WA124Incident · No injuriesClass 5 · ForeignPiper PA28 · Malacca City, MalaysiaFeb 14, 2023 · 9M-SKJ · No damageNTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.Feb 11, 2023 · N944AN · No damageNTSB CEN23LA106Accident · No injuriesClass 3 · LimitedFinal reportJabiru USA Sport J250-SP · Cortland, ILA total loss of engine power for reasons that could not be determined.Feb 11, 2023 · N592J · Substantial damageNTSB GAA23WA099Accident · No injuriesClass 5 · ForeignCessna 208B · Puente de Ixtla, MexicoFeb 10, 2023 · N9634B · Substantial damageNTSB DCA23WA178IncidentClass 5 · ForeignBoeing 737 · Paris, FranceFeb 10, 2023 · TF-BBL · No damageNTSB DCA23WA166OccurrenceClass 5 · ForeignBoeing 767-332 · Prestwick, United KingdomFeb 10, 2023 · N197DNNTSB DCA23LA477Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Lake Butler, FLAn inadvertent encounter with convectively induced turbulence.Feb 10, 2023 · N13138 · No damageNTSB DCA23WA165OccurrenceClass 5 · ForeignBoeing 777 · Mediterranean Sea, NetherlandsFeb 9, 2023 · PH-BQO · No damageNTSB GAA23WA069Incident · No injuriesClass 5 · ForeignPiper PA-23-250 · Nassau, BahamasFeb 8, 2023 · N5982Y · Minor damageNTSB ENG23WA021Incident · No injuriesClass 4 · ForeignSikorsky S-92 · Derry, United KingdomFeb 5, 2023 · EI-ICU · Substantial damageNTSB CEN23LA101Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7ACA · Bayport, MNThe pilot’s poor inflight fuel monitoring that resulted in a total loss of engine power due to fuel starvation.Feb 4, 2023 · N9111L · Substantial damageNTSB GAA23WA066Incident · No injuriesClass 5 · ForeignCessna 206 · Stann Creek, BelizeFeb 3, 2023 · V3-HESNTSB DCA23WA313Incident · Serious injuriesClass 5 · ForeignAirbus A330 · Grand Anse Village, SeychellesFeb 3, 2023 · D-ANRANTSB DCA23WA141IncidentClass 5 · ForeignAirbus A321 · Doha, QatarJan 29, 2023 · A6-AEF · Minor damage