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 LAX92MA184Accident · 9 fatalClass 1 · MajorFinal reportBeech E18S · Mount Haleakala, HIThe captain's decision to continue visual flight into instrument meteorological conditions that obscured rising mountainous terrain and his failure to properly use available navigational information to remain clear of the island of maui. Contributing to the…Apr 23, 1992 · N342E · DestroyedNTSB CHI92LA131Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Branson, MOInadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.Apr 23, 1992 · N59ND · 2 aircraft · Substantial damageNTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.Apr 22, 1992 · N7252X · Substantial damageNTSB MIA92FA112Accident · 1 fatalField investigationFinal reportNavion NAV-A · Monteverde, FLThe pilot's inadvertent flight into IMC conditions and subsequent loss of control of the airplane in flight.Apr 22, 1992 · N4904E · DestroyedNTSB NYC92DNC02Accident · 1 fatalFinal reportCraig Morehead Bushby Mustang II · Buxton, METhe failure of the pilot to maintain airspeed while maneuvering which resulted in an inadvertent stall with insufficent altitude for recovery. Factors related to the accident were the low clouds and fog, and the pilot's failure to obtain a weather briefing.Apr 20, 1992 · N519CS · DestroyedNTSB LAX92LA180Accident · No injuriesLimited investigationFinal reportCessna 150 · Mesquite, NVThe pilot's poor preflight planning and improper fuel consumption calculations. Factors relating to this accident were fuel exhaustion, and the unsuitable terrain, and lack of understanding of the airplane's fuel system.Apr 19, 1992 · N6582G · Substantial damageNTSB LAX92LA179Accident · No injuriesLimited investigationFinal reportHomebuilt Dragonfly · Parker, AZAn oil leak from an unidentified source. The high vegetation along the forced landing area contributed to this accident.Apr 19, 1992 · N235JS · DestroyedNTSB NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.Apr 18, 1992 · N172DG · DestroyedNTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.Apr 18, 1992 · N46034 · Substantial damageNTSB SEA92LA081Accident · No injuriesLimited investigationFinal reportPiper J-5A · Broadus, MTFuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.Apr 17, 1992 · N35931 · Substantial damageNTSB FTW92LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Acton, TXThe excessive airspeed during the landing. Factors were the carburetor icing conditions, the carburetor ice induced power loss, and the pilot's delayed use of carburetor heat.Apr 17, 1992 · N2430K · Substantial damageNTSB LAX92LA178Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Galt, CAThe pilot's poor in-flight decision by selecting an improper cruise altitude. Contributing to this accident was the pilot's fatigue due to lack of sleep.Apr 16, 1992 · N6213S · DestroyedNTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.Apr 16, 1992 · N2901E · Substantial damageNTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…Apr 13, 1992 · N2968R · DestroyedNTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…Apr 12, 1992 · N16540 · DestroyedNTSB LAX92FA174Accident · 5 fatalField investigationFinal reportCessna P210N · Baxter, CA1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…Apr 12, 1992 · N9TG · DestroyedNTSB DEN92IA046Incident · No injuriesIncident investigationFinal reportCessna 310-L · Hugo, COFailure of the left voltage regulator. Factors were: failure of the pilot/mechanic to properly maintain the aircraft, and failure of the right alternator circuit breaker.Apr 12, 1992 · N331BX · No damageNTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.Apr 12, 1992 · N7248J · DestroyedNTSB ATL92IA078Incident · No injuriesIncident investigationFinal reportMaule M-5-210 · Atlanta, GAThe failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.Apr 11, 1992 · N51590 · Minor damageNTSB SEA92LA072Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Missoula, MTPartial blockage of the left engine induction air filter, inability to maintain the proper rate of descent, and delayed extension of the landing gear. Factors contributing to the accident were icing conditions, wing ice, and rough/uneven terrain.Apr 10, 1992 · N3494P · Substantial damageNTSB LAX92LA176Accident · No injuriesLimited investigationFinal reportMcewen Dick Glasair III · Casa Grande, AZA failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…Apr 10, 1992 · N115DM · Substantial damageNTSB FTW92GA111Accident · 1 fatalFinal reportPiper PA-32R-301T · Albuquerque, NMFuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.Apr 9, 1992 · N8194X · Substantial damageNTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.Apr 9, 1992 · N6610L · DestroyedNTSB LAX92LA170Accident · No injuriesLimited investigationFinal reportCessna 182 · Delano, CAA loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to land the airplane and the soft soil condition which caused the airplane to nose over.Apr 8, 1992 · N5195D · Substantial damageNTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.Apr 6, 1992 · N70321 · Substantial damageNTSB ATL92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Elizabeth City, NCInadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the soft terrain at the forced landing site.Apr 6, 1992 · N23380 · Substantial damageNTSB SEA92LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Scappoose, ORThe loss of engine power, cause undetermined. A factor relating to the accident was the lack of suitable terrain for a forced landing.Apr 5, 1992 · N52638 · DestroyedNTSB LAX92LA165Accident · No injuriesLimited investigationFinal reportRobinson R22B · Palm Springs, CAThe pilot's failure to maintain a proper cruise altitude upon entering a mountain pass area, and his failure to maintain control of the helicopter. Factors which contributed to the pilot's loss of control were related to his encountering turbulence and…Apr 5, 1992 · N40433 · Substantial damageNTSB LAX92LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Yucca Valley, CAWas the loss of engine power for undetermined reasons. A factor in the accident was the mountainous and rough nature of the terrain.Apr 3, 1992 · N24977 · DestroyedNTSB ATL92LA073Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, SCThe improper installation of the engine counterweight retention rings which resulted in the separation of the retention pin, allowing the leading edge of the counterweight to strike the crankcase. Factors in the accident were the subseqent loss of power and…Apr 3, 1992 · N7320E · Substantial damageNTSB MIA92LA102Accident · Minor injuriesLimited investigationFinal reportBell 47-D-1 · Fayette, MSThe pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.Apr 2, 1992 · N322A · Substantial damageNTSB FTW92LA102Accident · No injuriesLimited investigationFinal reportR. W. Switzer RV-4 · Rogers, ARLoss of engine due to fuel starvation and unsuitable terrain. Factors were the pilot's failure to follow published procedures.Apr 2, 1992 · N94BS · Substantial damageNTSB SEA92LA066Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Soldier Summit, UTThe fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.Apr 1, 1992 · N582MK · Substantial damageNTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.Apr 1, 1992 · N1230D · DestroyedNTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…Apr 1, 1992 · N3884R · DestroyedNTSB ANC92LA056Accident · 2 fatalLimited investigationFinal reportCessna 150 · Kalskag, AKThe pilot's failure to maintain control of the airplane as a result of his physical impairment due to alcohol. A factor was the dark night.Apr 1, 1992 · N11140 · Substantial damageNTSB DEN92FA045Accident · 1 fatalField investigationFinal reportCessna T210N · Larkspur, COThe pilot's failure to flare the airplane due to his reduced forward visibility. Factors were: the pilot's improper fuel consumption calculations, his failure to proceed to an alternate airport, fuel exhaustion, and weather conditions including snow, fog, and…Mar 31, 1992 · N212CS · DestroyedNTSB LAX92FA156Accident · 3 fatalField investigationFinal reportBeech B95 · Devore, CAThe pilot's failure to maintain an adequate altitude while flying over mountainous terrain. Factors related to the accident were: the low clouds, dark night, and mountainous terrain.Mar 29, 1992 · N9652R · DestroyedNTSB ATL92LA072Accident · No injuriesLimited investigationFinal reportCessna U206G · Lafayette, TNThe pilot's inadequate preflight inspections which resulted in oil starvation and eventual failure of the engine. A factor was the rough terrain where the airplane was force landed.Mar 29, 1992 · N9679G · Substantial damageNTSB ANC92LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kenai, AKTerrain clearance was not maintained. Factors to the accident were: snow covered hilly terrain, and diverted attention.Mar 29, 1992 · N82757 · Substantial damageNTSB LAX92LA252Accident · No injuriesLimited investigationFinal reportBeech B-35 · Newhall, CAImproper ruddervator balancing that resulted in ruddervator flutter. Contributing to the accident was insufficient maintenance information to assure that AD compliance and elevator balancing was performed, and an inadequate annual inspection procedure that…Mar 28, 1992 · N8838A · Substantial damageNTSB CHI92LA118Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Joliet, ILThe pilot-in-command's failure to follow emergency procedures, and the failure of the electrical system. Factors contributing to the accident were electrical arcing, and the lack of total experience in the type of aircraft by the pilot-in-command.Mar 28, 1992 · N4822R · DestroyedNTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.Mar 27, 1992 · N4335N · DestroyedNTSB MIA92LA101Accident · Serious injuriesLimited investigationFinal reportMaya, Jaime Rans S-12 · Cabo Rojo, PRFailure of the non FAA certificated pilot to maintain airspeed and the inadvertent stall during an attempted precautionary landing following partial loss of engine power due to undetermined reasons.Mar 22, 1992 · UNREG · Substantial damageNTSB CHI92LA117Accident · No injuriesLimited investigationFinal reportBeech F33A · Langdon, NDFailure of the pilot to fully extend the landing gear using manual procedures after an electrical system failure. A factor associated with the accident is the pilot misreading a published emergency procedure.Mar 21, 1992 · N2046W · Substantial damageNTSB ATL92LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Hull, GAThe pilot's inadequate preflight and inflight planning, which resulted in fuel exhaustion, and his failure to obtain a proper touchdown point, which resulted in a long landing and collision with terrain.Mar 18, 1992 · N111TY · Substantial damageNTSB SEA92LA062Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Elbe, WAFuel starvation, improper fuel, improper aircraft servicing (fueling), and clearance not possible. Factors contributing to the accident were: no suitable terrain, low ceilings, dusk and trees.Mar 16, 1992 · N4021K · DestroyedNTSB MIA92LA098Accident · No injuriesLimited investigationFinal reportMooney M20K · St. Augustine, FLThe separation of the swage between the throttle outer housing and throttle cable resulting in loss of throttle control and the engine reducing to idle power.Mar 16, 1992 · N231KF · Substantial damageNTSB LAX92LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Yucapia, CAThe partial loss of power most likely related to the poor quality of aircraft maintenance. A factor in the accident was the lack of suitable terrain for a forced landing.Mar 16, 1992 · N5417T · Substantial damageNTSB LAX92FA141Accident · 2 fatalField investigationFinal reportMooney M20C · Redding, CAA loss of engine power due to carburetor and air filter icing, and, the pilots decision to attempt flight into known adverse weather/icing conditions.Mar 16, 1992 · N7850V · Destroyed