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 LAX93FA110Accident · 4 fatalField investigationFinal reportCessna 172K · Gorman, CAThe pilot's continued flight into known adverse weather conditions and continued visual flight into instrument meteorological conditionsFeb 7, 1993 · N79411 · DestroyedNTSB FTW93FA080Accident · 2 fatalField investigationFinal reportCessna 140 · Jefferson, TXInadvertent stall. A factor was the pilot's performance of aerobatics at low altitudeFeb 7, 1993 · N76970 · DestroyedNTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.Feb 7, 1993 · N1253T · Substantial damageNTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.Feb 6, 1993 · N852DH · DestroyedNTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.Feb 6, 1993 · N8784W · Substantial damageNTSB CHI93FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 182P · Portage, INUndetermined.Feb 6, 1993 · N7227N · DestroyedNTSB ANC93LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Elmendorf Afb, AKThe pilot's excessive taxi speed. A factor which contributed to the accident was the snow covered surface.Feb 6, 1993 · N3680C · Substantial damageNTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.Feb 5, 1993 · N2019N · Substantial damageNTSB ATL93LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe student pilot's failure to judge a proper touchdown point, and his failure to maintain directional control after landing. A factor was the pilot's lack of total experience.Feb 5, 1993 · N49945 · Substantial damageNTSB ATL93LA056Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · South Mills, NCThe pilot's failure to maintain adequate clearance from trees during an aerial application maneuver. Factors were the trees adjacent to the wheat field, and the soft terrain.Feb 5, 1993 · N36521 · Substantial damageNTSB ANC93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run.Feb 5, 1993 · N4882P · Substantial damageNTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.Feb 4, 1993 · N5849J · Substantial damageNTSB NYC93LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Valley Point, WVThe failure of the pilot to make a rejected landing when the airplane failed to decelerate properly. A factor related to the accident was the failure of the pilot to close the throttle upon touchdown.Feb 4, 1993 · N9839V · Substantial damageNTSB MIA93LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Ruskin, FLThe failure of the pilot-in-command to monitor fuel quantity resulting in an engine failure due to fuel exhaustion.Feb 4, 1993 · N714YL · Substantial damageNTSB MIA93LA061Accident · No injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLThe failure of the pilot-in-command to monitor fuel quantity due to inattentiveness. Contributing to the accident was the improper use of the collective flight control during the soft field autorotation.Feb 4, 1993 · N711CH · Substantial damageNTSB CHI93LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Austin, MNThe pilot's failure to maintain altitude. The pilot's continued flight into IMC, diverted attention and the environmental conditions were factors.Feb 4, 1993 · N3658W · Substantial damageNTSB ANC93LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot's failure to maintain control of the airplane during the takeoff run. Factors were the unfavorable winds and rough water.Feb 4, 1993 · CFZEX · Substantial damageNTSB SEA93LA060Accident · No injuriesLimited investigationFinal reportCessna 206G · Keuterville, IDThe pilot's inadequate visual lookout. Factors include a power line in the vicinity of the airstrip.Feb 3, 1993 · N2837J · Substantial damageNTSB NYC93LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTThe pilot's improper emergency procedures for an engine fire during starting which resulted in the substantial damage. Factors related to the accident were the pilot's improper starting procedure and his lack of total experience.Feb 3, 1993 · N233PA · Substantial damageNTSB MIA93WA060Accident · No injuriesForeign investigationPiper PA-32-260 · Rock Sound, BahamasFeb 3, 1993 · N41709 · Substantial damageNTSB ATL93MA055Accident · 7 fatalMajor investigationFinal reportLockheed L382E-44K-20 · Marietta, GADisengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…Feb 3, 1993 · N130X · DestroyedNTSB ATL93LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe poor preflight planning by the pilot.Feb 3, 1993 · N757AC · Substantial damageNTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.Feb 2, 1993 · N11096 · Substantial damageNTSB MIA93WA059Incident · No injuriesForeign investigationDouglas DC-8-54F · Bogota, ColombiaFeb 2, 1993 · N54FA · Minor damageNTSB CHI93LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIFailure of the student pilot to maintain directional control.Feb 2, 1993 · N68155 · Substantial damageNTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.Feb 2, 1993 · N6402M · Substantial damageNTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.Feb 2, 1993 · N3854M · Substantial damageNTSB LAX93LA109Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Columbia, CAThe pilot's failure to maintain a proper glidepath while on short final approach. A factor in the accident was the dark night lighting conditions which may have affected the pilot's perceptual awareness of the airport environment and the cues for a proper…Feb 1, 1993 · N16SC · Substantial damageNTSB FTW93LA079Accident · No injuriesLimited investigationFinal reportCessna 150M · Bowie, TXThe student pilot's inadequate compensation for the gusty crosswind, and his improper decision to attempt a takeoff after touching down off the runway surface. Factors which contributed to the accident was the gusting wind condition and the high grass.Feb 1, 1993 · N9199U · Substantial damageNTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.Feb 1, 1993 · N3571V · Substantial damageNTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.Jan 31, 1993 · N56843 · Substantial damageNTSB LAX93LA108Accident · No injuriesLimited investigationFinal reportCessna 210D · Douglas, AZThe pilot's selection of the wrong runway based on inaccurate wind information.Jan 31, 1993 · N3980Y · Substantial damageNTSB FTW93LA078Accident · No injuriesLimited investigationFinal reportRans S-7 · Lancaster, TXAircraft control not maintained by pilot. Turbulence due to strong, gusty winds was a factorJan 31, 1993 · N4312C · Substantial damageNTSB DEN93LA026Accident · No injuriesLimited investigationFinal reportRaven RX7 · Durango, COPartial failure of the balloon's burner for undetermined reasons. A factor was: unfavorable wind.Jan 31, 1993 · N3581T · Substantial damageNTSB BFO93LA024Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Lanham, MDThe blockage of the right and left fuel vent line which prevented the flow of fuel to the engine causing total power loss.Jan 31, 1993 · N1383R · DestroyedNTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.Jan 30, 1993 · N5391R · Substantial damageNTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…Jan 30, 1993 · N5725G · Substantial damageNTSB LAX93LA296Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 160A · Chandler, AZThe pilot's failure to adequately evaluate the weather conditions and subsequent uncontrolled touchdown resulting in a hard landing. Gusty wind conditions were a factor in the accident.Jan 30, 1993 · N128TC · No damageNTSB LAX93LA107Accident · Serious injuriesLimited investigationFinal reportBell 206B · Parks, AZ1) The pilot not obtaining forecast weather for his route of flight nor his destination 2) the pilot's inflight decision to fly into snow with the helicopter's engine air induction particle separator kit not installed, as required by the Bell 206B pilot's…Jan 30, 1993 · N855B · Substantial damageNTSB FTW93LA077Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Marfa, TXThe pilot's continued descent below the proper altitude. Factors were the dark night, fog, and the crew's poor coordination.Jan 30, 1993 · N363N · Substantial damageNTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.Jan 30, 1993 · N29515 · Substantial damageNTSB CHI93LA080Accident · No injuriesLimited investigationFinal reportCessna 172D · Slayton, MNThe pilot's inadequate compensation for the crosswind condition. The crosswind was a factor.Jan 30, 1993 · N2440U · Substantial damageNTSB SEA93LA065Accident · No injuriesLimited investigationFinal reportCessna 182C · Huntington, UTThe improper in flt decision by the pilot in command to land on an airstrip unsuitable for landing. A factor relating to the accident was the soft snow covering the airstrip.Jan 29, 1993 · N8540T · Substantial damageNTSB NYC93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Dover, VTThe pilot's failure to maintain directional control during takeoff, and his inadequate remedial actions, resulting in a collision with a snowbank. Factors related to the accident were the ice covered runway and the snowbank along the runway edges.Jan 29, 1993 · N40586 · Substantial damageNTSB CHI93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · South St. Paul, MNThe pilot's inadequate compensation for the existing crosswind condition. The crosswind was a factor.Jan 29, 1993 · N2375P · Substantial damageNTSB ANC93LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Heiden, AKThe failure of the number 3 cylinder intake valve stem. A factor in the degree of damage the aircraft sustained in the mishap was attributable to the off airport emergency landing on show covered tundra.Jan 29, 1993 · N8327S · Substantial damageNTSB SEA93LA057Accident · No injuriesLimited investigationFinal reportCessna 180E · Riggins, IDThe improper preflight planning by the pilot and his failure to attain proper airspeed for takeoff from a short strip in tailwind weather conditions. A factor relating to the accident was the tailwind weather conditions.Jan 28, 1993 · N8691X · Substantial damageNTSB MIA93WA057Incident · No injuriesForeign investigationCessna 402-C · Georgetown, GuyanaJan 28, 1993 · N29PB · Minor damageNTSB MIA93LA056Accident · 1 fatalLimited investigationFinal reportFerran DOMINATOR-BIG ONE · Apopka, FLUndetermined.Jan 28, 1993 · N4HF · DestroyedNTSB DEN93LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COPower loss due to water contaminated fuel. A factor was: unsuitable terrain for a forced landing.Jan 28, 1993 · N67492 · Substantial damage