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 FTW01LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Oil Trough, ARthe pilot's failure to refuel the airplane which resulted in the loss of engine power due to fuel exhaustion. A contributory factor was the lack of suitable terrain for the forced landing.Jun 8, 2001 · N400ZR · Substantial damageNTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.Jun 8, 2001 · N89320 · Substantial damageNTSB IAD01FA066Accident · 1 fatalField investigationFinal reportHughes 369A · Perry, WVThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. A contributing factor was mountainous terrain.Jun 7, 2001 · N58963 · DestroyedNTSB CHI01LA154Accident · Serious injuriesLimited investigationFinal reportBoeing B757-200 · Kokomo, INthe turbulence encountered during descent and the passenger failure to return to his seat.Jun 5, 2001 · N563UA · No damageNTSB LAX01FA200Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIa loss of engine power while in cruise flight resulting from the failure and liberation of several turbine blades due to hot corrosion effects which weakened the blades. The hot corrosion damage was the result of multiple turbine over temperature events which…Jun 4, 2001 · N1109V · Substantial damageNTSB MIA01FA152Accident · 5 fatalField investigationFinal reportPiper PA-31-T2 · Jackson, TNThe pilot's shutting down the left engine following loss of control of the left propeller resulting in an in-flight loss of control of the airplane due to the windmilling propeller. Factors in the accident were the failure of the propeller control bracket…Jun 3, 2001 · N31XL · DestroyedNTSB DEN01FA110Accident · 3 fatalField investigationFinal reportCessna T210G · Lyons, COThe pilot's inadequate preflight planning/preparation and his continued flight into adverse weather condition resulting in controlled flight into terrain. Contributing factors were the fog, low ceilings and the pilot's lack of recent experience.Jun 3, 2001 · N6886R · DestroyedNTSB CHI01LA152Accident · No injuriesLimited investigationFinal reportAllen Rotorway 162F · Jerseyville, ILthe improper autorotation by the pilot. Contributing factors were the engine failure for undetermined reason(s) and the muddy terrain.Jun 3, 2001 · N242KA · Substantial damageNTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.Jun 2, 2001 · N257LA · 2 aircraft · DestroyedNTSB ANC01LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to refuel the airplane, his inadequate preflight planning/decision making, and subsequent fuel exhaustion during cruise flight.Jun 2, 2001 · N9311T · Substantial damageNTSB SEA01LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Pingree, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power.Jun 1, 2001 · CFDGH · Substantial damageNTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.May 31, 2001 · N1389B · Substantial damageNTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.May 31, 2001 · N571SP · No damageNTSB NYC01LA135Accident · No injuriesLimited investigationFinal reportMusso Nieuport 24 · Evesham Twp., NJAn in-flight propeller failure, which resulted in a forced landing.May 31, 2001 · N1893 · Substantial damageNTSB ATL01LA060Accident · No injuriesLimited investigationFinal reportCessna 421C · Greenville, MSThe improper installation by maintenance personnel of the push-pull rod assembly on the right elevator trim tab horn resulted in an in-flight separation of the right elevator trim tab.May 29, 2001 · N51ER · Substantial damageNTSB MIA01LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 737-301 · Toccoa, GAAn in-flight encounter with unforecasted weather (turbulence) during an enroute climb resulting in one flight attendant sustaining serious injury.May 28, 2001 · N349US · No damageNTSB LAX01FA194Accident · 3 fatalField investigationFinal reportCessna 210A · Escondido, CAthe pilot's spatial disorientation and lack of instrument flight proficiency that resulted in a loss of directional control and the airplane's subsequent in-flight collision with the ground.May 28, 2001 · N9462X · DestroyedNTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.May 28, 2001 · N5447J · Substantial damageNTSB DEN01LA103Accident · Minor injuriesLimited investigationFinal reportHall Lancair 4P · Bennett, COunsuitable terrain on which to make a forced landing. A contributing factor was a fatigue fracture of the starter adapter drive shaft, which resulted in a loss of engine power due to oil starvation.May 28, 2001 · N707SH · Substantial damageNTSB MIA01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Spartanburg, SCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion, forced landing, and subsequent in-flight collision with trees and terrain. Contributing to the accident was an unidentified pilot's failure to yield the…May 27, 2001 · N6667Z · Substantial damageNTSB LAX01LA205Accident · No injuriesLimited investigationFinal reportCessna 337G · Temecula, CAThe pilot's intentional flight into adverse weather while operating under visual flight rules, his failure to maintain a cruising altitude sufficient to remain clear of power transmission wires, and his failure to maintain a visual lookout sufficient to see…May 27, 2001 · N337GD · Substantial damageNTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.May 27, 2001 · N9875E · Substantial damageNTSB DEN01LA102Accident · No injuriesLimited investigationFinal reportCessna T207A · Kanab, UTthe pilot's inadequate fuel consumption planning, and the subsequent fuel starvation, which resulted in a loss of engine power.May 27, 2001 · N6427H · DestroyedNTSB LAX01LA192Accident · No injuriesLimited investigationFinal reportCessna 150H · Mariposa, CAThe pilot's failure to properly refuel the aircraft which resulted in departure with an inadequate quantity of fuel onboard. A factor in the accident was the pilot's inadequate preflight preparation and planning, which failed to provide an adequate fuel…May 25, 2001 · N23474 · Substantial damageNTSB DEN01LA101Accident · No injuriesLimited investigationFinal reportGarrett Starduster TOO SA300 · Woodrow, COa precautionary landing on unsuitable terrain which was rough and uneven. Factors were deteriorating weather in the form of freezing rain, snow, and decreasing visibility.May 21, 2001 · N555CW · Substantial damageNTSB LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.May 20, 2001 · N9344X · Substantial damageNTSB LAX01FA186Accident · 1 fatalField investigationFinal reportBeech M35 · North Las Vegas, NVThe pilot/owner's failure to correctly install the oil filter, which resulted in oil exhaustion and a loss of engine power. Also causal was his attempt to modify the design of the oil filter element adapter by breaking the bond between the base and the…May 19, 2001 · N9820R · Substantial damageNTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.May 19, 2001 · N2808S · Substantial damageNTSB LAX01LA184Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Apple Valley, CAThe pilot's fuel mismanagement, which led to fuel exhaustion, a loss of engine power, and subsequent landing on unsuitable terrain.May 18, 2001 · N1606B · Substantial damageNTSB LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.May 18, 2001 · N2479S · DestroyedNTSB ANC01IA058Incident · No injuriesIncident investigationFinal reportCessna 207 · Quinhagak, AKAn in-flight fracture of the engine crankshaft during descent, precipitated by restricted oil flow through an internal engine oil passage/port.May 18, 2001 · N917AC · Minor damageNTSB LAX01LA179Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paulden, AZCatastropic engine failure due to oil depletetion caused by an oil filter gasket failure.May 17, 2001 · N22467 · Substantial damageNTSB FTW01LA120Accident · No injuriesLimited investigationFinal reportKirchner Pietenpol Aircamper · Tulsa, OKthe pilot's inadequate flare during the forced landing, which resulted in a hard landing. A contributing factor was the engine overheating due a stuck oil cooler thermostat valve, which resulted in a loss of power.May 17, 2001 · N25157 · Substantial damageNTSB CHI01LA141Accident · No injuriesLimited investigationFinal reportParker Rotorway 162F · Minneapolis, MNThe tail rotor drive belt coming off in cruise flight and it not being possible for the student pilot to maintain aircraft control during the emergency landing attempt. Factors relating to the accident were the loose bearing in the secondary drive unit to the…May 16, 2001 · N311RM · Substantial damageNTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.May 15, 2001 · N992AF · Minor damageNTSB DEN01FA098Accident · 1 fatalField investigationFinal reportBeech King Air B90 · San Jon, NMthe pilot's failure to maintain aircraft control due to his incapacitation for an undetermined reason. A contributing factor was the subsequent inadvertent stall/spin to the ground.May 15, 2001 · N221CH · DestroyedNTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.May 14, 2001 · N2890X · Substantial damageNTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.May 13, 2001 · N404BA · DestroyedNTSB NYC01FA122Accident · 1 fatalField investigationFinal reportCessna U206E · New Market, VAA loss of engine power due to a failure of the number 5 piston for undetermined reasons. A factor in this accident was the inadequate emergency handling provided by the air route traffic controller.May 12, 2001 · N948CG · Substantial damageNTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.May 12, 2001 · N1674E · Substantial damageNTSB NYC01LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA 31-350 · Nahant, MAA loss of engine power due to fuel exhaustion for undetermined reasons. A factor in this accident was the pilot's failure to visual check the airplane's fuel quantity prior to takeoff.May 7, 2001 · N3558G · Substantial damageNTSB DEN01TA095Accident · No injuriesFinal reportHiller UH-12E · Conchas, NMthe pilot's misjudgment of the flare, which resulted in a hard landing. Contributing factors were weather conditions conducive to carburetor icing, the pilot's delay in applying carburetor heat, and his inattention to the carburetor air temperature gauge.May 7, 2001 · N40296 · Substantial damageNTSB NYC01LA118Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Brewer, METhe pilot's inadequate preflight preparation, which resulted in insufficient fuel in the forward tank and loss of engine power during the climb. Also causal, was the pilot's failure to maintain airspeed after the engine failure, which resulted in an…May 6, 2001 · N9267E · Substantial damageNTSB NYC01LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Osceola Mills, PAA partial power loss due to a stuck exhaust valve in the # 2 cylinder, which resulted in a forced landing. A factor was the rising terrain.May 5, 2001 · N51104 · Substantial damageNTSB ANC01LA054Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's failure to refuel the airplane, and subsequent fuel exhaustion. A factor in the accident was an inadvertent stall during an emergency descent/landing.May 5, 2001 · N5530T · Substantial damageNTSB FTW01FA115Accident · No injuriesField investigationFinal reportBell 407 · Vermillion 44Failure of the engine-to-transmission driveshaft coupling due to fatigue.May 4, 2001 · N917AL · Substantial damageNTSB DEN01LA100Accident · No injuriesLimited investigationFinal reportCessna T206H · Watkins, COthe pilot's failure to maintain the proper decent rate during the flare resulting in a hard landing. Contributing factors icing conditions and accumulations of wing ice.May 2, 2001 · N72582 · Substantial damageNTSB FTW01FA111Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · The Woodlands, TXThe pilot's failure to maintain airplane control following a loss of right engine power, which resulted in impact with terrain in an uncontrolled descent. A contributing factor was the loss of right engine power as a result of the fatigue failure of the…May 1, 2001 · N16CG · DestroyedNTSB SEA01LA080Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T45 · Royal City, WALoss of engine power for undetermined reasons. Trees were a factor.Apr 30, 2001 · N6129D · Substantial damageNTSB IAD01FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Afton, VAThe pilot's loss of consciousness due to a medical condition, which resulted in his failure to maintain control of the airplane and subsequent impact with rising terrain.Apr 30, 2001 · N7680J · Destroyed