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 BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Aug 25, 1995 · N3965P · Substantial damageNTSB MIA95LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lumberton, MSThe failure of the landing gear, steering system (rod end bolt) due to a bending overstress separation which resulted in loss of directional control.Aug 24, 1995 · N89694 · Substantial damageNTSB LAX95FA303Accident · No injuriesField investigationFinal reportLockheed L-1011-385-1 · Pacific Ocean (Pacific Ocean)inadequate certification/approval of the airframe structure. Contributing was the lack of required inspections of the failure area.Aug 24, 1995 · N781DL · Substantial damageNTSB FTW95LA360Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Evadale, TXA failure that resulted in separation of the #5 cylinder and loss of engine oil. The lack of suitable terrain for a forced landing was a related factor.Aug 24, 1995 · N68722 · Substantial damageNTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.Aug 24, 1995 · N96911 · Substantial damageNTSB SEA95LA193Accident · No injuriesLimited investigationFinal reportHall Kitfox 1 · Pompeys Pillar, MTthe pilot's delayed decision to abort the takeoff. High density altitude, unavailabilty of aircraft takeoff performance data, and the short rough takeoff area were factors in the accident.Aug 23, 1995 · N87TJ · Substantial damageNTSB SEA95LA192Accident · Serious injuriesLimited investigationFinal reportNorth American T-28A · Rexburg, IDfatigue failure of the main hydraulic line and a resulting hydraulic fluid fire. Lack of suitable terrain for the forced landing contributed to the accident.Aug 23, 1995 · N9640C · DestroyedNTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.Aug 23, 1995 · N146KY · Substantial damageNTSB LAX95TA304Accident · No injuriesFinal reportDouglas C-54G · Aubeery, CAfailure of the pilot to see and avoid known obstacles along his route of flight. Contributing was the insufficient information given by the pilot in the lead aircraft.Aug 23, 1995 · N2742G · Substantial damageNTSB LAX95FA302Accident · Serious injuriesField investigationFinal reportCessna T207 · San Diego, CAthe pilot's improper fuel management and improper use of the fuel selector valve.Aug 23, 1995 · N91004 · DestroyedNTSB FTW95LA372Accident · Minor injuriesLimited investigationFinal reportCessna 320 · Gunnison, COFuel exhaustion induced power loss due to the pilot's failure to refuel. A factor was his disorientation.Aug 23, 1995 · N5720X · Substantial damageNTSB FTW95FA359Accident · 2 fatalField investigationFinal reportMooney M20F · Red Cliff, COImproper in-flight planning/decision by the flight crew, and their failure to maintain sufficient airspeed over mountainous terrain, which resulted in an inadvertent stall and collision with terrain. Factors relating to the accident were: high density…Aug 23, 1995 · N3768N · DestroyedNTSB CHI95LA296Accident · No injuriesLimited investigationFinal reportBradley DQ2 · Newton, KSthe pilot's improper recovery from a bounced landing. A factor was the aircraft's inadequate handling capability.Aug 23, 1995 · N8Q · Substantial damageNTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.Aug 23, 1995 · N94891 · Substantial damageNTSB ATL95FA162Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Double Springs, ALfailure of the pilot to follow emergency procedures for loss of engine power, and his failure to maintain control of the airplane. Factors relating to the accident were: the pilot's inadequate preflight planning/preparation and improper fuel consumption…Aug 23, 1995 · N15866 · DestroyedNTSB ANC95LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Kenai, AKThe pilot's selection of an inadequately prepared landing area.Aug 23, 1995 · N4728D · Substantial damageNTSB SEA95LA190Accident · No injuriesLimited investigationFinal reportMooney M20K · Roundup, MTan engine failure due to foreign object ingestion into the oil pump. A ruptured oil inlet screen contributed to the accident.Aug 22, 1995 · N1154L · Substantial damageNTSB MIA95FA211Accident · 1 fatalField investigationFinal reportAero Commander 560F · Opa Locka, FLfailure of the non-certificated pilot (unqualified person) to maintain sufficient airspeed, which resulted in a stall and a collision with the ground. Factors relating to the accident were: the non-certificated pilot's unauthorized use of an airplane that had…Aug 22, 1995 · N4630W · Substantial damageNTSB LAX95LA301Accident · Serious injuriesLimited investigationFinal reportNavion A · Groveland, CAfuel starvation, due to the pilot's improper positioning of the fuel selector. The lack of suitable terrain for a forced landing was a related factor.Aug 22, 1995 · N8513H · Substantial damageNTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 1995 · N3169U · Substantial damageNTSB FTW95LA358Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot's diverted attention, which resulted in his failure to assure that clearance was maintained from the transmission line.Aug 22, 1995 · N9190Q · DestroyedNTSB BFO95LA084Accident · No injuriesLimited investigationFinal reportBell 47D1 · Sidney, OHthe student pilot's abrupt touchdown while landing in a field. Related factors are the student pilot's failure to attain the proper descent rate during the approach to landing, and the flight instructor's inadequate supervision of the student.Aug 22, 1995 · N9115R · Substantial damageNTSB ANC95FA147Accident · 2 fatalField investigationFinal reportChampion 7ECA · Palmer, AKfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall/spin and collision with the terrain.Aug 22, 1995 · N57393 · DestroyedNTSB NYC95LA201Accident · No injuriesLimited investigationFinal reportCessna 310B · Monticello, NYfatigue failure of the right main landing gear during the landing, which resulted in a gear collapse, loss of directional control, and subsequent collision with an embankment.Aug 21, 1995 · N661R · Substantial damageNTSB FTW95LA356Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Houston, TXThe flight instructor's poor judgement, and his disregard of the owner's objection to air taxi into the hangar.Aug 21, 1995 · N911BT · Substantial damageNTSB DCA95MA054Accident · 8 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Carrollton, GAthe in-flight fatigue fracture and separation of a propeller blade resulting in distortion of the left engine nacelle, causing excessive drag, loss of wing lift, and reduced directional control of the airplane. The fracture was caused by a fatigue crack from…Aug 21, 1995 · N256AS · DestroyedNTSB CHI95LA292Accident · Minor injuriesLimited investigationFinal reportCessna TC206G · Orr, MNthe pilot's failure to retract the landing gear prior to touchdown. A factor associated with the accident was the pilot's diverted attention.Aug 21, 1995 · N9823Z · Substantial damageNTSB CHI95LA291Accident · 1 fatalLimited investigationFinal reportCessna 140 · Mio, MIthe pilot's impairment of judgement and performance which led to performing a low altitude maneuver with insufficient altitude for recovery. A factor was the tailwind.Aug 21, 1995 · N76429 · DestroyedNTSB BFO95LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Batavia, OHwas the the second pilot's loss of directional control during the takeoff roll, and the flight instructor/pilot-in-command's inadequate supervision of the flight instructor/second pilot. A related factor was the flight instructor/second pilot's lack of total…Aug 21, 1995 · N2110E · Substantial damageNTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.Aug 21, 1995 · N9407C · Substantial damageNTSB ANC95FA169Accident · 1 fatalField investigationFinal reportPiper PA-18A · Anchorage, AKThe pilot's improper in-flight planning/decision and failure to maintain adequate clearance or altitude from the mountainous terrain, while maneuvering near an airstrip.Aug 21, 1995 · N7262D · DestroyedNTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.Aug 20, 1995 · N1930Q · DestroyedNTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.Aug 20, 1995 · N8885V · DestroyedNTSB MIA95WA212Accident · No injuriesForeign investigationGovernment Aircraft Fact N22B · Jeremie, HaitiAug 20, 1995 · N4826M · Substantial damageNTSB MIA95WA210Accident · No injuriesForeign investigationAero Commander 560A · Bimini, BahamasAug 20, 1995 · N2754B · DestroyedNTSB MIA95LA209Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLThe pilot-in-command's decision to allow the student to land long and not use all the available runway and his delay in aborting the takeoff resulting in a runway overrun.Aug 20, 1995 · N1496T · Substantial damageNTSB MIA95FA208Accident · 2 fatalField investigationFinal reportPiper 601P · Rock Hill, SCThe pilot's in-flight loss of aircraft control, due to incapacitation by a heart attack.Aug 20, 1995 · N41GA · DestroyedNTSB FTW95LA352Accident · No injuriesLimited investigationFinal reportCessna 172E · Alpine, TXThe failure of the pilots of both airplanes to see and avoid each other. A factor was the Cessna's inoperative radio.Aug 20, 1995 · N5638T · 2 aircraft · Substantial damageNTSB CHI95LA295Accident · No injuriesLimited investigationFinal reportKraetzner SKY-BUGGY · Princeton, WIthe loss of engine power due to the blocked float valve seat in the carburetor and the pilot's failure to have the proper maintenance inspection performed on the airplane.Aug 20, 1995 · N16626 · DestroyedNTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.Aug 20, 1995 · N55404 · Substantial damageNTSB CHI95LA287Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Anderson, INseizure of the landing gear wheel bearing and separation of the landing gear outer wheel-half and tire from the aircraft after which directional control of the aircraft by the pilot was not possible.Aug 20, 1995 · N8347N · Substantial damageNTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 20, 1995 · N2446V · Substantial damageNTSB BFO95LA083Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Warren, OHa loss of engine power/performance for undetermined reasons. Related factors were: the pilot exceeding the airplane's maximum takeoff weight, carburetor icing conditions, a tailwind, and high temperature.Aug 20, 1995 · N2934E · DestroyedNTSB SEA95LA187Accident · No injuriesLimited investigationFinal reportCessna 177B · Yamhill, ORThe pilot's failure to maintain a proper glidepath. A factor contributing to the accident was the sunglare.Aug 19, 1995 · N11834 · Substantial damageNTSB NYC95LA199Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mayville, NYthe pilot's improper flight control input during the landing roll in high grass, which resulted in a ground loop and subsequent wingtip damage.Aug 19, 1995 · N69AS · Substantial damageNTSB LAX95LA300Accident · No injuriesLimited investigationFinal reportGettig Pitts Special S1C · Goodyear, AZThe owner/builder's improper installation of the fuel injection system unit by misaligning the drive shaft that resulted in the fracture of the shaft. The road sign was a factor in this accident.Aug 19, 1995 · N7RG · Substantial damageNTSB FTW95LA357Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's failure to maintain clearance. A factor was the fence at the end of the airstrip.Aug 19, 1995 · N95654 · Substantial damageNTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.Aug 19, 1995 · N47423 · Substantial damageNTSB FTW95LA354Accident · No injuriesLimited investigationFinal reportBeech C24R · Mineola, TXThe pilot's inadequate preflight planning/preparation, and his failure to obtain the required aircraft performance data for the flight. A factor was the high density altitude.Aug 19, 1995 · N2007C · Substantial damageNTSB FTW95LA353Accident · No injuriesLimited investigationFinal reportBeech 35N · Creede, COFailure by the pilot to follow the checklist and lower the landing gear.Aug 19, 1995 · N149G · Substantial damage