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 CHI94LA069Accident · Serious injuriesLimited investigationFinal reportPlummer Supercat · Stafford, KSThe pilot's failure to refuel the airplane prior to fuel exhaustion, and his failure to maintain airspeed resulting in an aerodynamic stall. His inadequate training was a factor in the accident.Jan 23, 1994 · UNREG · Substantial damageNTSB CHI94FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Waseca, MNContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the ground. Factors related to the accident were: an inaccurate weather forecast by…Jan 23, 1994 · N4510N · DestroyedNTSB CHI94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Newberry, MIan engine fire which started as the result of an oil leak around the engine oil filter.Jan 22, 1994 · N39505 · DestroyedNTSB MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.Jan 21, 1994 · N68411 · Substantial damageNTSB ATL94LA041Accident · No injuriesLimited investigationFinal reportCessna T210N · Hayesville, NCThe fatigue failure of no. 2 exhaust valve which resulted from excessive heat and wear to the valve stem. A factor was the dark night.Jan 20, 1994 · N6191N · Substantial damageNTSB SEA94FA051Accident · 1 fatalField investigationFinal reportCessna 140 · Lopez, WAThe pilot/owner's improper installation of the oil temperature sensing bulb, the total loss of all engine oil, and the shearing of a connecting rod cap.Jan 18, 1994 · N77190 · Substantial damageNTSB BFO94LA027Accident · Serious injuriesLimited investigationFinal reportCessna 425 · London, KYLoss of engine power due to fuel contamination.Jan 18, 1994 · N303MC · Substantial damageNTSB MIA94LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Boynton Beach, FLPartial loss of engine power for undetermined reasons.Jan 17, 1994 · N2338T · DestroyedNTSB MIA94LA054Accident · No injuriesLimited investigationFinal reportRobinson R22B · Gurabo, PRComplete separation of one of the two vee-belts, and complete separation of 1/2 of the remaining belt. Contributing to the accident was the dark night condition and unsuitable terrain encountered during the autorotative landing.Jan 16, 1994 · N193HC · Substantial damageNTSB BFO94LA026Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Middletown, OHA frozen oil line resulting in the starvation of oil to the engine and subsequent loss of engine power. A related factor was the unsuitable terrain for a forced landing.Jan 16, 1994 · N41826 · Substantial damageNTSB BFO94LA025Accident · No injuriesLimited investigationFinal reportBeech 33 · Poughkeepsie, NYThe partial loss of engine power due to undetermined reasons. Related to the accident was the lack of suitable terrain to complete a successful forced landing.Jan 16, 1994 · N930T · Substantial damageNTSB ATL94GA038Accident · Serious injuriesFinal reportHughes 269C · Atlanta, GAThe inadvertent closing of the fuel shutoff valve by the pilot. A factor in the accident was the failure of the pilot to maintain rotor RPM during the autorotation.Jan 16, 1994 · N8994F · Substantial damageNTSB BFO94LA024Accident · Serious injuriesLimited investigationFinal reportCessna P210N · New Castle, DELoss of partial engine power due to undetermined reasons.Jan 15, 1994 · N5088W · Substantial damageNTSB LAX94LA094Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Warner Springs, CAa loss of engine power for undetermined reasons.Jan 14, 1994 · N140KT · Substantial damageNTSB MIA94LA051Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Miami, FLThe pilot-in-command's improper supervision of an unqualified pilot while maneuvering at a low altitude. This resulted in a loss in rotor rpm due to improper flight control input (upward collective pitch), and subsequent in-flight collision with terrain.Jan 13, 1994 · N931KC · DestroyedNTSB CHI94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Highland, INAn electrical system failure due to a fractured alternator mounting lug. Factors related to the accident were the rough terrain, and decreasing visibility due to snow and darkness.Jan 13, 1994 · N8117Z · Substantial damageNTSB FTW94LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Vacherie, LAWas fuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.Jan 7, 1994 · N1063U · Substantial damageNTSB MIA94MA048Accident · 10 fatalMajor investigationFinal reportBeech B90 · Okeechobee, FLThe pilot's improper remedial action concerning a right engine power anomaly, and his failure to maintain adequate airspeed during go-around from an aborted precautionary landing, which resulted in a loss of aircraft control and an uncontrolled descent.…Jan 5, 1994 · N230TW · DestroyedNTSB MIA94LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Live Oak, FLThe improper use of the fuel selector by the pilot-in-command by switching to an empty fuel tank. Contributing to the accident was the pilot's failure to switch back to a tank with fuel.Jan 4, 1994 · N8331U · Substantial damageNTSB LAX94LA090Accident · 1 fatalLimited investigationFinal reportBell 206B · Coolidge Dam, AZthe pilot's selection of a cruise altitude insufficient to ensure adequate obstacle clearance and his inadequate visual lookout. A factor in the accident was the inconspicuousness of the power lines.Jan 4, 1994 · N771GM · DestroyedNTSB NYC94LA045Accident · No injuriesLimited investigationFinal reportCessna 206A · Williamsburg, VAan exhaust valve failure that created a hole in the piston, which allowed the complete loss of engine oil, resulting in the subsequent forced landing.Jan 3, 1994 · N776P · Substantial damageNTSB MIA94LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Raymond, MSThe pilot-in-command's delay in identifying carburetor ice and improper use of carburetor heat.Jan 2, 1994 · N3089J · Substantial damageNTSB FTW94LA061Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Mason, TXLoss of aircraft control for an undetermined reason.Jan 1, 1994 · N7092Q · DestroyedNTSB FTW94FA059Accident · Serious injuriesField investigationFinal reportCessna 177RG · La Veta, COThe pilot's improper inflight decision to enter a mountain pass at an inadequate altitude, causing the aircraft's climb performance to be exceeded. Factors were turbulence and downdrafts.Jan 1, 1994 · N53049 · DestroyedNTSB MIA94LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vicksburg, MSThe pilot did not maintain the proper glidepath. Failure of the electrical system and inadequate maintenance by company maintenance personnel were factors in the accident.Dec 31, 1993 · N5192W · Substantial damageNTSB MIA94LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lantana, FLThe pilot-in-command's failure to obtain emergency assistance after becoming temporarily lost, resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the dispatch of the student on the cross-country flight by the CFI…Dec 31, 1993 · N8532G · Substantial damageNTSB FTW94FA057Accident · 3 fatalField investigationFinal reportCessna 177RG · Van Horn, TXThe pilot exceeded the design stress limits of the aircraft after a loss of control which resulted from VFR flight into instrument meteorological conditions. Factors were the weather, the pilot's lack of instrument training and experience, and his failure to…Dec 29, 1993 · N1527H · DestroyedNTSB LAX94LA083Accident · Minor injuriesLimited investigationFinal reportRotorway EXEC-90 · Scottsdale, AZA failure of the pilot-in-command to adequately conduct a preflight inspection and properly secure a fuselage cowling panel that struck a tail rotor blade, resulting in a subsequent failure of the tail rotor drive system. Factors in this accident were an…Dec 28, 1993 · N7456T · DestroyedNTSB ATL94LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCThe pilot's inadequate in-flight planning in determining fuel requirements for the flight.Dec 27, 1993 · N4320X · Substantial damageNTSB ATL94LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · N. Myrtle Beach, SCThe pilot's improper inflight decision in that he failed to refuel the aircraft prior to exhausting the fuel supply. A factor was the soft terrain at the forced landing site.Dec 27, 1993 · N2205Z · Substantial damageNTSB NYC94LA043Accident · No injuriesLimited investigationFinal reportBeech A-36-TC · Hillsboro, NHLoss of engine power for undetermined reasons.Dec 26, 1993 · N3736F · Substantial damageNTSB NYC94LA044Accident · No injuriesLimited investigationFinal reportMooney 20E · Linden, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel and resulted in the loss of engine power.Dec 24, 1993 · N31617 · Substantial damageNTSB FTW94LA053Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Giddings, TXThe pilot's failure to maintain main rotor RPM. The weather conditions and delayed application of carburetor were factors in the accident.Dec 24, 1993 · N2111U · Substantial damageNTSB FTW94FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Franktown, COWas the pilot's disregard of forecast icing conditions and delayed application of carburetor heat, resulting in structural and induction icing. Factors were the icing conditions and unsuitable terrain for a forced landing.Dec 22, 1993 · N4382P · DestroyedNTSB CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.Dec 22, 1993 · N8003P · DestroyedNTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.Dec 21, 1993 · N4791D · Substantial damageNTSB MIA94IA040Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Melbourne, FLWas inadequate quality control by the engine manufacturer which resulted in failure of the second stage low pressure turbine disk due to a machining anomaly and reduced fatigue strength due to sub standard heat treat processing.Dec 19, 1993 · N74JM · Minor damageNTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.Dec 19, 1993 · N55133 · Substantial damageNTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 18, 1993 · N96591 · Substantial damageNTSB LAX94LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Showlow, AZthe pilot's poorly planned approach, improper emergency procedures, and his failure to feather the propeller. The inoperative fuel selector valve was a factor in this accident.Dec 17, 1993 · N8769B · Substantial damageNTSB FTW94LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Westcliffe, COWas failure of the number two connecting rod bearing. A factor was unsuitable terrain for a forced landing.Dec 17, 1993 · N5065G · Substantial damageNTSB SEA94LA041Accident · No injuriesLimited investigationFinal reportCessna 150J · Tonasket, WAThe pilot's failure to attain a proper touchdown point. Factors include an inadequate preflight, fuel exhaustion, and an icy landing area.Dec 16, 1993 · N61215 · Substantial damageNTSB NYC94LA039Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Wilkes-Barre, PAwas the loss of engine oil for undetermined reasons and the subsequent engine failure, resulting in a forced landing and collision with trees.Dec 15, 1993 · N92GP · DestroyedNTSB NYC94FA038Accident · 2 fatalField investigationFinal reportBeech B36TC · Lost Creek, KYThe loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the lack of suitable terrain for a forced landing.Dec 13, 1993 · N36CK · DestroyedNTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.Dec 13, 1993 · N66CS · Substantial damageNTSB FTW94LA048Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · El Paso, TXThe pilot's inadvertent flight into clear air turbulence.Dec 12, 1993 · N3718X · Substantial damageNTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.Dec 12, 1993 · N757FH · Substantial damageNTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…Dec 11, 1993 · N2773R · Substantial damageNTSB CHI94LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · C0rnell, ILthe pilot-in-command's misjudgment of fuel supply. A factor was fuel exhaustion.Dec 11, 1993 · N6124P · Substantial damageNTSB ATL94FA030Accident · 3 fatalField investigationFinal reportBeech M35 · Chapel Hill, NCThe improper engine overhaul by maintenance personnel. A factor in the accident was the failure of the engine crankshaft.Dec 11, 1993 · N9864R · Destroyed