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 LAX95LA205Accident · No injuriesLimited investigationFinal reportCessna T210M · Coalinga, CAThe pilot's improper landing flare and inadequate bounced landing recovery technique.Jun 10, 1995 · N6048N · Substantial damageNTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.Jun 10, 1995 · N48934 · DestroyedNTSB FTW95LA245Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Devalls Bluff, ARThe pilot's delayed flare resulting in a hard landing. Factors were the loss of engine power due to fuel starvation as a result of fuel line blockage.Jun 10, 1995 · N3105E · Substantial damageNTSB FTW95LA234Accident · 2 fatalLimited investigationFinal reportJoy Genesis · Kerrville, TXFailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in a stall and collision with the terrain. Factors relating to the accident were: the unfavorable wind, the pilot's overconfidence in his ability, and his…Jun 10, 1995 · N8099K · DestroyedNTSB BFO95LA060Accident · Serious injuriesLimited investigationFinal reportBronislaus Challenger II · Burlington, CTA loss of engine power for an undetermined reason(s), the 30-hour student pilot's poor judgment in allowing himself to receive dual instruction in an airplane not equipped with dual conntols, the cfi's poor judgment in attempting to give instruction to a…Jun 10, 1995 · N8101Z · DestroyedNTSB BFO95LA059Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncy Valley, PAthe non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.Jun 10, 1995 · N3070U · Substantial damageNTSB BFO95FA058Accident · 3 fatalField investigationFinal reportCessna 150L · Highgate, VTthe failure of both pilots to see and avoid each other. A factor was the Cessna 172H pilot's impairment due to medication.Jun 10, 1995 · N10913 · 2 aircraft · Substantial damageNTSB ATL95LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Peachtree City, GAThe pilot's failure to maintain an adequate lookout while maneuvering on the ramp which resulted in his misjudging the clearance between his airplane and parked aircraft.Jun 10, 1995 · N73785 · Substantial damageNTSB ANC95LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Skwentna, AKThe pilot's failure to maintain directional control. Factors associated with the accident are the wet and uneven airstrip surface.Jun 10, 1995 · N13205 · Substantial damageNTSB ANC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature liftoff and subsequent inadvertent stall.Jun 10, 1995 · N8570C · Substantial damageNTSB SEA95LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Blakely Island, WAAn undetermined loss of engine power and suitable terrain was not available.Jun 9, 1995 · N114N · DestroyedNTSB MIA95WA152Accident · No injuriesForeign investigationRobinson R22 · Don-Torcuato, ArgentinaJun 9, 1995 · LVRBD · Substantial damageNTSB MIA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sarasota, FLThe pilot's improper draining of the fuel sumps during preflight inspection of the airplane. This resulted in a partial loss of engine power on the left engine on initial take off climb due to water contamination, subsequent forced landing, collapse of the…Jun 9, 1995 · N949BW · Substantial damageNTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.Jun 9, 1995 · N1143B · Substantial damageNTSB CHI95LA177Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Plato Center, ILthe pilot's excessive pull-up during a downwind banner pick-up resulting in a stall. A factor related to the accident was the tailwind.Jun 9, 1995 · N5173 · Substantial damageNTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.Jun 9, 1995 · N5762W · Substantial damageNTSB ANC95LA110Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for the wind conditions during the landing approach, and his failure to maintain altitude/clearance from trees. A factor relating to the accident was: the gusty wind condition.Jun 9, 1995 · N67112 · Substantial damageNTSB FTW95LA392Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Springlake, TXThe loss of engine power due to the uncontained failure of the third stage turbine wheel. A factor was the lack of suitable terrain for the forced landing.Jun 8, 1995 · N211JM · Substantial damageNTSB FTW95LA237Accident · Minor injuriesLimited investigationFinal reportStokes Smith DSA-1 · Brookshire, TXOwner/builder's inadequate maintenance resulting in a loss of engine power due to corroded magneto coils. A factor was the lack of suitable terrain for the forced landing.Jun 8, 1995 · N33BS · Substantial damageNTSB CHI95LA175Accident · 1 fatalLimited investigationFinal reportTom Kilgore KR-2 · Alanson, MIimproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel, and failure of the pilot to maintain control of the airplane, which resulted in a stall/spin and collision with the ground.Jun 8, 1995 · N49TK · DestroyedNTSB ATL95MA106Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-9-32 · Atlanta, GAfailure of Turk Hava Yollari maintenance and inspection personnel to perform a proper inspection of a 7th stage high compressor disc, thus allowing the detectable crack to grow to a length at which the disc ruptured, under normal operating conditions,…Jun 8, 1995 · N908VJ · Substantial damageNTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.Jun 8, 1995 · N53232 · Substantial damageNTSB MIA95LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172P · St. Petersbug, FLThe pilot-in-command's/CFI improper supervision of the dual student on landing rollout. This resulted in an on ground loss of control (directional control not maintained), and subsequent nose over.Jun 7, 1995 · N129EP · Substantial damageNTSB MIA95LA146Accident · No injuriesLimited investigationFinal reportCessna 150G · Archer, FLThe pilot's improper landing flare/touchdown resulting in a hard/bounced landing, and subsequent nose over. Contributing to the accident was the pilot's improper recovery from a bounced landing.Jun 7, 1995 · N3888J · Substantial damageNTSB MIA95FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Gainesville, FLThe pilot's loss of aircraft control due to spatial disorientation after continuing the VFR flight into instrument meteorological conditions. Factors relating to the accident were: the existing weather conditions and dark night that contributed to the pilot's…Jun 7, 1995 · N41481 · DestroyedNTSB FTW95FA232Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Joaquin, TXThe performance of aerobatics at low altitude and the inadvertent stall.Jun 7, 1995 · N8754 · DestroyedNTSB CHI95LA193Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Rapid City, SDthe pilot's failure to feather the propeller on the left engine during the descent. A factor was the carburetor icing weather condition.Jun 7, 1995 · N55362 · Substantial damageNTSB CHI95LA173Accident · Minor injuriesLimited investigationFinal reportCessna 150L · St. Charles, MOthe student pilot's inadvertent interference with flight controls which resulted in a stall. A factor associated with the accident was the student's excessive use of the elevator control.Jun 7, 1995 · N6605G · Substantial damageNTSB ANC95LA066Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident is the lack of suitable terrain for a forced landing.Jun 7, 1995 · N9958Y · Substantial damageNTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.Jun 6, 1995 · N28087 · Substantial damageNTSB SEA95LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Miles City, MTThe flight instructor's inadequate supervision. Factors to the accident were: The student pilot's failure to maintain aircraft control and the downdraft.Jun 6, 1995 · N51146 · Substantial damageNTSB LAX95LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Tucson, AZthe pilot's failure to maintain adequate clearance from a taxiway sign while taxiing clear of the runway.Jun 6, 1995 · N3875B · Substantial damageNTSB FTW95FA231Accident · 1 fatalField investigationFinal reportWeatherly 620B · Flagler, COFailure by the pilot to maintain clearance from the static line of a power transmission array during an aerial application flight.Jun 6, 1995 · N20119 · DestroyedNTSB BFO95LA057Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Quarryville, PAthe pilot's failure to attain proper altitude/clearance from obstacles during takeoff.Jun 6, 1995 · UNREG · DestroyedNTSB ATL95LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Bessemer, ALThe pilot's failure to maintain directional control during a touch and go landing.Jun 6, 1995 · N4625P · Substantial damageNTSB LAX95LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Mission Viejo, CAthe loss of engine power due to the failure of company maintenance personnel to correctly connect the throttle arm and throttle linkage during engine installation.Jun 5, 1995 · N5540K · Substantial damageNTSB FTW95FA226Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Palestine, TXLoss of aircraft control during a go-around, due to failure of the flight instructor (CFI) to assure that the minimum control speed (VMC) was maintained. Factors relating to the accident were: shutdown of the left engine, which would have prevented normal…Jun 5, 1995 · N4187P · DestroyedNTSB CHI95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Plymouth, MIthe failure of the nose wheel collar assembly as a result of the loss of a bolt.Jun 5, 1995 · N40540 · Substantial damageNTSB CHI95LA165Accident · 1 fatalLimited investigationFinal reportGrumman AA-1 · Osage Beach, MOa low altitude maneuver performed by the pilot and the pilot not maintaining the airplane's airspeed. A factor in this accident was the pilot encountering a stall/mush.Jun 5, 1995 · N6122L · DestroyedNTSB BFO95LA055Accident · Minor injuriesLimited investigationFinal reportDevaughn Teenie II · Winchester, VAthe pilot's failure to properly judge the airplane fuel supply. The resultant loss of engine power occurred over unsuitable terrain, which was a contributing factor.Jun 5, 1995 · N6783 · DestroyedNTSB ANC95LA084Accident · No injuriesLimited investigationFinal reportLockheed L-382E · Mcgrath, AKFailure of the pilot-in-command to assure the airplane was adequately flared for landing.Jun 5, 1995 · N906SJ · Substantial damageNTSB ANC95LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Manley Hot Spri, AKThe pilot's failure to correctly compensate for the existing wind conditions. The gusting wind condition was a factor.Jun 5, 1995 · N9299D · Substantial damageNTSB SEA95LA112Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Caldwell, IDThe pilot's failure to maintain clearance from power lines. Factors include sunglare encountered when he turned into the sun.Jun 4, 1995 · N9474F · DestroyedNTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.Jun 4, 1995 · N4254X · Substantial damageNTSB FTW95LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Guthrie, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain for the forced landing.Jun 4, 1995 · N5134B · Substantial damageNTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.Jun 4, 1995 · N8640A · Substantial damageNTSB CHI95LA169Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Clear Lake, MNfailure of the pilot to maintain directional control of the airplane during the takeoff roll. The proximity of trees to the runway was a related factor.Jun 4, 1995 · N3149D · Substantial damageNTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.Jun 4, 1995 · N7392P · Substantial damageNTSB ANC95TA068Accident · No injuriesFinal reportPiper PA-18-160 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing/takeoff. Factors associated with the accident are the long and wet grass covering the unimproved takeoff area.Jun 4, 1995 · N2400S · Substantial damageNTSB ANC95LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Delta, AKThe pilot's failure to maintain proper alignment with the landing surface. A factor relating to the accident was: the rough/uneven landing surface.Jun 4, 1995 · N4232Z · Substantial damage