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 CHI95LA209Accident · No injuriesLimited investigationFinal reportCessna 182S · New Haven, MIThe pilot's improper raising of the flaps during the aborted landing. Factors associated with this accident were the pilot selecting the wrong runway, not attaining the appropriate touchdown point on the runway, and delay in aborting the landing.Jul 3, 1995 · N2423Q · Substantial damageNTSB ATL95LA126Accident · No injuriesLimited investigationFinal reportCessna A188B · Decatur, ALThe pilot's selection of unsuitable terrain for a precautionary landing. Which resulted in the collapse of the main landing gear. The undetermined aircraft problem and rough/uneven terrain were related factors.Jul 3, 1995 · N6296G · Substantial damageNTSB SEA95LA135Accident · No injuriesLimited investigationFinal reportCessna 172L · Stanley, IDThe pilot's failure to use all available runway, his improper use of flaps, and his failure to maintain airspeed. A factor contributing to the accident is high density altitude.Jul 2, 1995 · N4319Q · Substantial damageNTSB NYC95LA138Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Malone, NYthe pilot's improper use of the flight controls, which resulted in an accelerated stall, an in-flight loss of control, and an uncontrolled descent to the ground. A factor relating to the accident was: the pilot's decision to fly the airplane in an airshow…Jul 2, 1995 · N51KF · DestroyedNTSB LAX95LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · New Cuyama, CAthe pilot's failure to attain and maintain an adequate airspeed, his premature rotation, and his failure to maintain directional control when the aircraft settled back onto the runway. The pilot's selection of a closed airport for the takeoff attempt was a…Jul 2, 1995 · N61602 · Substantial damageNTSB FTW95FA266Accident · 4 fatalField investigationFinal reportBeech V35B · Huntsville, ARan engine surge for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A factor was the aft center of gravity.Jul 2, 1995 · N2777T · DestroyedNTSB CHI95LA206Accident · Serious injuriesLimited investigationFinal reportBeech 23A · Spearfish, SDThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. Factors associated with this accident were remedial action by the pilot was not possible due to the low altitude at which the stall took place.Jul 2, 1995 · N2397Q · DestroyedNTSB ATL95LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Holly Ridge, NCthe pilot diverted his attention and failed to maintain clearance from obstacles.Jul 2, 1995 · N28445 · Substantial damageNTSB ATL95LA125Accident · No injuriesLimited investigationFinal reportLuscombe 8A/E · Williamson, GAThe pilot in command's failure to compensate for wind conditions which resulted in a failure to maintain control of the aircraft when a windshear was encountered.Jul 2, 1995 · N2853K · Substantial damageNTSB ATL95LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe pilot's failure to maintain aircraft control which resulted in the uncontrolled descent and collision with terrain.Jul 2, 1995 · N8048D · Substantial damageNTSB SEA95LA134Accident · No injuriesLimited investigationFinal reportCessna 210B · Lewiston, MTLoss of engine power due to undetermined reasons, and the lack of a suitable area for the forced landing.Jul 1, 1995 · N4GY · Substantial damageNTSB NYC95LA139Accident · No injuriesLimited investigationFinal reportCessna 337G · Brant, NYthe pilot's improper decision to takeoff with a tailwind condition on an unimproved grass strip and a subsequent premature rotation resulting in an aborted takeoff and a subsequent collision with a utility pole on the departure end of the grass strip.Jul 1, 1995 · N72168 · Substantial damageNTSB NYC95LA137Accident · No injuriesLimited investigationFinal reportField VARI-EZE · Malone, NYfailure of the propeller speed reduction unit due to an inadequate design change by the manufacturer, which resulted in a complete loss of thrust. A factor was the rough terrain.Jul 1, 1995 · CGMEZ · Substantial damageNTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.Jul 1, 1995 · N7322 · Substantial damageNTSB LAX95LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Payson, AZa loss of power for undetermined reasons.Jul 1, 1995 · N2820Z · Substantial damageNTSB LAX95LA233Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Carmel Valley, CAfuel starvation due to the pilot's inadequate preflight preparation in that he failed to position the fuel selector to a tank known to contain fuel.Jul 1, 1995 · N8399T · DestroyedNTSB LAX95LA232Accident · No injuriesLimited investigationFinal reportCessna 401A · Van Nuys, CAthe failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.Jul 1, 1995 · N444RJ · Substantial damageNTSB FTW95LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Farmington, NMThe pilot's failure to verify the fuel tank selector position and the resultant fuel starvation induced power loss.Jul 1, 1995 · N4823T · Substantial damageNTSB CHI95LA208Accident · No injuriesLimited investigationFinal reportCessna 177B · Nappanee, INThe failure of the pilot to do adequate preflight planning and failure to refuel when he had the opportunity. A factor in the accident was the soft field due to recent rains.Jul 1, 1995 · N13734 · Substantial damageNTSB ATL95LA123Accident · Minor injuriesLimited investigationFinal reportKnosp Corbin JR. ACE-E · Whiteville, NCContamination of the fuel system which resulted in fuel starvation and a total loss of engine power. .Jul 1, 1995 · N74RK · Substantial damageNTSB ANC95LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of the weather conditions, and improper inflight planning/decision to assure clearance from mountainous terrain. A factor relating to the accident was: the unfavorable/gusty wind condition.Jul 1, 1995 · N555WK · Substantial damageNTSB ANC95LA091Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Shishmaref, AKFailure of the pilot to abort the takeoff, while there was sufficient runway remaining. Factors relating to the accident were: unfavorable wind conditions, and failure of the pilot to lower the flaps for takeoff.Jul 1, 1995 · N9600K · Substantial damageNTSB ANC95FA090Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Kodiak, AKThe pilot's attempt to fly VFR into IMC conditions and his failure to maintain clearance from terrain. Factors include fog and low ceilings.Jul 1, 1995 · N8385G · DestroyedNTSB NYC95LA163Accident · No injuriesLimited investigationFinal reportHelio H-295 · Block Island, RIthe failure of the crosswind castering gear to remain locked on the right main gear during the takeoff roll which resulted in directional control not possible.Jun 30, 1995 · N316LM · Substantial damageNTSB MIA95WA169Accident · No injuriesForeign investigationAero Commander 681 · Nassau, BahamasJun 30, 1995 · N70RF · Substantial damageNTSB LAX95LA234Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Truckee, CAfuel exhaustion due to the pilot's inadequate preflight fuel planning, and his failure to refuel the aircraft while en route.Jun 30, 1995 · N300EW · Substantial damageNTSB LAX95LA231Accident · No injuriesLimited investigationFinal reportCessna 150G · Riverdale, CAFuel exhaustion due to the student pilot's inadequate preflight inspection and his failure to refuel the aircraft en route. A factor in the accident was inadequate supervision of the student by the flying club and the student's flight instructor.Jun 30, 1995 · N3421J · Substantial damageNTSB FTW95LA276Accident · No injuriesLimited investigationFinal reportCessna 150F · Garfield, COThe pilot's delayed decision to deviate away from the deteriorating weather. Factors were his inadequate evaluation of the weather, high density altitude, and the resultant inadvertent operation of the airplane beyond the climb performance limitations of the…Jun 30, 1995 · N8155S · Substantial damageNTSB CHI95LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Linton, NDThe pilot's misjudging distance and altitude. The pilot's lack of total experience in type of operation was a factor.Jun 30, 1995 · N6917W · Substantial damageNTSB ATL95LA122Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Andalusia, ALThe pilot's failure to maintain airspeed in a climbing turn, that resulted in an inadvertent stall.Jun 30, 1995 · N1254W · Substantial damageNTSB SEA95LA141Accident · No injuriesLimited investigationFinal reportMooney M20E · Ronan, MTDirectional control was not maintained. Factors to the accident were a rough/uneven airstrip and tall vegetation.Jun 29, 1995 · N9273M · Substantial damageNTSB LAX95LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Thermal, CAthe student pilot's failure to maintain directional control while executing a touch-and-go.Jun 29, 1995 · N7658W · Substantial damageNTSB LAX95IA229Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Elko, NVin-flight separation of the aileron as a result of inadequate bonding.Jun 29, 1995 · N457TM · Minor damageNTSB FTW95LA291Accident · Serious injuriesLimited investigationFinal reportQuicksilver Mxlr II · Borger, TXThe pilot's selection of unsuitable terrain for landing and takeoff and failure to maintain flying speed. The soft, uneven terrain and tall grass were factors.Jun 29, 1995 · UNREG · Substantial damageNTSB FTW95LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Weston, TXThe pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…Jun 29, 1995 · N9502D · Substantial damageNTSB FTW95LA273Accident · No injuriesLimited investigationFinal reportCessna A188A · Pharr, TXThe pilot's inadequate aircraft preflight which failed to purge the aircraft fuel system of contaminants. A factor was the unsuitable terrain in the emergency landing area.Jun 29, 1995 · N5631J · Substantial damageNTSB FTW95LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denton, TXInadequate supervision by the flight instructor (CFI), and the resultant loss of directional control. A factor relating to the accident was: the lack of brake controls for the right seat occupant.Jun 29, 1995 · N1394T · Substantial damageNTSB FTW95FA261Accident · 2 fatalField investigationFinal reportCessna 182Q · San Angelo, TXThe pilot's decision to attempt flight into known adverse weather conditions, and his loss of aircraft control due to spatial disorientation. Factors relating to the accident were: conditions of darkness, thunderstorm and lightning, and the pilot's lack…Jun 29, 1995 · N759NU · DestroyedNTSB ANC95LA088Accident · No injuriesLimited investigationFinal reportMaule M-5-235 · Palmer, AKThe excessive airspeed maintained by the pilot during the approach and landing, and the pilot's failure to abort the landing, while there was still sufficient runway remaining. A factor relating to the accident was: the pilot's lack of experience in the type…Jun 29, 1995 · N9104E · Substantial damageNTSB ANC95LA087Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's failure to follow procedures and directives to not extend the landing gear during a water landing due to habit interference.Jun 29, 1995 · N9667Q · Substantial damageNTSB NYC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Bridgewater, CTthe loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.Jun 28, 1995 · N9176H · Substantial damageNTSB NYC95LA134Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Morehead, KYThe pilot's failure to assure that an inadequate oil supply was available fot the flight.Jun 28, 1995 · N16WW · Substantial damageNTSB MIA95LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Orlando, FLUnknown.Jun 28, 1995 · N25AT · Substantial damageNTSB MIA95LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lake Placid, FLTotal failure of the fuel vent system resulting in the total loss of engine power during cruise flight. Contributing to the accident was the inadequate inspection of the airplane during the last annual inspection for failure of the mechanic to identify that…Jun 28, 1995 · N96567 · Substantial damageNTSB LAX95LA227Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Turlock, CAthe failure of the student pilot to: 1) maintain the proper approach speed; 2) attain the proper touchdown point; and 3) her delayed decision to execute a go-around.Jun 28, 1995 · N63264 · Substantial damageNTSB ATL95LA120Accident · No injuriesLimited investigationFinal reportPierce Kitfox III · Arlington, TNThe pilot's premature rotation on takeoff that resulted in low airspeed and an inadvertent stall.Jun 28, 1995 · N101GP · Substantial damageNTSB ANC95LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's failure to maintain clearance from tall vegetation during a low pass.Jun 28, 1995 · N5238N · Substantial damageNTSB ANC95LA089Accident · No injuriesLimited investigationFinal reportCessna 208 · Talkeetna, AKThe pilot's inadequate visual lookout during the turn.Jun 28, 1995 · N9825F · Substantial damageNTSB SEA95LA131Accident · No injuriesLimited investigationFinal reportCessna 172F · Homedale, IDThe pilot misjudged distance and altitude during the approach. The downdraft was a factor.Jun 27, 1995 · N4298C · Substantial damageNTSB MIA95WA172Accident · No injuriesForeign investigationCessna 402C · Congo Town, Congo - KinshasaJun 27, 1995 · N60LC · Substantial damage