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.
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
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 FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.NTSB FTW95LA169Accident · No injuriesLimited investigationFinal reportStembridge Spezio · Duncan, OKThe pilot's improper compensation for the wind conditions. A factor was gusty winds.NTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.NTSB BFO95LA046Accident · No injuriesLimited investigationFinal reportSchweizer SC2-33A · North Adams, MAthe failure of the tow rope during the initial climb. Related factors are the gusty wind conditions, the low altitude at which the failure occurred, the tailwind during the emergency landing roll, and the CFI's intentional ground loop due to the obstacle…NTSB ATL95LA083Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Super GT 400 · Pleasant Hill, TNThe pilot's inadequate compensation for wind conditions, and his failure to maintain aircraft control during the initial climb. Factors were the crosswind conditions, the perimeter trees, and the pilot's lack of total flying experience.NTSB ANC95LA045Accident · No injuriesLimited investigationFinal reportPiper PA-20-125 · Koliganek, AKThe student pilot's inadequate compensation for the wind conditions. A factor in the accident is a crosswind.NTSB ANC95LA043Accident · No injuriesLimited investigationFinal reportCessna 180A · Bethel, AKThe Cessna pilot's failure to maintain sufficient clearance from the transport airplane while taxiing, and the ground personnel's inadequate lookout while marshalling the transport airplane from the ramp.NTSB ANC95FA044Accident · 2 fatalField investigationFinal reportCessna 180B · Cantwell, AKThe pilot's continued VFR flight into IMC conditions. Weather conditions consisting of low ceilings and turbulence were factors in the accident.NTSB SEA95FA079Accident · 1 fatalField investigationFinal reportCessna 182P · Index, WAthe pilot's continued flight into known adverse weather, and his improper use of carburetor heat. Factors include: weather conditions conducive to carburetor icing and airframe icing, airframe ice, and mountainous/hilly terrain in the area of the forced…NTSB MIA95LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLThe failure of the student pilot to maintain directional control during landing. A contributing factor was the delayed remedial action to attempt a go-around.NTSB MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.NTSB FTW95LA170Accident · No injuriesLimited investigationFinal reportBoeing 737-400 · Denver, COProper descent rate not maintained by the first officer, resulting in a hard landing. Factors were unfavorable wind conditions and the captain's inadequate supervision of the first officer.NTSB CHI95FA126Accident · 4 fatalField investigationFinal reportCessna 150M · Oshkosh, WIInadequate visual lookout by the pilot of the Beech V35B, resulting in his failure to see-and-avoid the Cessna 150, which was ahead and below him on final approach; and failure of the tower controller to provide adequate service (flight advisories and landing…NTSB MIA95LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLThe inadequate preflight planning by the pilot-in-command to assure that adequate fuel was on-board the airplane to complete the flight, which resulted in a loss of engine power, forced landing and the collision with a tree on touchdown.NTSB FTW95LA168Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Tulsa, OKThe pilot's improper emergency procedure preventing emergency gear extension. A factor was the loss of electrical alternator power for undetermined reasons.NTSB NYC95LA087Accident · 1 fatalLimited investigationFinal reportPiper PA-60-602P · Danbury, CTThe pilot's delay in initiating a go-around (aborted landing) and failure to assure that the flaps were properly reset for the go-around. Factors relating to the accident were: the pilot's failure to achieve the proper touchdown point for landing, the wet…NTSB MIA95FA105Accident · 1 fatalField investigationFinal reportPackard/Squire RV-4 · Davie, FLEngine fuel starvation due to the pilot's fuel mismanagement. A loss of control followed as the pilot inadvertently stalled the airplane while maneuvering for the forced landing.NTSB LAX95LA159Accident · No injuriesLimited investigationFinal reportK. A. Covington Lancair 320 · Prescott, AZthe pilot's failure to attain a stabilized approach due to an improper elevator trim setting resulting in an improper flare.NTSB LAX95FA161Accident · 2 fatalField investigationFinal reportHelio H-250 · Round Mountain, CAthe pilot's poor preflight planning/preparation and in-flight decision by continuing VFR flight into instrument meteorological conditions. The pilot's delay in returning to the departure airport, the low clouds, and low visibility were factors in this…NTSB FTW95LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Mountain Home, ARThe pilot's failure to compensate for the gusty crosswind. A factor was gusting crosswinds.NTSB CHI95FA124Accident · 1 fatalField investigationFinal reportBeech 65-B80 · Great Bend, NDthe pilot/mechanic's inadequate maintenance (inspection) of aircraft and the pilot's failure to maintain airspeed (VMC). Factors were icing conditions, deteriorated induction air ducting, and failure of a piston assembly.NTSB CHI95FA121Accident · 3 fatalField investigationFinal reportCessna P-210N · Belle Plaine, MNthe failure to replace the deteriorated deicing boots, and the failure of the boots to operate when the airplane encountered icing condition. An additional causes were the pilot's failure to maintain adequate airspeed and the excessive pullup performed by the…NTSB ANC95GA048Accident · 1 fatalFinal reportCessna 182Q · Bumping Lake, WAA loss of engine power for an undetermined reason. Factors relating to the accident were: lack of suitable terrain for a forced landing in mountains, low ambient temperatures that contributed to hypothermia, the lack of survival equipment, an erratic ELT…NTSB SEA95LA077Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Timber, ORThe pilot's inadequate aircraft preflight during which he failed to notice the main rotor shipping block had not been removed, and the resultant restricted movement of the flight control system.NTSB NYC95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Wilmington, OHThe flight instructor's inadequate supervision of the student pilot during the approach, resulting in a loss of control and hard landing. The gusty wind condition was a factor.NTSB NYC95LA085Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Tangier Island, VAThe pilot's failure to maintain obstacle clearance which resulted in an inflight collision with a tree. Contributing factors are a crosswind and the pilot's failure to maintain directional control and his inadequate compensation for wind conditionsNTSB MIA95LA104Accident · Minor injuriesLimited investigationFinal reportHaseloh, D. W. RAF 2000 GTX SE · Lakeland, FLTotal loss of engine power due to vibration failure of a 14-gauge electrical wire which is connected to the negative terminal of the ignition coil. Contributing to the accident was the inadequate design of the ignition system by design personnel, and…NTSB LAX95LA160Accident · No injuriesLimited investigationFinal reportCessna 170A · Woodland, CAthe pilot's improper recovery from a bounced landing. The mechanic's inadequate annual inspection by failing to determine the worn condition of the crosswind landing gear detent stop groove and snubber pin and the soft terrain were factors in this accident.NTSB LAX95LA158Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lakeport, CAthe student's misjudged landing flare and his failure to verify the validity of the low rotor warning. Factors in the accident were the company management's continued use of the helicopter in flight training operations with a known discrepancy in the main…NTSB FTW95LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · San Antonio, TXThe pilot-in-command's failure to set the parking brake.NTSB FTW95LA165Accident · Minor injuriesLimited investigationFinal reportMaule MXT-7-180 · Eunice, LAThe pilot's failure to maintain clearance. A factor was the windshear condition.NTSB BFO95T#A03Accident · No injuriesClass 3Final reportSchweizer 300C · Lithopolis, OHNTSB ATL95LA082Accident · No injuriesLimited investigationFinal reportCessna 337G · Savannah, GAThe pilot's improper flare and his improper use of the flight controls during landing which resulted in collapse of the nose gear.NTSB ATL95LA081Accident · Serious injuriesLimited investigationFinal reportEccker, Donald E. Rans S-10 · Wilson, NCThe pilot's failure to maintain control of the airplane during the touchdown phase of the emergency landing to the runway. The lack of a carburetor heat system and the carburetor icing weather conditions were factors.NTSB FTW95LA164Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marlin, TXFuel exhaustion engine power loss due to the pilot's failure to refuel. Factors were the lack of suitable terrain available for the forced landing and the dark night condition.NTSB ANC95GA083Accident · No injuriesFinal reportPiper PA-18 · Copper Center 2, AKThe pilot not using the checklist and landing with the skis pumped down.NTSB FTW95LA162Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromadier · Pine Bluff, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the pilot's diverted attention.NTSB FTW95FA158Accident · 1 fatalField investigationFinal reportCessna 180B · Sanger, TXThe pilot's performance of a low altitude maneuver and his failure to maintain aircraft control. A factor was the gusty wind.NTSB ATL95FA079Accident · 1 fatalField investigationFinal reportCessna 172F · Seneca, SCThe pilot's inadequate visual lookout while maneuvering near utility lines, which resulted in a collision with the wires.NTSB SEA95LA076Accident · No injuriesLimited investigationFinal reportCessna 402B · Boise, IDFailure of both pilots to perform adequate visual lookout during taxi, and the ground controller's failure to identify the position of the Piper PA-34 before issuing taxi instructions. Factors relating to the accident were: decreased visibility due to…NTSB MIA95LA102Accident · No injuriesLimited investigationFinal reportGarrison Kolb Twinstar · Lakeland, FLFailure of the pilot to maintain airspeed resulting in the inadvertent stall. Contributing to the accident was complacency by the pilot while on short final approach to land.NTSB MIA95FA100Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · St. Petersburg, FLThe failure of the pilot to extend wing flaps and maintain airspeed while on approach to land resulting in an inadvertent stall, spin, and uncontrolled descent until collision with a residence and the ground.NTSB LAX95FA157Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Pollack Pines, CAThe pilot's disregard of a hazardous weather advisory; his decision to fly into known adverse weather conditions; his failure to maintain control of the airplane with an accumulation of airframe ice; and his improper use of the flight controls during recovery…NTSB FTW95LA161Accident · Minor injuriesLimited investigationFinal reportGardner Varieze · Addison, TXThe jammed throttle. Factors were the knob becoming loose and separating from the throttle lever, and the lack of suitable terrain available for the forced landing.NTSB CHI95LA122Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSthe pilot taking off the airplane at a low liftoff speed (Vlo). A factor associated with the accident was a stall/mush encountered by the pilot.NTSB CHI95LA120Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · St. Clair, MOthe pilot's impairment of judgment and performance due to drugs which led to his operating the airplane with a known mechanical deficiency.NTSB ATL95LA080Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Brownsboro, ALThe student pilot's inadvertent use of spoilers during takeoff. Factors related to the accident were: the glider instructor's failure to identify the extended spoilers, and the proximity of trees in the emergency landing area.NTSB ATL95LA077Accident · Minor injuriesLimited investigationFinal reportBeech B-19 · Jackson, ALThe pilot's continued operation of the airplane with a known deficiency in available power.NTSB ATL95LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe pilot's failure to adequately compensate for wind conditions during landing, which resulted in a loss of directional control.NTSB ATL95LA075Accident · No injuriesLimited investigationFinal reportCessna 182J · Calera, ALThe pilots improper decision to land downwind on the short runway.