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 ATL92LA063Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mt. Pleasant, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.Mar 15, 1992 · N174OD · Substantial damageNTSB CHI92LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Munising, MIThe inadequate maintenance inspection to remove water from the fuel system, and the pilot's inadequate preflight inspection.Mar 14, 1992 · N96381 · Substantial damageNTSB CHI92LA111Accident · No injuriesLimited investigationFinal reportCessna 177B · Olney, ILThe pilot's failure to select carburetor heat in a timely manner, and the total loss of engine power due to carburetor ice. Related factors are carburetor icing conditions, reduced visibilities in snow, low ceilings, the dark night, and soft terrain…Mar 14, 1992 · N1271C · Substantial damageNTSB BFO92FA038Accident · 2 fatalField investigationFinal reportCessna 182A · Norfolk, VAThe loss of engine power for undetermined reasons.Mar 14, 1992 · N5119D · DestroyedNTSB BFO92LA036Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S2B · Schellsburg, PAThe total blockage of the oil breather line causing excessive pressure in the engine, resulting in oil leakage and subsequent engine failure.Mar 13, 1992 · N53385 · DestroyedNTSB BFO92LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Lynchburg, VAThe pilot's poor in-flight decision making resulting in fuel exhaustion. Contributing to the accident was the pilot's overall lack of experience.Mar 12, 1992 · N5258Q · Substantial damageNTSB NYC92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falmouth, KYThe failure of the pilot to adequately monitor his fuel consumption which resulted in a power loss from fuel exhaustion over unsuitable terrain. A factor related to the accident was the failure of the pilot to adequately determine the amount of fuel onboard…Mar 10, 1992 · N2460C · Substantial damageNTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.Mar 9, 1992 · N9828 · Substantial damageNTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.Mar 8, 1992 · N6938X · Substantial damageNTSB CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…Mar 8, 1992 · N242CF · Substantial damageNTSB SEA92LA055Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Oxbow, ORFailure of the pilot to maintain a proper visual lookout. A factor in the accident was the pilot's poor judgement in operating at low altitude along the river.Mar 7, 1992 · N2645W · DestroyedNTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.Mar 7, 1992 · N4942X · Substantial damageNTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.Mar 7, 1992 · N94063 · Substantial damageNTSB DEN92LA041Accident · Minor injuriesLimited investigationFinal reportEnstrom F28 · Lakewood, COThe premature use of collective by the pilot during an autorotation. Factors were: the disconnection and subsequent collapse of the induction air line.Mar 7, 1992 · N95NR · Substantial damageNTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.Mar 7, 1992 · N27613 · Substantial damageNTSB LAX92FA136Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Ft. Grant, AZ1) The pilot inadequately evaluating the enroute weather conditions, and, 2) the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see the mountainous terrain…Mar 5, 1992 · N350AH · DestroyedNTSB LAX92FA137Accident · 1 fatalField investigationFinal reportRobinson R22 · Maricopa, AZDestructive mast bumping for an undetermined reason(s).Mar 4, 1992 · N8413Q · DestroyedNTSB LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…Mar 4, 1992 · N7933E · DestroyedNTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.Mar 3, 1992 · N2862Q · Substantial damageNTSB LAX92AMS03Accident · 2 fatalFinal reportCessna 172D · Pacific Ocean (Pacific Ocean)The failure of the pilot to adequately evaluate the weather conditions, and continued VFR flight into IMC conditions which resulted in the pilot becoming lost and disoriented. Contributing to the accident was the lack of total aeronautical experience and fuel…Mar 1, 1992 · N2425U · DestroyedNTSB ATL92LA052Accident · No injuriesLimited investigationFinal reportMooney M20C · Charleston, SCThe blocked fuel vent.Mar 1, 1992 · N6748U · Substantial damageNTSB FTW92LA076Accident · Minor injuriesLimited investigationFinal reportAvions Fairey T-66 · Mineral Wells, TXFuel starvation due to a contaminated fuel filter. A factor was the soft terrain.Feb 29, 1992 · N621X · Substantial damageNTSB FTW92FA077Accident · 1 fatalField investigationFinal reportBell 212 · Morgan City, LAThe inflight separation of the main rotor system as results of the main rotor static stop contacting the mast for undetermined reasons.Feb 29, 1992 · N92AL · DestroyedNTSB DEN92LA036Accident · No injuriesLimited investigationFinal reportEnstrom TH-28 · Leadville, COThe pilot misjudging the descent rate and consequently delaying the flare. A factor was: downdraft.Feb 29, 1992 · N8631E · Substantial damageNTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.Feb 28, 1992 · N20044 · Substantial damageNTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.Feb 28, 1992 · N2387G · Substantial damageNTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.Feb 28, 1992 · N6312H · Substantial damageNTSB SEA92LA052Accident · No injuriesLimited investigationFinal reportCessna 150L · Mulino, ORCarburetor ice and improper use of the carburetor heat. Factors to the accident were: carburetor icing conditions and an inadequate weather evaluation.Feb 27, 1992 · N11568 · Substantial damageNTSB LAX92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodland, CAThe company maintenance personnel's inadequate 100-hour inspection and failure to replace the oil line. Contributing to the accident was the rupture of the oil line and the ditch that traversed the emergency landing area.Feb 26, 1992 · N595SP · Substantial damageNTSB LAX92GA128Accident · 2 fatalFinal reportCessna T210N · Lake Hughes, CAPoor maintenance repair and annual inspection by the company's maintenance personnel and the pilot-in-command's misjudging altitude. Contributing to this accident was the pilot-in-command intentional stall, improper emergency procedure, selection of…Feb 26, 1992 · N9YT · DestroyedNTSB LAX92LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Apple Valley, CAThe pilot's failure to maintain airspeed and inadvertent stall. Contributing to this accident was engine fuel exhaustion for undetermined reasons.Feb 25, 1992 · N4193Y · DestroyedNTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.Feb 23, 1992 · N1852Z · Substantial damageNTSB CHI92FA095Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Burlington, ILThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions in cruise flight. Related factors are the pilot's inadequate weather evaluation, the low ceiling and reduced visibility (fog).Feb 23, 1992 · N5309W · DestroyedNTSB ANC92FA040Accident · 6 fatalField investigationFinal reportBell 214B-1 · Hobart Bay, AKSeparation of the tail rotor and 90 degree gearbox due to the pilot's failure to follow procedures/directives which resulted in the external load cable becoming entangled in the tail rotor. Factors were the turbulent weather and the lack of suitable terrain…Feb 23, 1992 · N814RM · DestroyedNTSB LAX92LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Ludlow, CAThe failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.Feb 22, 1992 · N9343C · Substantial damageNTSB MIA92LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilots in command of both aircraft failure to maintain vigilance and see and avoid each other resulting in a midair collision. Contributing to the accident was the local controllers failure to issue traffic advisories.Feb 21, 1992 · N738YY · 2 aircraft · Substantial damageNTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.Feb 21, 1992 · N732TR · Substantial damageNTSB FTW92LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Conroe, TXThe pilot's inadequate preflight which resulted in water in the fuel system. A factor was the night lighting condition.Feb 17, 1992 · N738EC · Substantial damageNTSB ATL92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe pilot's inadequate preflight planning and his failure to refuel at his last departure point, which resulted in fuel exhaustion and engine stoppage.Feb 17, 1992 · N24211 · Substantial damageNTSB FTW92LA070Accident · No injuriesLimited investigationFinal reportBell 206L-3 · South Pelto #1The pilot's inability to control the helicopter due to spatial disorientation. Factors were the fog and the pilot's failure to receive a weather briefing prior to the flight.Feb 15, 1992 · N3120X · DestroyedNTSB DEN92FA035Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Glenwood Spring, COMalfunction of the right engine fuel control that caused the engine to flame out, and delamination of the left engine compressor shroud. Factors were: the pilot became disoriented, the mountainous terrain, the dark night, and the weather conditions.Feb 14, 1992 · N26JB · DestroyedNTSB DEN92FA034Accident · 2 fatalField investigationFinal reportBell 206L-3 · Fort Collins, COFailure of the number 2-1/2 bearing due to an obstruction of a bearing oil feed tube by foreign material. Factors related to the accident were: improper maintenance during engine overhaul, and weather/terrain/water conditions in the emergency landing area.Feb 12, 1992 · N99TV · Substantial damageNTSB FTW92FA068Accident · 2 fatalField investigationFinal reportCessna 210G · Darrouzett, TXThe pilot's failure to maintain aircraft control for undetermined reasons. A factor was the dark night.Feb 11, 1992 · N5896F · DestroyedNTSB NYC92LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · New York, NYA power loss of undetermined origin over unsuitable terrain.Feb 9, 1992 · N9147J · Substantial damageNTSB SEA92LA044Accident · 2 fatalLimited investigationFinal reportLockheed P2V-7 · Dixon, WYThe pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…Feb 8, 1992 · N70600 · DestroyedNTSB MIA92LA080Accident · No injuriesLimited investigationFinal reportCessna 150M · Stuart, FLLoss of engine power due to undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Feb 8, 1992 · N9286U · Substantial damageNTSB NYC92FA055Accident · 1 fatalField investigationFinal reportAero Commander 500S · Richmond Hts., OHThe pilot's improper emergency procedures and failure to maintain control of the airplane, which resulted in an inadvertent spin at too low an altitude to allow recovery. Factors in this accident were; a power loss in the left engine as result of the exhaust…Feb 7, 1992 · N725AC · DestroyedNTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…Feb 6, 1992 · N4370B · DestroyedNTSB MIA92LA097Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Church Hill, MSThe pilot's failure to clear his engine during descent resulting in the spark plugs becoming fouled which resulted in loss of engine power.Feb 6, 1992 · N88380 · Substantial damageNTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.Feb 6, 1992 · N65566 · Substantial damage