NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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 FTW92LA026Accident · Serious injuriesLimited investigationFinal reportBell 47G3B2A · Texarkana, TXThe pilot's failure to maintain proper terrain clearance during takeoff. A factor was his lack of total experience in helicopters.Nov 24, 1991 · N8134J · Substantial damageNTSB CHI92LA034Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Brainerd, MNAn engine failure due to a seized fuel pump rotor shaft.Nov 24, 1991 · N9196N · Substantial damageNTSB SEA92LA023Accident · No injuriesLimited investigationFinal reportKitfox Ten Model 2 · West Jordan, UTThe loss of engine power when it overheated due to low coolant level, which resulted from the inadequate preflight inspection by the pilot. A factor relating to the accident was the obstruction in the landing area.Nov 23, 1991 · N66257 · Substantial damageNTSB MIA92LA038Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hilliard, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the low ceiling encountered and reduced in-flight planning decision time by the pilot-in-command.Nov 23, 1991 · N7304K · Substantial damageNTSB CHI92LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Marquette, MIFlight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.Nov 23, 1991 · N96147 · DestroyedNTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.Nov 22, 1991 · N2582J · 2 aircraft · DestroyedNTSB MIA92LA033Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Lantana, FLThe improper maintenance assembly and inspection of the throttle linkage which resulted in the throttle linkage becoming disconnected in flight and subsequent loss of engine power.Nov 22, 1991 · N9783U · Substantial damageNTSB LAX92LA050Accident · 1 fatalLimited investigationFinal reportSpeyer Avid Amphibian · San Ysidro, CAFailure of the pilot/builder to follow the manufacturer's recommended airframe modification procedure to prevent the inflight loss of a flaperon due to flutter. Contributing to the accident was in inflight separation of the wing when the design limits of the…Nov 22, 1991 · N118A · DestroyedNTSB LAX92LA049Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Gila Bend, AZThe animal on the runway. Contributing to this accident was separation of the right main landing gear due to overload and the dark night.Nov 22, 1991 · N91886 · Substantial damageNTSB CHI92LA031Accident · No injuriesLimited investigationFinal reportCessna 310R · South St Paul, MNThe inadequate design of the propeller hub assembly which resulted in metal fatigue and propeller blade separation during initial climbout.Nov 22, 1991 · N35H · Substantial damageNTSB CHI92FA032Accident · 3 fatalField investigationFinal reportBeech B100 · Romeo, MIThe pilot in command's improper inflight decision and the minimum descent altitude disregarded during an instrument approach.Nov 22, 1991 · N24169 · DestroyedNTSB NYC92IA035Incident · No injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Buffalo, NYA fatigue fracture on the propeller shaft, that originated at a subsurface slag inclusion, which remained in the material used to manufacture the shaft.Nov 21, 1991 · N146CA · Minor damageNTSB LAX92FA047Accident · 3 fatalField investigationFinal reportBell 206BIII · Davis, CAThe decision of the pilot to continue night low level flight in forecasted adverse weather conditions. Contributing to the accident was the foggy weather and dark night conditions which restricted the pilot's visual outlook.Nov 21, 1991 · N5011K · DestroyedNTSB NYC92LA034Accident · Minor injuriesLimited investigationFinal reportRyan 260-B · Barre, MAA total loss of engine power in cruise flight due to fuel starvation resulting in a forced landing and collapse of the landing gear during the landing roll. A factor related to the accident was a leaking fuel selector valve.Nov 20, 1991 · N5321K · Substantial damageNTSB FTW92FA025Accident · No injuriesField investigationFinal reportBeech B19 · Forth Worth, TXInadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…Nov 20, 1991 · N9343S · 2 aircraft · Substantial damageNTSB FTW92FA024Accident · 1 fatalField investigationFinal reportBeech V35TC · Jasper, TXThe pilot's failure to continue a normal climb after takeoff due to spatial disorientation. A factor was the dark night condition.Nov 20, 1991 · N3GE · DestroyedNTSB DEN92LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder, COFailure of the pilot to maintain clearance from the sign.Nov 20, 1991 · N80893 · Substantial damageNTSB CHI92IA030Incident · Minor injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILAn inflight encounter with wake turbulence during cruise flight.Nov 20, 1991 · N235RM · No damageNTSB ATL92IA025Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAA short in an electrical connector which resulted in its failure. The reason for the short was not determined. A factor was the improper installation of the connector by an unknown maintenance person.Nov 20, 1991 · N908DL · No damageNTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.Nov 19, 1991 · N9033T · Substantial damageNTSB LAX92LA046Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Fremont, CAThe pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.Nov 19, 1991 · N36243 · DestroyedNTSB SEA92LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ontario, ORCarburetor icing and the pilot's failure to use carburetor heat. A factor contributing to the accident was the transmission wires.Nov 18, 1991 · N9776C · Substantial damageNTSB MIA92WA032Accident · No injuriesForeign investigationBoeing 737-200 · San Jose, Costa RicaNov 18, 1991 · EICBL · Substantial damageNTSB FTW92FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Angleton, TXThe pilot's failure to maintain aircraft control. Factors were his lack of total instrument time, his VFR flight into instrument conditions and spatial disorientation.Nov 18, 1991 · N6637W · DestroyedNTSB DEN92LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greeley, COA partial loss of engine power on initial takeoff climb due to a bent and loose carburetor heat control mechanism.Nov 18, 1991 · N9811C · Substantial damageNTSB NYC92DNE01Accident · Serious injuriesFinal reportAdvanced Buccaneer SX B1B-503 · Palmer, MAA failed lower rudder attach pivot bolt which resulted in jammed flight controls and an uncontrolled descent into trees.Nov 17, 1991 · UNREG · Substantial damageNTSB MIA92LA031Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Mariner · Ocala, FLThe pilot-in-command's improper use of collective control and throttle during recovery from an autorotation which resulted in loss of rotor RPM and a subsequent hard landing.Nov 17, 1991 · N4072U · Substantial damageNTSB CHI92LA029Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Howell, MIProper glidepath was not maintained resulting in an undershoot. A factor related to the accident was dark night flying conditions.Nov 17, 1991 · N73475 · Substantial damageNTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…Nov 16, 1991 · N29517 · DestroyedNTSB NYC92LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenskill, NYThe pilot's improper use of carburator heat, resulting in carburator ice and a loss of engine power and subsequent forced landing on unsuitable terrain.Nov 16, 1991 · N50877 · Substantial damageNTSB NYC92LA031Accident · 2 fatalLimited investigationFinal reportMooney M20C · Painesville, OHThe pilot's failure to see and avoid the powerline tower structure while executing a visual approach to the airport. Factors related to the accident were the lack of proper radio equipment necessary to execute the instrument approach, restricted visibility…Nov 16, 1991 · N9637M · DestroyedNTSB FTW92FA022Accident · 2 fatalField investigationFinal reportCessna 310C · Waller, TXThe loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.Nov 16, 1991 · N6704T · DestroyedNTSB BFO92LA007Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Spanishburg, WVThe pilot's intentional flight into instrument meteorological conditions. Contributing to the accident was the low ceiling in conjunction with the mountainous terrain and the pilot's over confidence.Nov 16, 1991 · N97684 · DestroyedNTSB ATL92FA024Accident · 1 fatalField investigationFinal reportCessna 208B · Destin, FLThe pilots failure to follow instrument flight rules procedures by disregarding the minimum descent altitude for the approach and failing to maintain clearance from the terrain. A factor in the accident was the pilot's over confidence in his personal ability.Nov 16, 1991 · N951FE · Substantial damageNTSB NYC92LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-36 · Erwinna, PAThe pilot rotated the glider prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were the pilot's total lack of experience in gliders, no experience in this type of glider, and improper trim…Nov 15, 1991 · N3617C · Substantial damageNTSB MIA92WA030Accident · No injuriesForeign investigationCessna 172H · Virgin Gorda, British Virgin IslandsNov 15, 1991 · N2824L · Substantial damageNTSB MIA92LA029Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Florida City, FLPartial loss of engine power due to a loose intake manifold. Also, improper maintenance by an unknown person.Nov 15, 1991 · N4506K · Substantial damageNTSB LAX92FA283Accident · 5 fatalField investigationFinal reportCessna 336A · Big Bear City, CA1) The pilot inadequately evaluating the weather, and 2) the pilot making the inflight decision to continue flight into adverse weather conditions. Factors in this accident were 1) the inability of the pilot to see the mountainous terrain due to the ambient…Nov 15, 1991 · N3848U · DestroyedNTSB CHI92FA028Accident · 1 fatalField investigationFinal reportPiper PA28-236 · Valley Center, KSThe pilot's spatial disorientation, his loss of aircraft control, and his exceeding the aircraft's design limits. Factors in the accident were the pilot's disregard for directives and procedures, and his continued flight into known adverse weather.Nov 15, 1991 · N412GK · DestroyedNTSB BFO92LA009Accident · No injuriesLimited investigationFinal reportCessna 150 · Portsmouth, VAThe pilot's improper flare attitude during the landing flare/touchdown and his failure to initiate recovery from a bounced landing.Nov 15, 1991 · N3072V · Substantial damageNTSB BFO92LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Portsmouth, VACollisiion with the deer on the runway. A factor was the dark night.Nov 15, 1991 · N19595 · Substantial damageNTSB SEA92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe loss of control on takeoff by the pilot due to the improper flap setting, the premature liftoff and his failure to attain proper climb airspeed after takeoff.Nov 14, 1991 · N68267 · DestroyedNTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.Nov 14, 1991 · N6072P · Substantial damageNTSB MIA92LA028Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Groveland, FLPoor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.Nov 14, 1991 · N2890H · Substantial damageNTSB MIA92LA027Accident · 1 fatalLimited investigationFinal reportBeech BE-35 · St. Petersburg, FLThe passenger's loss of balance resulting from a previous impairment.Nov 14, 1991 · N2015W · No damageNTSB LAX92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe cfi's inadequate supervision and his delayed remedial action. A factor was carburetor icing conditions.Nov 14, 1991 · N5552M · Substantial damageNTSB CHI92LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Shenandoah, IAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. An associated factor is the pilot's lack of experience in this type operation (crosswind takeoffs).Nov 14, 1991 · N2776X · Substantial damageNTSB CHI92FA027Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Coffeyville, KSThe pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).Nov 14, 1991 · N5935P · DestroyedNTSB NYC92IA030Incident · No injuriesIncident investigationFinal reportDouglas DC-8-63 · Toledo, OHThe failure of the flight engineer to conduct a proper preflight inspection and ensure the main cargo door was fully closed and locked. Factors related to the accident were the damaged wires in the bundle, and the improper main cargo door installation.Nov 13, 1991 · N794AL · Minor damageNTSB NYC92FA029Accident · 5 fatalField investigationFinal reportCessna 340 · Columbus, OHThe pilot's improper execution of an emergency procedure, after an engine failure, which resulted in the loss of airplane control. Factors related to the accident were: the pilot's improper management of the fuel system; the pilot's lack of proficiency in…Nov 13, 1991 · N7672Q · Destroyed