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 CEN24LA022Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Iola, KSThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Oct 22, 2023 · N5324F · Substantial damageNTSB ERA24LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Richmond, VAThe loss of engine power due to a restriction of fuel flow as a result of a fractured float bracket in the carburetor.Oct 21, 2023 · N7716G · Substantial damageNTSB DCA24WA013IncidentClass 5 · ForeignBoeing 737 · Stocksbridge, United KingdomOct 17, 2023 · G-TAWDNTSB CEN24LA017Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Mitchell, INThe inflight collision with a bird while in cruise flight.Oct 17, 2023 · N490AE · Substantial damageNTSB CEN24LA012Accident · No injuriesClass 3 · LimitedFinal reportTvap 4 · Franksville, WIThe improper installation of the supplemental ignition system, which resulted in a total loss of engine power.Oct 15, 2023 · N42VZ · Substantial damageNTSB CEN24LA011Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Red Oak, IAThe fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.Oct 15, 2023 · N6JA · Substantial damageNTSB ERA24LA006Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Jonesboro, GABoth pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.Oct 11, 2023 · N55162 · Substantial damageNTSB WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…Oct 10, 2023 · N75RT · Substantial damageNTSB GAA24WA010Accident · 2 fatalClass 4 · ForeignBell 206 · Bondeno, ItalyOct 10, 2023 · T7-HZM · DestroyedNTSB GAA24WA009Accident · 2 fatalClass 5 · ForeignDiamond DA20 · Almeria, SpainOct 10, 2023 · CO493 · Substantial damageNTSB GAA24WA018Accident · 3 fatalClass 5 · ForeignPiper PA 34 · Chilliwack BC, CanadaOct 6, 2023 · C-GTYH · DestroyedNTSB DCA24WA012Accident · No injuriesClass 5 · ForeignAirbus A321 · Essex, United KingdomOct 5, 2023 · G-OATW · Substantial damageNTSB ERA24LA023Accident · No injuriesClass 3 · LimitedFinal reportChampion 7FC · Hawkinsville, GAThe failure of the carburetor fuel line, which resulted in fuel starvation.Oct 3, 2023 · N4878E · Substantial damageNTSB GAA23WA273Accident · 1 fatalClass 5 · ForeignCessna 172 · Uk, GermanySep 30, 2023 · D-EDDHNTSB ERA23FA380Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Whitesville, KYThe flight instructor’s improper decision to continue flight into a known area of thunderstorms, which resulted in an in-flight breakup.Sep 28, 2023 · N3079M · DestroyedNTSB DCA23LA465Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-8 · Lake Erie Beach, NYMalfunctioning brakes on a service cart.Sep 28, 2023 · N804AN · No damageNTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.Sep 25, 2023 · N135WT · Substantial damageNTSB DCA23LA462Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Caribbean Sea (Atlantic Ocean)An inadvertent encounter with convectively induced turbulence during cruise that was not depicted by the airplane’s weather radar system.Sep 25, 2023 · N569JB · No damageNTSB DCA23WA463Incident · No injuriesClass 5 · ForeignBoeing 737 · Guayaquil, EcuadorSep 24, 2023 · HC-CUH · No damageNTSB CEN23LA419Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · El Dorado, ARA loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.Sep 23, 2023 · N67CD · Substantial damageNTSB GAA23WA278Accident · No injuriesClass 3 · ForeignDe Havilland DHC2 · Campbel River, CanadaSep 20, 2023 · C-GSBA · Substantial damageNTSB ENG23WA041IncidentClass 3 · ForeignAirbus A320 · Almaty, KazakhstanSep 17, 2023 · EI-KBK · Minor damageNTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.Sep 17, 2023 · N907W · Substantial damageNTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.Sep 16, 2023 · N46WR · Substantial damageNTSB ERA23LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Prospect, TNA loss of engine power due to the fatigue failure of the No. 6 cylinder exhaust valve rocker boss.Sep 14, 2023 · N8443M · Substantial damageNTSB ENG23WA042Incident · No injuriesClass 5 · ForeignAirbus A320 · Enroute Bogota - Barranquilla, ColombiaSep 13, 2023 · N740AV · No damageNTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaSep 10, 2023 · RA-05823 · Substantial damageNTSB ENG23WA037IncidentClass 5 · ForeignAirbus A321 · Changi, Singapore, SingaporeSep 10, 2023 · B305J · Minor damageNTSB CEN23FA410Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Dowagiac, MIThe total loss of engine power due to the failure of the ignition distributor rotor.Sep 10, 2023 · N569SX · Substantial damageNTSB DCA23LA445Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Hebron, KYAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Sep 7, 2023 · N37531 · No damageNTSB CEN23LA405Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Giddings, TXThe glider’s encounter with flutter during cruise flight that resulted in structural damage to the fuselage.Sep 7, 2023 · N321AD · Substantial damageNTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.Sep 6, 2023 · N81GX · Substantial damageNTSB DCA23WA455IncidentClass 5 · ForeignBoeing 737 · Ballina, AustraliaSep 6, 2023 · VH-YQR · No damageNTSB ANC23LA071Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · King Salmon, AKThe failure of both pilots to see and avoid while en route, which resulted in a midair collision.Sep 5, 2023 · N193AL · 2 aircraft · Substantial damageNTSB ERA23LA363Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Frankfort, KYA total loss of engine power for reasons that could not be determined.Sep 4, 2023 · N1WN · Substantial damageNTSB CEN23LA402Accident · No injuriesClass 3 · LimitedFinal reportVans RV14 · Orchard, TXThe failure of an alternator belt and the builder/previous owner’s incorrect electrical wiring of the airplane’s other alternator, which resulted in a total loss of electrical and engine power.Sep 4, 2023 · N14NP · Substantial damageNTSB CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Sep 3, 2023 · N1374F · Substantial damageNTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.Sep 2, 2023 · N6868D · Substantial damageNTSB ERA23LA361Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Rutledge, TNA total loss of engine power due to the fatigue failure of a retaining circlip in one of the No. 2 crankshaft cheek counterweights, which resulted in liberation of the counterweight.Sep 2, 2023 · N5431U · Substantial damageNTSB CEN23LA399Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Ava, MOA loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.Sep 1, 2023 · N9522Y · Substantial damageNTSB ENG23WA044Accident · 2 fatalClass 5 · ForeignChristen Eagle II · Raufoss, NorwayAug 29, 2023 · N · DestroyedNTSB DCA23WA429IncidentClass 4 · ForeignBoeing 737 · Palma de Mallorca, SpainAug 27, 2023 · G-DRTW · No damageNTSB ANC23LA065Accident · 2 fatalClass 3 · LimitedFinal reportBeech B36TC · Cape Yakataga, AKThe pilot’s continued flight into moderate to severe icing conditions, including supercooled large droplets, over mountainous terrain, which resulted in a loss of control and impact with terrain. Contributing to the accident was the National Weather Service…Aug 27, 2023 · N6709Q · DestroyedNTSB ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.Aug 26, 2023 · N114DZ · Substantial damageNTSB ANC23LA070Accident · Minor injuriesClass 3 · LimitedFinal reportOliver Robert K Oliver Series 6 · Big Delta, AKA partial loss of engine power for undetermined reasons.Aug 25, 2023 · N151RF · Substantial damageNTSB DCA23WA423Incident · No injuriesClass 5 · ForeignDouglas DC9 · Maturin, VenezuelaAug 24, 2023 · YV648T · No damageNTSB WPR23LA324Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20 · Fairfield, UTThe flight pilots improper fuel management, which resulted a total loss of engine power, and impact with terrain during an off-airport landing. Contributing to the accident was the flight instructor’s failure to follow the airplane checklist.Aug 23, 2023 · N989PA · Substantial damageNTSB GAA23WA243Accident · 2 fatalClass 5 · ForeignGulfstream 690C · Las Velas, VenezuelaAug 23, 2023 · YV2915 · DestroyedNTSB GAA23WA245Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · Enstone-, United KingdomAug 22, 2023 · G-CLHJ · DestroyedNTSB ERA23FA346Accident · 2 fatalClass 3 · FieldFinal reportBeech C-99 · Litchfield, MEA horizontal stabilizer pitch trim anomaly that was not identified in the available evidence.Aug 22, 2023 · N55RP · Destroyed