NTSB investigations, 1992
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW93RA063Accident · No injuriesForeign investigationRockwell Sabreliner 75A · Quito, EcuadorNTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.NTSB NYC93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cheriton, VAThe pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.NTSB FTW93LA049Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Little Rock, ARThe collapsing of the main landing gear as result of a worn gear locking mechanism. A factor was the crosswind.NTSB BFO93FA016Accident · 1 fatalField investigationFinal reportBeech C-45G · Elkridge, MDFailure of the pilot to properly secure the cargo, which allowed a shift in the center of gravity during a missed approach maneuver and resulted in subsequent loss of aircraft control and flying speed. A factor related to the accident was failure of the pilot…NTSB SEA93FA033Accident · 1 fatalField investigationFinal reportBeech 35-33 · Riverton, UTTerrain clearance was not maintained. Factors to the accident were: snow and flight into known adverse weather.NTSB FTW93IA048Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120RT · Houston, TXThe assigned mechanic's failure to reinstall the attachment screws and the quality inspector's inadequate inspection of the completed work. A factor was the complacency of the maintenance personnel.NTSB DEN93FA015Accident · No injuriesField investigationFinal reportDouglas DC-8-52 · Denver, COAn encounter with severe clear air turbulence.NTSB NYC93LA040Accident · 1 fatalLimited investigationFinal reportBoeing 737-300LR · Flushing, NYA lack of adequate clearance between the walker and tug which resulted in the walker being struck by the tug when he fell for unknown reason(s). A factor related to the accident was the lack of a policy to stay clear of the tug, towbar, and nosewheel of the…NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB MIA93LA027Accident · Minor injuriesLimited investigationFinal reportBell 47-G5A · Belle Glade, FLThe improper in flight decision of the pilot in command to attempt an agricultural turn with insufficient altitude to accomplish the maneuver. Contributing to the accident was the pilot's overconfidence in his abilities.NTSB LAX93LA063Accident · No injuriesLimited investigationFinal reportHughes 269B · Kahului, HIFailure of the pilot to maintain adequate rotor RPM during downwind flight and adequate altitude to recover the loss of main rotor RPM before settling into the water. Contributing to the accident was the pilot's lack of rotorcraft flight experience.NTSB CHI93FA050Accident · 1 fatalField investigationFinal reportCessna 177B · Kansas City, MOThe pilot-in-command's failure to maintain a positive rate of climb during a missed approach. Factors which contributed to the accident were: inoperative gyro instruments due to a broken vacuum pump, the dark night, adverse weather conditions, and rising…NTSB SEA93FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Marysville, WAThe design stress limits of the airframe were exceeded by the student pilot.NTSB NYC93LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Alberta, VAThe pilot attempted to take off on rough uneven terrain and could not attain rotation speed, which resulted in the airplane striking a tree during the ground run. A factor in this accident was inadequate pre flight planning.NTSB NYC93LA038Accident · 1 fatalLimited investigationFinal reportHelio H-700 · Shelton, CTThe pilot's failure to check the position of the landing gear before attempting a water landing.NTSB NYC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Williamson, NYThe pilot failed to provide adequate compensation for the wind conditions. A factor in this accident was the high gusting winds.NTSB NYC93LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-301T · Jaffrey, NHAn improper weld by other maintenance personnel which resulted in the nose gear collapsing, and a loss of directional control on takeoff.NTSB LAX93FAMS2Accident · 4 fatalMissing aircraftFinal reportPiper PA-28-181 · Missing Acft, CAUndetermined.NTSB CHI93LA049Accident · No injuriesLimited investigationFinal reportCessna 150F · Oshtemo, MIImproper use of carburetor heat by the pilot-in-command.NTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.NTSB MIA93LA026Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Groveland, FLThe pilot's encounter with shifting winds on the takeoff roll, that caused the airplane to overrun the runway. Contributing to the accident was the failure of the pilot in command to perform an aborted takeoff.NTSB LAX93LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Auburn, CAFailure of the pilot to maintain direction control during the landing touchdown. Contributing to the accident inadequate maintenance of the runway safety area by airport personnel.NTSB CHI93LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Shell Knob, MOThe pilot's misjudging of the landing flare.NTSB ATL93FA031Accident · 6 fatalField investigationFinal reportBeech 95-B55B · Calera, ALThe pilot's continued flight with the fuel tank selector handles improperly positioned, which resulted in fuel starvation and engine stoppage. Factors were the cloudy weather conditions, the night lighting conditions, and the steep, hilly terrain conditions…NTSB LAX93LA062Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Kamuela, HIThe inadequate 100-hour inspection performed by company maintenance personnel. Factors contributing to this accident are the fuel control exceeding the manufacturers' service limits; the inoperative fuel filter; the overtemperature of the gas generator…NTSB LAX93LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Novato, CAFailed to maintain directional control and an inadequate visual lookout. Contributing to this accident were the inoperative runway lights.NTSB ANC93LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Scammon Bay, AKThe pilots VFR flight into IMC conditions, and his failure to maintain sufficient altitude while maneuvering. Contributing to the accident were the whiteout snow and fog conditions.NTSB ANC93LA018Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Anchorage, AKThe failure of the pilot in command to maintain directional control of his airplane. A factor in the accident was the pilot in commands improper taxi speed.NTSB LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.NTSB LAX93LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Fresno, CAThe pilot's inadequate preflight. Contributing to this accident was the separation of the fuel cap, tail rotor blade balance weight, tail rotor gear box, and the vertical fin.NTSB MIA93FA025Accident · 1 fatalField investigationFinal reportCessna 152 · Ocala, FLThe pilot-in-command becoming lost and disoriented and his failure to maintain altitude.NTSB LAX93LA057Accident · 2 fatalLimited investigationFinal reportHughes 369B · Fallbrook, CAThat the pilot misjudged the distance of the high tension wires from the helicopter.NTSB FTW93LA047Accident · No injuriesLimited investigationFinal reportHiller UH12B · Justin, TXFailure of the main rotor system for undetermined reasons. A factor was the lack of suitable terrain at the pilot's disposal.NTSB DEN93LA014Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Boulder, COUndetermined.NTSB CHI93GA046Accident · 2 fatalFinal reportSchweizer 269C · Kansas City, MOThe pilot-in-command's misjudging the distance during the autorotation.NTSB MIA93LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Aberdeen, NCThe improper in flight decision of the pilot in command to attempt a long landing, downwind on a short wet sod runway. Contributing to the accident was the failure of the pilot in command to execute a go around when observing the wind and landing conditions.NTSB FTW93T#A02Accident · No injuriesFinal reportHughes OH-6A (BP) · Marfa, TXNTSB CHI93LA045Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Milwaukee, WIThe pilot's failure to maintain a proper altitude.NTSB CHI93LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSThe pilot's improper use of rudder control and subsequent failure to maintain directional control.NTSB SEA93FA031Accident · 1 fatalField investigationFinal reportBeech S35 · Rexburg, IDThe pilot in command's failure to maintain clearance with objects/terrain. Factors contributing to the accident were low ceilings, snow, dark night conditions, trees, improper preflight planning and self induced pressure.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB ATL93FA030Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Pike Road, ALThe failure of the pilot in command to maintain airspeed during the initial climb, which resulted in an inadvertent stall and collision with the ground. Factors were the inadequate preflight planning and preparation of the pilot in command in that he operated…NTSB LAX93FA055Accident · 5 fatalField investigationFinal reportCessna T210M · Thornton, CAThe failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the failure of the sacramento controller to advise the stockton controller of the impending unsafe situation, and the failure of the stockton controller…NTSB BFO93LA015Accident · No injuriesLimited investigationFinal reportMooney M20K · Orange, VAWater contamination in the fuel, and inadequate preflight inspection.NTSB BFO93LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, NJInadequate supervision by the instructor, and his delay in initiating a go around.NTSB ATL93LA032Accident · No injuriesLimited investigationFinal reportVan Arsdell/Brent,M. Rutan Long EZ · Charleston, SCThe pilot's inadequate pre-flight planning and his failure to note the raised arresting device near the runway threshold.NTSB LAX93LA056Accident · 2 fatalLimited investigationFinal reportCessna 182K · Flagstaff, AZThe pilot's continued flight into instrument meteorological conditions and improper remedial action by descending into high terrain. Contributing to this accident were the prevailing cloud condition.NTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.NTSB FTW93LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Tryon, OKPower loss due to fuel starvation and the pilots improper selection of the off position on the fuel selector. A factor was the lack of suitable terrain for the forced landing.