NTSB investigations, 1992
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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 year(c.\"eventDate\") = 1992 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.
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 year(c."eventDate") = 1992 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.NTSB LAX93LA043Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Camp Verde, AZThe pilots intentional maneuvering flight at a altitude inadequate to ensure terrain clearance.NTSB LAX93FA042Accident · 2 fatalField investigationFinal reportCessna TU-206F · Clearlake, CAThe exhaust valve failing due to a complete fracture which resulted in the total lose of engine power. Factors in this accident were: 1) the terrain not being suitable for a forced landing, and 2) low ambient light which hampered the pilot's ability to see…NTSB FTW93LA038Accident · Serious injuriesLimited investigationFinal reportChampion 7GCAA · Joshua, TXThe pilot's failure to maintain a proper descent rate during the approach and his inadequate visual lookout.NTSB DEN93LA010Accident · No injuriesLimited investigationFinal reportCessna 310Q · Englewood, COUndetermined.NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB MIA93LA017Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Wiggins, MSThe pilot in command's failure to maintain directional control on landing roll out, resulting in an on ground loss of control (ground loop) and subsequent nose over.NTSB LAX93LA041Accident · 1 fatalLimited investigationFinal reportLitchford Falcon XP · Palm Springs, CAThe pilot's inflight loss of control for reasons related to the improper installation and functioning of the rudder control system, and, the pilot's inadvertent entry into a stall spin.NTSB LAX93LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Williams, AZThe partial loss of engine power due to a stuck exhaust valve on the number two cylinder and the pilot's inability to climb the aircraft above the trees surrounding the airport. A factor in the accident was the effects of the high density altitude on the…NTSB DEN93LA011Accident · No injuriesLimited investigationFinal reportBeech 1900C · Denver, COThe ramp agent misjudging the clearance between the airplane and gpu. A factor was: unavailability of proper ground assistance.NTSB CHI93LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Makoti, NDThe pilot not maintaining a proper glidepath during his approach to landing.NTSB BFO93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Griswold, CTThe pilot's improper planning or decision, by not either using all available runway or making a go around. The wet grass condition of the airstrip was a related factor.NTSB BFO93FA005Accident · 3 fatalField investigationFinal reportCessna 177B · War, WVVFR flight by the pilot into instrument meteorological conditions, his failure to maintain control of the airplane due to spatial disorientation, and the pilot allowing the design stress limits of the aircraft to be exceeded. Factors related to the accident…NTSB MIA93LA018Accident · No injuriesLimited investigationFinal reportCessna 172L · Okeechobee, FLThe pilot-in-command's improper flare.NTSB LAX93LA039Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG400 · Calistoga, CAThe failure of the brakes due to a separation of the brake cable for undetermined reasons. A factor in the accident was the tailwind condition during the landing rollout.NTSB LAX93LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Mariposa, CAThe pilot's failure to maintain a sufficient airspeed margin while on final approach, and, after encountering a down draft, his failure to correct the resulting descent rate and maintain a glide path which would maintain obstacle clearance.NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.NTSB LAX93LA037Accident · 1 fatalLimited investigationFinal reportCessna TU206G · Ruby, AZFuel exhaustion due to inaccurate preflight planning.NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB FTW93LA037Accident · Serious injuriesLimited investigationFinal reportColgate, Henry A. FS21000 · Albuquerque, NMThe loss of engine power for undetermined reasons. Factors were the low altitude and unsuitable terrain.NTSB CHI93LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Marshall, ILAn inadequate preflight inspection of the airplane by the pilot.NTSB CHI93IA035Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71 · Chicago, ILAn improper repair of the retract pin boss area by the overhaul facility.NTSB CHI93FA029Accident · 2 fatalField investigationFinal reportCessna 150L · Elwood, ILThe pilot-in-command's failure to maintain a proper adequate altitude to avoid obstructions. Factors contributing to the accident was the pilot's impairment of efficiency and judgement due to alcohol, and the dark night condition.NTSB BFO93LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Red Hook, NYThe pilot's inadvertent deactivation of the electric fuel boost pump. A factor related to the accident was the failure of the engine driven fuel pump during takeoff.NTSB ATL93LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAThe inadequate procedures and training of ground personnel involved in the aircraft push back operations by company management.NTSB CHI93LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNThe pilot's failure to select a proper fuel selector position.NTSB ANC93GA020Accident · 2 fatalFinal reportPiper PA-18-150 · Beaver, AKThe pilot-in-command's failure to maintain airspeed which resulted in an inadvertent stall at an altitude inadequate to affect a recovery. Factors which contributed to the accident were: the overweight airplane, and the snow covered mountainous terrain.NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB SEA93LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Olympia, WAThe pilot's poor inflight decision, and excessive airspeed on final. Factors include a wet turf runway, and trees adjacent to the runway.NTSB FTW93LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Jayton, TXThe pilot failed to maintain flying speed while maneuvering for landing and allowed the a/c to stall. Factors were the low ceilings, the pilots disregard of the forecast weather, the carburetor icing conditions, and the pilots delayed application of…NTSB BFO93LA006Accident · No injuriesLimited investigationFinal reportCessna 182 · Suffolk, VAFailure of the pilots in the Cessna 182 to visually identify and avoid the Cessna 150 (inadequate visual lookout). A factor related to the accident was: use of a nonstandard entry into the traffic pattern by the Cessna 182 flight crew.NTSB ANC93LA014Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Ekwok, AKThe pilot failed to maintain airspeed and inadvertently stalled the airplane. Contributing to the accident were the pilots improper in flight planning/decision, her intentional flight into known adverse weather, and the fog and icing conditions.NTSB SEA93FA020Accident · 1 fatalField investigationFinal reportCessna T210R · Boise, IDProper altitude was not maintained. Factors to the accident were: fog, dark night conditions, and improper IFR procedures.NTSB MIA93LA016Accident · No injuriesLimited investigationFinal reportCessna 172N · Ormond Beach, FLA fire of an undetermined source which erupted in the left cabin area during takeoff.NTSB ANC93LA015Accident · No injuriesLimited investigationFinal reportBell 206B III · Elf Point Camp, AKThe pilot misjudged clearance and dragged an external load longline cable while landing.NTSB LAX93LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Hawthorne, CAThe pilot's improper use of the brakes. Contributing to this accident was the worn brake pedals.NTSB FTW93FA033Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Dublin, TXImproper IFR operation by the pilot by descending under instrument meteorological conditions below the minimum altitude and the pilot's failure to maintain control of the airplane while maneuvering for a landing. Factors which contributed to the accident…NTSB LAX93LA034Accident · No injuriesLimited investigationFinal reportCessna 195 · El Cajon, CAThe pilot's improper use of the brakes.NTSB LAX93FA033Accident · No injuriesField investigationFinal reportSabreliner N-265-60 · Phoenix, AZThe delay of the PIC to apply normal braking and his failure to execute the appropriate emergency procedures. Contributing to this accident was an undetermined antiskid malfunction; the copilot's inexperience in the aircraft; and inadequate crew coordination.NTSB FTW93LA036Accident · No injuriesLimited investigationFinal reportCessna 210B · Mountain View, ARThe collapsed right main gear due to the gear locking mechanism not being engaged. A factor was the failed crankshaft.NTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB CHI93LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aurora, MOThe pilot's lack of familiarity with the airplane, a switched off fuel selector and fuel starvation.NTSB BFO93LA004Accident · No injuriesLimited investigationFinal reportCessna 402 · Brookville, OHThe presence of animals on the runway, causing the pilot to execute an aborted takeoff and overrun the runway in an attempt to avoid the animals. Factors related to the accident were low lighting conditions and wet grass.NTSB BFO93FA003Accident · 1 fatalField investigationFinal reportCessna 310R · Summersville, WVThe pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.NTSB ATL93LA023Accident · 1 fatalLimited investigationFinal reportBede BD-5B · Guntersville, ALThe pilot's inadvertent stall of the airplane, during the base to final turn, at too low an altitude to effect recovery. Factors were the improper lift off, which resulted in the airplane re contacting the runway after lift off, and served to distract the…NTSB ANC93FA013Accident · 3 fatalField investigationFinal reportCessna 402C · Kiana, AKThe pilot in command's attempt to fly VFR into IMC conditions. Factors were snow, whiteout conditions, and mountainous terrain.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB LAX93LA032Accident · 1 fatalLimited investigationFinal reportR.W. Sherman Turbulent · Adelanto, CAThe pilot's improper emergency decision to attempt to return to the departure area. Contributing to this accident was the undetermined loss of power, inadequate altitude, and failure to maintain the airspeed.NTSB LAX93LA031Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIThe flight's encounter with unforecasted unfavorable winds (loss of thermal lift) and downdrafts while on final approach to the runway.NTSB FTW93LA034Accident · No injuriesLimited investigationFinal reportTodd Goudeau KR-2 · San Marcos, TXPower loss due to carburetor icing. Factors were the unsuitable landing area and no carburetor deice system installed on the powerplant.