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 GAA22WA155AccidentClass 5 · ForeignCessna 172 · Les Saintes Terre-de-Haut, GuadeloupeFeb 18, 2022 · F-OOOO · Substantial damageNTSB WPR22FA098Accident · 1 fatalClass 3 · FieldFinal reportBell UH-1H · Coalinga, CAThe pilot’s loss of situational awareness for reasons that could not be determined given the available evidence, which led to controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the helicopter while ill and…Feb 17, 2022 · N72297 · Substantial damageNTSB GAA22WA102Accident · 1 fatalClass 5 · ForeignCessna FA150 · Utrera, SpainFeb 16, 2022 · D-EATUNTSB GAA22WA104Accident · No injuriesClass 5 · ForeignCessna 152 · Concepción ( CLCP ), BoliviaFeb 15, 2022 · CP-3002 · Substantial damageNTSB ERA22LA120Accident · 8 fatalClass 3 · LimitedFinal reportPilatus PC-12/47E · Beaufort, NCThe pilot’s inadequate preflight planning, inadequate inflight monitoring of the airplane’s flight parameters, and his failure to regain control of the airplane following entry into an inadvertent aerodynamic stall. The pilot’s likely spatial disorientation…Feb 13, 2022 · N79NX · DestroyedNTSB CEN22LA117Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Lincoln, NEThe pilot’s decision to continue the flight with abnormal engine indications and the subsequent failure of the No. 5 cylinder connecting rod for unknown reasons.Feb 11, 2022 · N317KJ · Substantial damageNTSB WPR22FA094Accident · Minor injuriesClass 3 · FieldFinal reportDassault Mirage F1 CR · Glendale, AZA loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s…Feb 10, 2022 · N633AX · DestroyedNTSB ENG22WA013Incident · No injuriesClass 5 · ForeignBoeing 737 · Lanseria, South AfricaFeb 10, 2022 · ZS-ZWD · Minor damageNTSB ERA22LA117Accident · No injuriesClass 3 · LimitedFinal reportHughes 369D · Bel Air, MDA loss of engine power due to bearing failures in the turbine section resulting from a fatigue fracture of the oil supply line that fed oil to the Nos. 6 and 7 bearings. The oil line failure led to rapid deterioration of the bearings from oil starvation.…Feb 9, 2022 · N9159F · Substantial damageNTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.Feb 8, 2022 · N9500E · Substantial damageNTSB DCA22WA078IncidentClass 5 · ForeignBoeing 767-332 · Madrid, SpainFeb 8, 2022 · N1602 · No damageNTSB GAA22WA093Incident · No injuriesClass 4 · ForeignCessna 340A · Bussy-Lettrée, FranceFeb 6, 2022 · N340YZ · No damageNTSB GAA22WA141Accident · Minor injuriesClass 5 · ForeignPiper PA23 · Hertfordshire, United KingdomFeb 4, 2022 · G-BJNZ · Substantial damageNTSB GAA22WA095Accident · 2 fatalClass 5 · ForeignCessna 172 · Region de la Araucania, ChileFeb 4, 2022 · CC-AFA · DestroyedNTSB ERA22FA114Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · Danville, VAThe pilot’s impairment due to exposure to carbon monoxide as a result of undetected engine exhaust penetration into the cockpit, resulting in the pilot's failure to maintain a minimum controllable airspeed after partially securing an engine after takeoff.Feb 1, 2022 · N622QT · DestroyedNTSB GAA22WA306Accident · Minor injuriesClass 5 · ForeignPiper PA32 · Nassau, BahamasJan 31, 2022 · N1215H · DestroyedNTSB WPR22LA089Accident · No injuriesClass 3 · LimitedFinal reportBlake D Barrymore Just Acft Superstol · Ketchum, IDThe total loss of engine power due to carburetor ice.Jan 30, 2022 · N8794G · Substantial damageNTSB GAA22WA079Accident · Serious injuriesClass 5 · ForeignBell 206 · Camrose-Alberta, CanadaJan 23, 2022 · C-FCQJ · Substantial damageNTSB GAA22WA097Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Florianopolis, BrazilJan 19, 2022 · PR-NEW · Substantial damageNTSB WPR22LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28 · Scottsdale, AZA loss of engine power due to oil exhaustion.Jan 18, 2022 · N5276W · Substantial damageNTSB DCA22WA074Accident · Serious injuriesClass 5 · ForeignAirbus A320 · Okayama City, JapanJan 16, 2022 · JA24MC · No damageNTSB DCA22WA089IncidentClass 5 · ForeignAirbus A320 · Sukkur, PakistanJan 15, 2022 · A6-ANS · 2 aircraft · No damageNTSB CEN22LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Lamesa, TXThe pilot’s failure to maintain clearance from terrain during a descent that resulted in an impact with terrain.Jan 15, 2022 · N6916D · Substantial damageNTSB WPR22LA080Accident · Serious injuriesClass 3 · LimitedFinal reportWalter Tachiki Tachiki 750 Cruzer · Spanish Fork, UTA partial loss of engine power due to an obstructed catalytic converter, which most likely resulted from the pilot’s failure to properly repair or replace it after it was likely damaged during a previous incident. Contributing to the accident was the pilot’s…Jan 14, 2022 · N145WT · Substantial damageNTSB CEN22FA100Accident · 2 fatalClass 3 · FieldFinal reportBell 407 · Houma, LAThe pilot’s sudden loss of consciousness for undetermined reasons during cruise flight, which resulted in a loss of control and impact with terrain.Jan 14, 2022 · N167RL · DestroyedNTSB GAA22WA080Accident · No injuriesClass 5 · ForeignBell 412 · Valencia, SpainJan 13, 2022 · EC-GSK · Substantial damageNTSB ERA22LA109Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lexington, SCA loss of engine power due to a shift of the No. 3 main journal bearing, which resulted in blocked oil ports that restricted oil to the engine’s internal components and a subsequent catastrophic engine failure.Jan 13, 2022 · N879CD · Substantial damageNTSB ERA22LA104Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Edisto Island, SCA loss of engine power due to the fatigue failure of the crankshaft counterweight retaining ring and the No. 6 connecting rod.Jan 11, 2022 · N475RT · Substantial damageNTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.Jan 11, 2022 · N531LN · Substantial damageNTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.Jan 9, 2022 · N585CK · DestroyedNTSB DCA22WA223OccurrenceClass 5 · ForeignBoeing 737 · Durgapur, IndiaJan 5, 2022 · VT-SLHNTSB DCA22WA068IncidentClass 5 · ForeignBoeing 737 · Santiago, VenezuelaJan 5, 2022 · YV2823 · No damageNTSB GAA22WA072AccidentClass 5 · ForeignRobinson R22 · Karamea, New ZealandJan 2, 2022 · ZK-HEQ · Substantial damageNTSB CEN22LA093Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Montrose, COA partial loss of engine power for reasons that could not be determined based on the available evidence.Jan 2, 2022 · N750DP · Substantial damageNTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.Dec 31, 2021 · N6796N · Substantial damageNTSB ERA22FA098Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bronson, FLA loss of control due to spatial disorientation as a result of the noninstrument-rated pilot’s improper decision to attempt a visual flight rules flight at night into an area of known reduced visibility due to fog.Dec 31, 2021 · N442VB · DestroyedNTSB ERA22LA097Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 207 · Marathon, FLA total loss of engine power due to the failure of the No. 2 bearing, which resulted in the No. 2 connecting rod failing due to fatigue, high heat, and stress.Dec 29, 2021 · N1596U · Minor damageNTSB ERA22FA096Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cosby, TNThe pilot’s intentional, continued flight into instrument meteorological conditions in a helicopter that was not certified for instrument conditions, which resulted in a loss of helicopter control and a collision with trees and terrain.Dec 29, 2021 · N544SC · Substantial damageNTSB GAA22WA065AccidentClass 5 · ForeignCessna 172L · Koggala, Sri LankaDec 27, 2021 · 4R-GAF · Substantial damageNTSB CEN22FA082Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Hardy, ARThe non-instrument rated pilot’s decision to continue visual flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was a loss of engine power due to fuel…Dec 26, 2021 · N5798T · DestroyedNTSB GAA22WA073Incident · No injuriesClass 5 · ForeignPiper PA38 · Katukurunda, Sri LankaDec 22, 2021 · 4R-ASJ · Minor damageNTSB GAA22WA053IncidentClass 5 · ForeignPiper PA34 · Newcastle, IrelandDec 21, 2021 · G-OBUC · Substantial damageNTSB CEN22FA081Accident · 2 fatalClass 3 · FieldFinal reportCessna 208 · Fulshear, TXThe limitations of the see-and-avoid concept as a method for self-separation of aircraft, which resulted in an inflight collision. Contributing to the accident was the absence of collision avoidance technology on both aircraft.Dec 21, 2021 · N1116N · 2 aircraft · DestroyedNTSB GAA22WA063Accident · 4 fatalClass 4 · ForeignRockwell 114 · Redcliffe, AustraliaDec 18, 2021 · VH-WMM · DestroyedNTSB GAA22WA051Accident · No injuriesClass 3 · ForeignRobinson R66 · Boca de Yuma, Dominican RepublicDec 17, 2021 · HI-982 · Substantial damageNTSB GAA22WA076Accident · No injuriesClass 5 · ForeignCessna 172 · Pallisa-KAGWARA, UgandaDec 15, 2021 · 5X-KYO · Substantial damageNTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.Dec 14, 2021 · N150AS · DestroyedNTSB CEN22FA070Accident · 1 fatalClass 3 · FieldFinal reportCessna 310J · Inola, OKThe loss of airplane control for reasons that could not be determined based on the available evidence.Dec 12, 2021 · N3187L · DestroyedNTSB WPR22LA062Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Temecula, CAThe total loss of engine power for reasons that could not be determined from the available evidence.Dec 11, 2021 · N654HR · Substantial damageNTSB GAA22WA046Accident · No injuriesClass 5 · ForeignSchweizer 269C · Silesian, PolandDec 11, 2021 · SP-KGO