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 BFO94LA110Accident · Minor injuriesLimited investigationFinal reportRyan Navion B · Amherst, OHInadequate maintenance by an unqualified person which resulted in the loss of engine ignition due to worn ignition wires.Jun 22, 1994 · N5360K · Substantial damageNTSB SEA94FA154Accident · 1 fatalField investigationFinal reportCessna 172 · Port Angeles, WALack of oil and connecting rod failure. A factor to the accident was rough/uneven terrain.Jun 21, 1994 · N8025B · DestroyedNTSB MIA94LA163Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Bartow, FLThe pilot-in-command's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with wires. Contributing to the accident was the total loss of engine power due to the pilot's improper fuel consumption calculations, and…Jun 21, 1994 · N9992Y · Substantial damageNTSB CHI94LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Station, INthe pilot-in-command's inattention to the fuel supply. A factor was rough and uneven terrain.Jun 21, 1994 · N4572X · Substantial damageNTSB NYC94LA101Accident · Minor injuriesLimited investigationFinal reportJones Thorp T-18 · East Quogue, NYInadequate maintenance which resulted in oil-fouled spark plugs and the loss of engine power.Jun 20, 1994 · N64628 · Substantial damageNTSB LAX94LA261Accident · 2 fatalLimited investigationFinal reportCessna 152 · Half Moon Bay, CAThe pilot's loss of aircraft control due to spatial disorientation.Jun 20, 1994 · N761GZ · DestroyedNTSB SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.Jun 19, 1994 · N735QB · Substantial damageNTSB FTW94LA202Accident · Serious injuriesLimited investigationFinal reportRiley, Donald Rutan Varieze · Fort Lupton, COBlockage of the oil scavenge pump by foreign material which was introduced into the engine during maintenance. A factor was the lack of suitable terrain for the forced landing.Jun 19, 1994 · N111DR · DestroyedNTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.Jun 19, 1994 · N9766K · DestroyedNTSB BFO94LA111Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF5 · Put-In-Bay, OHThe total loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jun 19, 1994 · N5YM · Substantial damageNTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.Jun 18, 1994 · N7825P · Substantial damageNTSB BFO94FA108Accident · 1 fatalField investigationFinal reportCessna 152 · Mohawk, NYThe pilot's failure to maintain adequate airspeed. A factor is the pilot's overconfidence in his ability.Jun 18, 1994 · N4833B · DestroyedNTSB BFO94FA104Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Warren Grove, NJThe pilot disregarded weather evaluations, attempted VFR flight into IMC and failed to maintain altitude and clearance from the terrain.Jun 18, 1994 · N62701 · DestroyedNTSB FTW94IA198Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Caddo, OKThe fuel nozzle drain leak due to a defective o-ring.Jun 17, 1994 · N632AS · Minor damageNTSB CHI94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Joseph, MOthe loss of engine power due to the failure of the number two cylinder.Jun 17, 1994 · N5025S · Substantial damageNTSB CHI94LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Tomahawk, WIThe loss of engine power due to an undetermined reason. Factors in the accident were the lack of suitable terrain in preventing the pilot from making a safe forced landing.Jun 17, 1994 · N8218R · DestroyedNTSB ATL94FA121Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Youngstown, FLSpatial disorientation experienced by the pilot, which resulted in his failure to maintain aircraft control. Factors were the conditions conducive to spatial disorientation (dark night lighting conditions, high cloud cover, thunderstorms), and the pilot's…Jun 17, 1994 · N74693 · DestroyedNTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.Jun 15, 1994 · N69227 · Substantial damageNTSB CHI94FA202Accident · 2 fatalField investigationFinal reportBell 47G2 · Baldwin, ILThe inadequate maintenance (inspection of aircraft) by maintenance personnel, which resulted in a loss of engine power due to fuel exhaustion. Related factors are the unsafetied fuel filter, and low altitude at which the helicopter operated.Jun 15, 1994 · N4992G · DestroyedNTSB BFO94LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Raynham, MAFailure of the number four cylinder piston rings.Jun 15, 1994 · N8029Z · Substantial damageNTSB SEA94LA149Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH-12L4 · Clarkston, WADisconnection of the ballast bar aft retaining pin. Factor(s) were: tail rotor blade separation and reduced aircraft control.Jun 14, 1994 · N67264 · Substantial damageNTSB LAX94LA252Accident · Minor injuriesLimited investigationFinal reportTwibell Richard Dale Tiny TWO · Hesperia, CAA loss of engine power for undetermined reasons.Jun 12, 1994 · N52535 · Substantial damageNTSB CHI94LA197Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Millstadt, ILthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion. Related factors are the loose fuel cap (siphoning) and the uneven terrain encountered during the forced landing.Jun 12, 1994 · N94752 · Substantial damageNTSB BFO94LA098Accident · Minor injuriesLimited investigationFinal reportBellah Rotorway Executive · Johnson City, NYThe failure of the tail rotor drive belt due to undetermined reasons. This led to a loss of directional control and an autorotation.Jun 12, 1994 · N727TB · Substantial damageNTSB LAX94LA250Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Suisun City, CAundetermined.Jun 11, 1994 · N7112T · DestroyedNTSB BFO94FA096Accident · 2 fatalField investigationFinal reportCessna 210B · Culpepper, VAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control of the aircraft. Contributing factors were the low ceilings and clouds.Jun 11, 1994 · N210M · DestroyedNTSB CHI94LA196Accident · Serious injuriesLimited investigationFinal reportPopehn Arthur J. Coot A · Circle Pines, MNthe pilot-in-command's inattention to the fuel supply. Factors were the pilot-in-command's diverted attention, his not performing refueling, and rough/uneven terrain.Jun 10, 1994 · N123AP · Substantial damageNTSB LAX94FA243Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Banning, CAThe failure of both pilots to see and avoid each other. The haze was a factor.Jun 9, 1994 · N4512Z · 2 aircraft · DestroyedNTSB MIA94FA155Accident · 4 fatalField investigationFinal reportBeech 95-C55 · Wauchula, FLDelay by the pilot-in-command to obtain weather avoidance assistance from the ARTCC controller resulting in the inflight breakup after encounter with a thunderstorm.Jun 7, 1994 · N966N · DestroyedNTSB ATL94FA116Accident · 1 fatalField investigationFinal reportMooney M20C · West Columbia, SCThe pilot's failure to maintain control of the airplane during climbout because of spatial disorientation. Factors were low ceilings and the dark night.Jun 7, 1994 · N6879U · DestroyedNTSB BFO94FA112Accident · 2 fatalField investigationFinal reportBeech 24R · Nantucket, MAthe total loss of engine power over unsuitable terrain, for undetermined reasons. The pilot's failure to ensure that proper survival equipment was onboard the airplane was a related factor.Jun 6, 1994 · N9258S · DestroyedNTSB SEA94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Sweet Home, ORThe pilot delayed using carburetor heat until the engine had already lost power due to ice forming in the carburetor throat. Factors include carburetor icing conditions, and rough/uneven terrain in the field where the forced landing was made.Jun 5, 1994 · N9271T · Substantial damageNTSB BFO94LA087Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Morrisville, VTThe pilot's premature release from the tow plane. The lack of lift and the downdraft were factors.Jun 3, 1994 · N4194D · DestroyedNTSB LAX94LA236Accident · 1 fatalLimited investigationFinal reportSharp Scorpion TOO · Beckwourth, CAthe failure of the tail rotor 'V' drive belt for undetermined reasons and the subsequent failure and separation of the tail rotor.Jun 2, 1994 · N288JS · DestroyedNTSB LAX94LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Trinity Center, CAthe fatigue fracture of the crankshaft due to improper maintenance installation of the number 1 cylinder and the inadequate torquing of the case through bolts at that location.Jun 1, 1994 · N36025 · Substantial damageNTSB NYC94LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Spring City, PAThe pilot's improper inflight planning and inaccurate fuel consumption calculations, resulting in fuel supply exhaustion, loss of engine power, and the subsequent collision with trees during a forced landing.May 30, 1994 · N68186 · Substantial damageNTSB CHI94LA182Accident · No injuriesLimited investigationFinal reportCessna P-210N · Milwaukee, WIImproper in-flight planning and decision making by the pilot which resulted in fuel exhaustion.May 28, 1994 · N4UD · Substantial damageNTSB ATL94LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Williston, TNThe pilot's failure to maintain flying speed which resulted in a stall and a collision with the ground.May 28, 1994 · N9314V · Substantial damageNTSB CHI94LA180Accident · No injuriesLimited investigationFinal reportMooney M20E · Omaha, NEinaccurate fuel consumption calculations and the inadequate fuel supply for the flight. Factors related to the accident were the ditch and the quantity gage which gave a false indication.May 27, 1994 · N6942U · Substantial damageNTSB CHI94LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Bolivar, MOthe failure of a pressure fuel line. A factor was the encountering of unsuitable terrain during a forced landing.May 27, 1994 · N3191Q · Substantial damageNTSB FTW94LA181Accident · No injuriesLimited investigationFinal reportMooney M20J · Willcox, AZThe failure of the connecting rod due to lack of lubrication. Factors were the previous damage to the engine, and the unsuitable terrain at the pilot's disposal for the forced landing.May 26, 1994 · N50105 · Substantial damageNTSB CHI94LA176Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Bancroft, WIthe pilots failure to select carburetor heat during an extended descent, which resulted in loss of engine power. Factors were carburetor icing conditions and the presence of a ditch at the forced landing site.May 25, 1994 · N1659S · Substantial damageNTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.May 24, 1994 · N5512P · Substantial damageNTSB FTW94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Page, AZThe total loss of engine power for undetermined reason. A factor was the lack of suitable terrain at the pilot's disposal.May 23, 1994 · N1422E · Substantial damageNTSB FTW94LA170Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 6103 Twin Astir · Forrest City, ARThe pilot's loss of aircraft control when he diverted his attention to closing the canopy. A factor was his failure to properly close the canopy prior to takeoff.May 22, 1994 · N156SS · Substantial damageNTSB ATL94FA102Accident · 1 fatalField investigationFinal reportBeech A36 · Statesville, NCA LOSS OF CONTROL FOR UNDETERMINED REASON(s).May 22, 1994 · N1551K · DestroyedNTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.May 21, 1994 · N8JE · Substantial damageNTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.May 21, 1994 · N1669Z · DestroyedNTSB NYC94LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Addison, NYThe pilot's improper inflight planning and decision, resulting in fuel exhaustion and the subsequent forced landing and collision with trees.May 21, 1994 · N3335V · Substantial damageNTSB SEA94LA122Accident · 1 fatalLimited investigationFinal reportVickers Spitfire Mark Xviii · Great Falls, MTThe pilot's failure to maintain aircraft control while in instrument meteorological conditions (IMC). Factors include the pilot's poor inflight decision to attempt an IMC climb in an aircraft not certified for instrument flight rules (IFR) operation, and his…May 19, 1994 · N41702 · Destroyed