NTSB investigations, 1995
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1995 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") = 1995 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 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.NTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.NTSB 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…NTSB ANC95LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Kenai, AKThe pilot's selection of an inadequately prepared landing area.NTSB 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.NTSB 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…NTSB 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.NTSB FTW95LA362Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dalhart, TXthe pilot's failure to maintain control of the airplane during takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.NTSB 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.NTSB 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.NTSB 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.NTSB MIA95WA212Accident · No injuriesForeign investigationGovernment Aircraft Fact N22B · Jeremie, HaitiNTSB MIA95WA210Accident · No injuriesForeign investigationAero Commander 560A · Bimini, BahamasNTSB 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.NTSB MIA95FA208Accident · 2 fatalField investigationFinal reportPiper 601P · Rock Hill, SCThe pilot's in-flight loss of aircraft control, due to incapacitation by a heart attack.NTSB 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.NTSB 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.NTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.NTSB 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.NTSB BFO95LA090Accident · No injuriesLimited investigationFinal reportInsua L-21 · Petersburg, VAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW95LA353Accident · No injuriesLimited investigationFinal reportBeech 35N · Creede, COFailure by the pilot to follow the checklist and lower the landing gear.NTSB FTW95LA351Accident · Serious injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Abilene, TXThe pilot's inadvertent stall as result of an abrupt maneuver. A factor was the loss of engine power for undetermined reasons.NTSB CHI95LA299Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tribune, KSthe pilot's use of excessive braking during the landing roll. A factor associated with the accident was the pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI95LA288Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-1 · Hammond, WIan overload failure of the right horizontal support tube assembly which the pilot/owner had modified to be adjustable. A factor in the accident was the corn.NTSB BFO95FA082Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · East Moriches, NYthe structural failure of the wing for undetermined reasons.NTSB ATL95LA164Accident · No injuriesLimited investigationFinal reportCessna 188B · Raeford, NCthe loss of the abutment seal which resulted in the fatigue failure of the cylinder head.NTSB ATL95LA161Accident · Serious injuriesLimited investigationFinal reportRonsrans R 12 · Clanton, ALThe pilot's failure to maintain proper flying speed, and the improper mixture of the fuel.NTSB SEA95LA194Accident · No injuriesLimited investigationFinal reportCessna 421 · Creswell, ORthe company mechanic's failure to properly fabricate a fuel line.NTSB SEA95LA186Accident · No injuriesLimited investigationFinal reportBeech P-35 · Bend, ORseizure of the #4 connecting rod bearing due to overtemperature resulting in the separation of the connecting rod and total loss of engine power. A factor contributing to the accident was the lack of suitable terrain for a forced landing.NTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.NTSB LAX95LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Gilbert, AZThe pilot's fuel system mismanagement and improper emergency procedure. The pilot's misjudging the flare was a factor.NTSB FTW95LA350Accident · No injuriesLimited investigationFinal reportCessna A150L · Paragould, ARLoss of engine power due to an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95IA348Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Lubbock, TXinstallation of an incorrect bearing in the number three main wheel by the wheel assembly supplier, which led to subsequent failure of the wheel bearing and separation of the wheel during takeoff.