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 SEA94LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Rio Linda, CAThe pilot's improper mixture leaning procedure. Factor(s) were: the disconnected ignition lead, dark night conditions, unsuitable terrain and the fence.May 19, 1994 · N6747G · DestroyedNTSB FTW94FA165Accident · 2 fatalField investigationFinal reportCessna 340 · Elko, NVThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain altitude (or clearance) from mountainous terrain. Factors related to the accident were: the adverse weather conditions, high (mountainous/hilly) terrain,…May 18, 1994 · N5158J · DestroyedNTSB NYC94LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Lewisburg, WVThe pilot's inadequate inflight decision, inadvertent VFR flight into IMC, and failure to maintain adequate terrain clearance which resulted in inflight collision with trees. A factor was inadequate altitude.May 17, 1994 · N36236 · Substantial damageNTSB NYC94FA082Accident · 2 fatalField investigationFinal reportMooney M20K · Swanton, OHFailure of an engine cylinder which resulted in the loss of engine power and the pilot's failure to establish the proper descent path to an airport that was within the glide distance of the airplane. A factor was the overgross weight condition of the airplane.May 17, 1994 · N1007A · DestroyedNTSB LAX94LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Arvin, CAa fatigue failure of the crankshaft gear teeth.May 16, 1994 · N738VE · Substantial damageNTSB FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.May 16, 1994 · N47GY · DestroyedNTSB ATL94LA100Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hiram, GAThe inadvertent flight from VMC conditions to IMC conditions by the pilot. A factor in the accident was the ground fog in the area.May 16, 1994 · N160CA · Substantial damageNTSB MIA94LA137Accident · Serious injuriesLimited investigationFinal reportRichmond Rotorway Executive · Ormond Beach, FLThe pilot in command's improper autorotation following partial loss of engine power which resulted in an inflight collision with a fence prior to ground touchdown.May 13, 1994 · N520PR · Substantial damageNTSB ATL94LA098Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Burlington, NCInadvertent burner control interference by the passenger. A factor was the presence of electric transmission wires at the forced landing site.May 13, 1994 · N1511M · Substantial damageNTSB LAX94FA217Accident · 2 fatalField investigationFinal reportMooney M20K · Ventura, CAFailure of the flight crew to maintain control of the airplane in instrument meteorological conditions (IMC), due to spatial disorientation. A factor related to the accident was: the first pilot's overconfidence in his ability to assure control of the…May 12, 1994 · N231WD · DestroyedNTSB LAX94FA214Accident · 2 fatalField investigationFinal reportRobinson R-22 · Hacienda Height, CAThe pilot's selection of an en route cruise altitude which provided insufficient obstruction clearance, and his inadequate visual lookout. Factors in the night time accident were the reduced visibility as a result of the fog and haze.May 11, 1994 · N8047Y · DestroyedNTSB FTW94FA152Accident · 5 fatalField investigationFinal reportBell 206L-3 · Intracoastl Cty, LAThe pilot's failure to maintain aircraft control for undetermined reasons.May 10, 1994 · N5844 · DestroyedNTSB ATL94LA095Accident · Serious injuriesLimited investigationFinal reportSchweizer 300C · Randleman, NCThe pilot's failure to adequately preflight the helicopter which resulted in a complete loss of engine power. A factor was water in the fuel supply.May 9, 1994 · N220MS · Substantial damageNTSB FTW94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · High Island 334A total loss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.May 7, 1994 · N3648E · DestroyedNTSB CHI94LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Chapman, NEThe pilot-in-command's attempted VFR flight into instrument weather conditions which resulted in spatial disorientation. Factors associated with the accident were the pilot-in-command's over confidence in his personal ability.May 6, 1994 · N2938Q · DestroyedNTSB NYC94FA078Accident · 2 fatalField investigationFinal reportRobinson R22A · North Bergen, NJThe pilot's failure to maintain adequate visual lookout and adequate obstacle clearance, which resulted in an inflight collision with a static wire.May 5, 1994 · N503TH · DestroyedNTSB FTW94LA144Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Osage, ARFuel exhaustion due to the pilot's failure to refuel and the lack of suitable terrain for a forced landing.May 4, 1994 · N90469 · Substantial damageNTSB ATL94IA092Incident · No injuriesIncident investigationFinal reportSaab-Scania S340B · Nashville, TNEngine ice/slush ingestion that resulted in power interruptions and failure of the air data computer coupled with moisture ingestion of the static system. Factors were the failure of the manufacturer to correct a previously identified design deficiency that…May 3, 1994 · N245AE · No damageNTSB LAX94FA212Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · La Verne, CAThe pilot's selection of a flight route and en route descent altitude insufficient to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night light condition and the mountainous terrain.May 2, 1994 · N47628 · DestroyedNTSB CHI94LA144Accident · No injuriesLimited investigationFinal reportHelio H-800 · Foley, MNThe pilot-in-command's failure to perform accurate fuel consumption calculations. A factor was the soft gravel road landing area.May 2, 1994 · N4104D · Substantial damageNTSB CHI94FA155Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Mcintosh, SDVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) from rising terrain. Factors related to the accident were: failure of the pilot to update his weather…May 2, 1994 · N525GS · DestroyedNTSB ANC94LA053Accident · No injuriesLimited investigationFinal reportBeech 35 · Gustavus, AKThe pilot-in-command's delay in selecting the main fuel tank position. The lack of suitable terrain for a forced landing was a factor.May 2, 1994 · N441B · Substantial damageNTSB CHI94LA145Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rochelle, ILthe pilot's inadequate use of carburetor heat. Factors associated with the accident were carburetor icing conditions and rough terrain.Apr 30, 1994 · N7605P · Substantial damageNTSB MIA94LA128Accident · Minor injuriesLimited investigationFinal reportKeuthan Sabre II / S2A · Merritt Island, FLThe pilot-in-command's inadequate fuel consumption calculations and inadequate in-flight planning when encountering a headwind.Apr 29, 1994 · N692KA · Substantial damageNTSB SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.Apr 27, 1994 · N134Q · Substantial damageNTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.Apr 27, 1994 · N141UE · Minor damageNTSB BFO94LA079Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Williamstown, NJthe pilot's failure to accurately determine the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing.Apr 27, 1994 · N93AN · Substantial damageNTSB SEA94FA106Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Kellogg, IDFailure of the pilot to maintain aircraft control, due to spatial disorientation, while flying with partial panel, and the design stress limits of the aircraft being exceeded. Factors related to the accident were: failure of the vacuum system, which resulted…Apr 24, 1994 · N7659C · DestroyedNTSB LAX94LA204Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Acampo, CAThe pilot's failure to use carburetor heat during the extended power-off descent. The existing carburetor icing conditions, the pilot's diverted attention, and the power lines were factors in this accident.Apr 24, 1994 · N35095 · Substantial damageNTSB LAX94IA203Incident · Minor injuriesIncident investigationFinal reportFairchild SA-227 · Santa Monica, CAFAA inadequate separation standards between large and heavy category aircraft.Apr 23, 1994 · N27220 · Minor damageNTSB FTW94LA132Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Azle, TXThe instructor pilot's failure to maintain terrain and obstacle clearance. A factor was the instructor's diverted attention.Apr 23, 1994 · N86862 · DestroyedNTSB BFO94LA075Accident · No injuriesLimited investigationFinal reportCessna 150M · Washington Cros, NJthe pilot-in-command's inadequate in-flight planning which resulted in a total loss of engine power due to fuel exhaustion.Apr 23, 1994 · N6101K · Substantial damageNTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.Apr 23, 1994 · N2945F · Substantial damageNTSB FTW94LA133Accident · Minor injuriesLimited investigationFinal reportLaurel Aero Club Cassutt III M · Strasburg, COThe pilot's failure to attain the proper touchdown point. Factors were: a power failure due to a sheared accessory drive gear, excessive airspeed and altitude, and a soft field.Apr 22, 1994 · N8871 · Substantial damageNTSB CHI94IA134Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Chicago, ILa loose fuel nozzle.Apr 17, 1994 · N609AW · No damageNTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.Apr 17, 1994 · N9183D · DestroyedNTSB MIA94LA123Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spring Hill, FLUnsuitable terrain encountered during a forced landing. Contributing to the accident was the fatigue failure of one of the propeller blade's pitch change knob.Apr 16, 1994 · N8572P · Substantial damageNTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.Apr 16, 1994 · N4857P · Substantial damageNTSB BFO94FA066Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Salem, OHVFR flight by the pilot into instrument meteorological conditions (IMC), his loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: darkness, the adverse weather…Apr 16, 1994 · N8685C · DestroyedNTSB MIA94LA121Accident · 1 fatalLimited investigationFinal reportBack Forty Developments Tundra · Lakeland, FLIn-flight loss of control due to incapacitation (heart attack or stroke) resulting in an in-flight collision with tomato crates and terrain.Apr 15, 1994 · CIEEU · DestroyedNTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…Apr 15, 1994 · N39770 · DestroyedNTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.Apr 13, 1994 · N2728K · Substantial damageNTSB MIA94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · River Ranch, FLThe improper inspection of the worn throttle linkage connection at the fuel control, which resulted in the linkage becoming disconnected from the fuel control in flight and the engine losing power. This resulted in the aircraft colliding with a ditch during a…Apr 10, 1994 · N1395T · Substantial damageNTSB LAX94LA201Accident · No injuriesLimited investigationFinal reportSchweizer 300C · Pacific Ocean (Pacific Ocean)The low altitude of the aircraft when the engine lost power and the pilot's misjudgement of the flare point during the autorotation. Factors in the accident were the loss of engine power and the sunglare.Apr 10, 1994 · N60718 · Substantial damageNTSB SEA94LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hurricane, UTThe pilot in command's failure to refuel and excessive airspeed during the approach. Factor(s) were: fencepost(s) and the lack of recent experience in type of aircraft.Apr 9, 1994 · N4480P · Substantial damageNTSB LAX94FA185Accident · 1 fatalField investigationFinal reportCessna 172N · Julian, CAImproper planning/decision by the pilot(s). Factors related to the accident were: the high/mountainous terrain and adverse weather conditions.Apr 9, 1994 · N6242D · DestroyedNTSB BFO94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gloucester, VAThe pilot-in-command's failure to perform adequate pre-flight inspections and planning for the flight, and his failure to refuel the airplane. This led to fuel exhaustion of the engine and a forced landing.Apr 9, 1994 · N857DG · Substantial damageNTSB LAX94LA184Accident · Serious injuriesLimited investigationFinal reportCessna 182N · Kerman, CAAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, incapacition of the pilot, and loss of aircraft control.Apr 8, 1994 · N9124G · Substantial damageNTSB FTW94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Englewood, COA loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Apr 8, 1994 · N881GK · DestroyedNTSB ANC94LA046Accident · No injuriesLimited investigationFinal reportHelio 295 · Manley Hot Sprg, AKFuel starvation caused by a blocked fuel vent line. A factor in the accident was the improper aircraft preflight.Apr 8, 1994 · N42DC · Substantial damage