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 DEN05FA011Accident · 1 fatalField investigationFinal reportCessna 182R · Idaho Springs, COthe pilot's failure to maintain clearance from terrain, and his inadequate planning and decision making resulting in VFR flight into IMC. Contributing factors include the pilot's self-induced pressure to arrive at his destination, the low ceiling and the fog.Oct 13, 2004 · N9437H · DestroyedNTSB MIA05LA003Accident · Serious injuriesLimited investigationFinal reportde Havilland DH-82C · Cross City, FLA loss of engine power for undetermined reasons, which resulted in a forced landing.Oct 12, 2004 · N819DH · Substantial damageNTSB NYC05FA005Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Madison, CTA loss of engine power due to separation of the propeller due to under-torqued retention bolts.Oct 11, 2004 · N233PA · Substantial damageNTSB NYC05FA001Accident · 2 fatalField investigationFinal reportCessna 172N · Germantown, NYThe pilot's inadequate in-flight planning/decision which led to VFR flight into IMC and his loss of aircraft control. Factors were night and cloud conditions.Oct 10, 2004 · N2771J · Substantial damageNTSB DEN05LA008Accident · No injuriesLimited investigationFinal reportCessna 210M · Salida, COThe pilot's inadequate preflight planning which failed to determine the fuel supply was inadequate resulting in fuel exhaustion and the loss of engine power.Oct 10, 2004 · N732TE · Substantial damageNTSB DEN05CA006Accident · No injuriesData collectionFinal reportAerostar SP-1 · Albuquerque, NMthe pilot's failure to maintain clearance with the radio tower. Contributing factors were the pilot's improper compensation for the variable wind conditions.Oct 10, 2004 · N87SB · DestroyedNTSB NYC05CA003Accident · No injuriesData collectionFinal reportCessna 172M · Eliot, METhe pilot's inadequate in-flight planning decision, which resulted a loss of engine power due to fuel exhaustion.Oct 9, 2004 · N80657 · Substantial damageNTSB DEN05CA009Accident · Serious injuriesData collectionFinal reportThunder and Colt 180A · Albuquerque, NMthe balloon pilot's improper in-flight planning and failure to maintain aircraft control during descent into high winds resulting in a hard landing and subsequent serious injury to a passenger. Factors contributing to the accident were the high winds and…Oct 9, 2004 · N784TC · No damageNTSB ANC05LA003Accident · No injuriesLimited investigationFinal reportScan 30 · Anchorage, AKAn in-flight fire during cruise flight for an undetermined reason.Oct 9, 2004 · N701Q · Substantial damageNTSB FTW05CA001Accident · Minor injuriesData collectionFinal reportAerostar S-60A · Austin, TXThe pilot's excessive descent rate during the execution of a high wind landing, resulting in a hard landing. A factor was the high wind.Oct 4, 2004 · N70466 · Substantial damageNTSB DEN05LA004Accident · Serious injuriesLimited investigationFinal reportWorner Balloon Works NL-1000 · Chama, NMthe lightning strike and subsequent failure of the balloon's envelope, resulting in an uncontrolled descent and impact with terrain.Oct 3, 2004 · DOYES · DestroyedNTSB SEA05LA008Accident · No injuriesLimited investigationFinal reportHiggins Acro-Sport II · Coeur d'Alene, IDThe airplane's wood propeller separated from the airplane during cruise. A factor was the ditch that the airplane impacted during the landing roll subsequent to the forced landing.Oct 2, 2004 · N214JH · Substantial damageNTSB LAX05LA002Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZa loss of engine power due to the fatigue fracture of the number 7 cylinder exhaust rocker arm as a result of a grinding operation during manufacture.Oct 2, 2004 · N43064 · Substantial damageNTSB ATL05LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Ashland, ALA total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.Oct 2, 2004 · N40129 · Substantial damageNTSB MIA05LA001Accident · No injuriesLimited investigationFinal reportRotorway 162F · New Smyrna Beac, FLA loss of engine power due to undetermined reasons, which resulted in the pilot entering autorotation and affecting a forced landing to the water.Oct 1, 2004 · N7059F · Substantial damageNTSB MIA04LA134Accident · Serious injuriesLimited investigationFinal reportBoeing 767-232 · Caribbean SeaAn inadvertent encounter with severe turbulence during cruise, which resulted in a flight attendant being injured.Sep 29, 2004 · N109DL · No damageNTSB MIA04LA133Accident · 1 fatalLimited investigationFinal reportBritten-Norman BN-2A-27 · Vega Baja, PRThe pilot's improper inflight planning which resulted in an inflight encounter with weather (low ceilings and thunderstorms), his loss of aircraft control, and an inflight collision with the ocean during uncontrolled descent.Sep 29, 2004 · N902GD · DestroyedNTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.Sep 26, 2004 · N67520 · Substantial damageNTSB ATL04CA193Accident · No injuriesData collectionFinal reportCessna 177 · Anderson, SCThe pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.Sep 26, 2004 · N29650 · Substantial damageNTSB MIA04LA129Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Starkville, MSThe operator's inadequate maintenance inspections and the pilot's inadequate preflight inspection, which resulted in the helicopter being operated with a contaminated fuel system, that resulted in fuel starvation, and the loss of engine power.Sep 25, 2004 · N96PH · Substantial damageNTSB FTW04FA243Accident · 2 fatalField investigationFinal reportCessna 421C · Bee Caves, TXThe pilot's improper positioning of the fuel selector valves, which resulted in a loss of power to the left engine due to fuel exhaustion. After the power loss, the pilot failed to follow checklist procedures and did not secure (feather) the left propeller,…Sep 23, 2004 · N729DM · DestroyedNTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…Sep 22, 2004 · N2079S · Substantial damageNTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Sep 21, 2004 · N282HP · Substantial damageNTSB SEA04GA192Accident · 3 fatalFinal reportCessna U206G · Essex, MTThe pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…Sep 20, 2004 · N206SM · DestroyedNTSB LAX04CA326Accident · No injuriesData collectionFinal reportIar Sa Brasov 823 · Denair, CAthe pilot's failure to verify the fuel quantity on board prior to departure, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Sep 20, 2004 · N823WT · Substantial damageNTSB NYC04LA214Accident · Serious injuriesLimited investigationFinal reportRyan ST3KR · Bealeton, VAThe improper installation of fuel lines by maintenance personnel resulting in a total loss of engine power.Sep 19, 2004 · N57015 · Substantial damageNTSB LAX04LA324Accident · No injuriesLimited investigationFinal reportCirrus SR-22 · Peters, CAThe pilot's decision to continue flight into adverse weather and the subsequent encounter with the outer boundaries of a level 5 thunderstorm, which resulted in his loss of control of the airplane.Sep 19, 2004 · N931CD · Substantial damageNTSB MIA04CA130Accident · No injuriesData collectionFinal reportLemuel May Leza-Lockwood Aircam · Ashland, MSThe pilot's inadequate preflight planning/preparation for his failure to assure that the fuel shutoff valves located in both engine compartments were turned on and also the failure of the pilot to have a checklist to outline preflight items.Sep 18, 2004 · N9074W · Substantial damageNTSB CHI04LA283Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Houstonia, MOThe fatigue failure of the piston end of the connecting rod and the pilot's failure to maintain aircraft control during the forced landing.Sep 18, 2004 · N80237 · Substantial damageNTSB FTW04CA239Accident · No injuriesData collectionFinal reportCessna 150L · Mountain Home, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Sep 17, 2004 · N11418 · Substantial damageNTSB CHI04IA260Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Chicago, ILAn in-flight collision with a flock of birds during climb out after takeoff, which damaged the left engine fan module and ruptured a fuel line to the fuel-oil cooler causing an engine fire.Sep 16, 2004 · N253AA · Minor damageNTSB ATL04CA186Accident · No injuriesData collectionFinal reportCessna 172RG · Montgomery, ALThe separation of a hydraulic line for undetermined reasons, which resulted in a hydraulic fluid leak and malfunction of the landing gear.Sep 15, 2004 · N948SM · Substantial damageNTSB ATL04CA185Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's inadequate preflight inspection and a loss of engine power due to water contamination of the fuel.Sep 15, 2004 · N90375 · Substantial damageNTSB FTW04LA238Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sweeny, TXThe fracture failure of the left engine crankshaft for undetermined reasons.Sep 14, 2004 · N555MC · Substantial damageNTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.Sep 13, 2004 · N4661F · Substantial damageNTSB NYC04LA210Accident · No injuriesLimited investigationFinal reportCessna 172B · Wiscasset, METhe failure of the oil filter adapter seal, which resulted in a loss of oil pressure, and subsequent catastrophic engine failure, and forced landing.Sep 12, 2004 · N7422X · Substantial damageNTSB CHI04LA256Accident · 1 fatalLimited investigationFinal reportClaxton S-12 · Oconomowoc, WIThe loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.Sep 12, 2004 · UNREG · DestroyedNTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.Sep 11, 2004 · N35FD · Substantial damageNTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.Sep 10, 2004 · N6544F · Substantial damageNTSB FTW04FA235Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rachel, TXThe total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…Sep 9, 2004 · N6209J · DestroyedNTSB DEN04LA136Accident · No injuriesLimited investigationFinal reportCessna 182 · Gillette, WYimproper engine overhaul performed by the mechanic which resulted in the fractured exhaust valve and subsequent partial loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.Sep 6, 2004 · N2725G · Substantial damageNTSB SEA04LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Port Angeles, WAThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.Sep 5, 2004 · N5788T · Substantial damageNTSB MIA04LA127Accident · No injuriesLimited investigationFinal reportMooney M20F · Brandon, MSA loss of engine power due to the fatigue failure of all studs and/or thru-bolts of the No. 3 cylinder for undetermined reasons causing separation of the cylinder. Contributing to the accident was the unsuitable terrain encountered by the pilot.Sep 5, 2004 · N9708M · Substantial damageNTSB SEA04LA181Accident · No injuriesLimited investigationFinal reportHughes 369D · Cottage Grove, ORIn-flight loss of engine power during cruise for undetermined reasons.Sep 4, 2004 · N505ST · Substantial damageNTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…Sep 4, 2004 · N5005J · Substantial damageNTSB ANC04LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cantwell, AKAn in-flight fire for an undetermined reason, which resulted in an off-airport forced landing and subsequent destruction of the airplane by fire.Sep 4, 2004 · N9796P · DestroyedNTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.Sep 3, 2004 · N5208G · Substantial damageNTSB MIA04LA126Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Greenville, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. The pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply is a contributing factor.Sep 3, 2004 · N660HB · Substantial damageNTSB NYC04LA201Accident · No injuriesLimited investigationFinal reportPZL 101 · Chazy, NYThe total loss of engine power due to the fractured crankshaft.Aug 31, 2004 · N123LZ · Substantial damageNTSB LAX04IA311Incident · No injuriesIncident investigationFinal reportSikorsky S-70A · Pacoima, CAthe failure of the operator's mechanics to install the turboshaft engine's forward curvic seal during a gas generator turbine (GGT) replacement. Contributing factors to the incident were the failure of the manufacturer to provide a forward curvic seal with…Aug 30, 2004 · N160LA · Minor damage