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 NYC91FA196Accident · 2 fatalField investigationFinal reportCessna 152 · New Paltz, NYFailure of the instructor pilot (CFI) to assure that the proper altitude was maintained. A factor related to the accident was: the cfi's lack of experience in the type of operation.Aug 2, 1991 · N6494Q · DestroyedNTSB LAX91LA341Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Riverside, CAThe contamination of fuel in the right tank of the accident airplane with an unknown oil-like substance.Aug 2, 1991 · N5819Q · Substantial damageNTSB LAX91LA340Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Lake Elsinore, CAThe in-flight failure of the right elevator. Factors relating to this accident was the pilot's decision to perform aerobatics at an improper altitude.Aug 2, 1991 · N1693G · DestroyedNTSB LAX91LA337Accident · Minor injuriesLimited investigationFinal reportEagle DW1 · Poston, AZThat the pilot misjudged the distance from the wires which required a rapid pull-up maneuver and his failure to maintain adequate flying speed. Contributing to this accident were the transmission wires.Aug 2, 1991 · N8812W · DestroyedNTSB LAX91FA344Accident · 1 fatalField investigationFinal reportCessna 182P · Lovelock, NVFailure of the pilot to maintain sufficient altitude for obstruction clearance, and his inadequate visual scan.Aug 2, 1991 · N1315S · DestroyedNTSB FTW91LA141Accident · No injuriesLimited investigationFinal reportCessna 172F · Cumby, TXPower loss due to a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.Aug 2, 1991 · N5524R · Substantial damageNTSB FTW91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Jewett, TXPremature retraction of the flaps near the ground at slow airspeed. A factor was the attempted low pass.Aug 2, 1991 · N7036X · DestroyedNTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.Aug 2, 1991 · N9377T · Substantial damageNTSB CHI91LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILInadequate compensation for wind conditions and directional control was not maintained by the pilot. Factors related to the accident were a gusty crosswind landing environment and a ditch.Aug 2, 1991 · N97650 · Substantial damageNTSB CHI91LA242Accident · Minor injuriesLimited investigationFinal reportAmerican AA1 · Spearville, KSThe pilot's selection of unsuitable terrain on which to perform a precautionary landing. Factors related to the accident were poor in flight/planning decision which resulted in the pilot becoming lost/disoriented.Aug 2, 1991 · N6108L · Substantial damageNTSB BFO91FA072Accident · 1 fatalField investigationFinal reportCessna 210N · Petersburg, VAThe pilot's inadequate pre-takeoff check and his failure to abort the takeoff. Inadequate maintenance of the engine was a factor.Aug 2, 1991 · N2112S · DestroyedNTSB ATL91LA151Accident · No injuriesLimited investigationFinal reportCessna 182L · Macon, NCThe pilot's failure to accurately judge the distance required to stop the airplane. A factor in the accident was the wet, grass runway surface at the time of the accident.Aug 2, 1991 · N3146R · Substantial damageNTSB ANC91LA113Accident · No injuriesLimited investigationFinal reportMooney M-20F · Wood River, AKThe failure of the number 4 cylinder connecting rod cop due to fatigue. Contributing to the accident was the rough surface of the forced landing area.Aug 2, 1991 · N6848V · Substantial damageNTSB NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.Aug 1, 1991 · N4436M · Substantial damageNTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.Aug 1, 1991 · N3722W · DestroyedNTSB LAX91LA338Accident · No injuriesLimited investigationFinal reportCessna 421C · Auburn, CAThe pilot's failure to attain the proper touchdown point while landing.Aug 1, 1991 · N98455 · Substantial damageNTSB FTW91LA138Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Wylie, TXThe pilot's failure to maintain clearance with the water. A factor was the pilot's ostentatious display.Aug 1, 1991 · N23TV · Substantial damageNTSB DEN91LA106Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Aspen, COA pilot induced inadvertent stall. Factors were: the pilot's failure to ascertain the landing gear was down and locked in a timely manner, a low (fluid) level in hydraulic reservoir, causing the hydraulic pump to fluctuate (cavitate), and the pilot's…Aug 1, 1991 · N9711X · DestroyedNTSB CHI91LA239Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Bridgewater, SDDirectional control was not maintained by the pilot. A factor related to the accident was a fence.Aug 1, 1991 · N6373A · Substantial damageNTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.Aug 1, 1991 · N76535 · Substantial damageNTSB CHI91DCJ04Accident · No injuriesFinal reportCessna T188C · Grand Island, NEThe pilot's failure to maintain adequate clearance from crops during aerial application maneuvers. Related factors are the failure of a propeller pitch change mechanism and the pilot's diverted attention.Aug 1, 1991 · N2872J · Substantial damageNTSB BFO91LA071Accident · No injuriesLimited investigationFinal reportCessna 172G · Fredericksburg, VAThe pilot's selection of the improper fuel tank. Contributing to the accident was the pilot did not use the check list.Aug 1, 1991 · N6002R · Substantial damageNTSB ATL91FA148Accident · 1 fatalField investigationFinal reportCessna 401 · Monroe, NCInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. The pilot's lack of familiarity with the aircraft fuel system was a related factor.Aug 1, 1991 · N3298Q · Substantial damageNTSB ANC91FA115Accident · 2 fatalField investigationFinal reportCessna A185F · Amitchiak Lake, AKThe pilot's failure to maintain the airplane's airspeed above stalling; thereby losing control. Factors contributing to the accident were the mountainous terrain, the mountain wave, and insufficient altitude from which to recover.Aug 1, 1991 · N1687M · Substantial damageNTSB SEA91LA197Accident · No injuriesLimited investigationFinal reportCessna 150M · Hillsboro, ORFailure of the pilot to refuel resulting in fuel exhaustion.Jul 31, 1991 · N9190U · DestroyedNTSB NYC91LA195Accident · Minor injuriesLimited investigationFinal reportBeech C50 · Salem, OHEngine failure as a result of improper maintenance and failure of the propeller feathering system for an undetermined reason. Factors were aircraft poor climb performance as resulted of the unfeathered propeller and obstructions which prevented a return to…Jul 31, 1991 · N9674R · Substantial damageNTSB NYC91FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Fogelsville, PAThe improper decision by the non-instrument rated pilot to attempt VFR flight in instrument meteorological conditions, which resulted in a loss of airplane control. Factors related to the accident were: the pilot's overconfidence in his ability, his lack of…Jul 31, 1991 · N28568 · DestroyedNTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.Jul 31, 1991 · N2946E · Substantial damageNTSB LAX91LA335Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Scottsdale, AZFailure of the pilot-in-command accurately performing inflight fuel consumption calculations resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot-in-command's poorly planned approached which terminated in a…Jul 31, 1991 · N8067G · Substantial damageNTSB FTW91LA135Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mesquite, TXThe flight instructor's inadequate supervision of the student. Factors were the dual student's misjudgement of altitude and premature flare of the airplane.Jul 31, 1991 · N1927L · Substantial damageNTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.Jul 31, 1991 · N6335S · DestroyedNTSB FTW91FA131Accident · 1 fatalField investigationFinal reportSchempp-Hirth DISCUS-B · Medina, TXThe failure of the pilot in command to maintain an adequate visual lookout. A factor was collision induced incapacitation.Jul 31, 1991 · JA241 · 2 aircraft · DestroyedNTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.Jul 31, 1991 · N5076 · Substantial damageNTSB CHI91LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Manning, IAThe pilot's improper selection of fuel tanks and improper in-flight emergency procedure by the pilot.Jul 31, 1991 · N423FL · Substantial damageNTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.Jul 31, 1991 · N55924 · Substantial damageNTSB CHI91FA235Accident · 2 fatalField investigationFinal reportAero Commander 500B · Silica, KSThe failure of both pilots to maintain adequate separation during formation flight. Related factors are overconfidence in personal ability and poor planning/decision.Jul 31, 1991 · N904DF · 2 aircraft · DestroyedNTSB ATL91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Spartanburg, SCThe pilot's failure to follow the checklist and extend the landing gear prior to touchdown.Jul 31, 1991 · N300HF · Substantial damageNTSB ATL91LA145Accident · No injuriesLimited investigationFinal reportCessna 188B · Monroeville, ALThe pilot's misjudgment of the clearance between the airplane and the electrical transmission wire. A factor was the hazy visibility.Jul 31, 1991 · N9106G · Substantial damageNTSB DEN91DTE01Accident · 1 fatalFinal reportWarner, David B. GLASAIR-SHA · Eagle, COThe pilot-in-command's failure to maintain airspeed while maneuvering in a turn during initial takeoff climb, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors were: excessive bank angle and abrupt maneuver at a…Jul 30, 1991 · N520W · DestroyedNTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.Jul 30, 1991 · N7113A · Substantial damageNTSB CHI91LA232Accident · Serious injuriesLimited investigationFinal reportCessna 305 · Hutchinson, KSFuel consumption calculations misjudged by the pilot resulting in fuel exhaustion. Factors related to the accident were compensation for wind conditions were inadequate and presence of trees during the emergency landing attempt.Jul 30, 1991 · N19KL · Substantial damageNTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.Jul 29, 1991 · N8585J · Substantial damageNTSB FTW91LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Cut And Shoot, TXThe total loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.Jul 29, 1991 · N5707E · DestroyedNTSB CHI91LA227Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Hutchinson, KSThe landing gear handle was placed in the gear up postion prematurely resulting in a gear retraction during takeoff. Factors related to the accident were proper procedures were not followed by the pilot.Jul 29, 1991 · N120EL · Substantial damageNTSB BFO91DLQ01Accident · Serious injuriesFinal reportGordorn Price Ultimate 10-300 · Franklin, KYDelay in switching fuel tanks which resulted in fuel exhaustion and loss of engine power.Jul 29, 1991 · N6521R · Substantial damageNTSB ANC91LA112Accident · No injuriesLimited investigationFinal reportPilatus Porter PC-6/350 · Yakutat, AKThe fuel contamination and the pilot's inadequate preflight. Contributing to the accident was the soft sand bar.Jul 29, 1991 · N4913 · Substantial damageNTSB ANC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182C · Cordova, AKA total loss of engine power while operating over water.Jul 29, 1991 · N8651T · Substantial damageNTSB SEA91LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roy, MTThe failure of the pilot to maintain clearance from obstacles during takeoff.Jul 28, 1991 · N2322A · Substantial damageNTSB SEA91LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Genesee, IDThe pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.Jul 28, 1991 · N48599 · DestroyedNTSB NYC91LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, MEInadequate compensation for gusting winds by the pilot-in-command.Jul 28, 1991 · N5482K · Substantial damage