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 CHI95LA343Accident · 1 fatalLimited investigationFinal reportBeech C23 · Waukegan, ILThe pilot's VFR flight into instrument meteorolical conditions.Mar 31, 1995 · N23990 · DestroyedNTSB BFO95LA047Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bridgeton, NJthe student pilot's inadequate recovery from a bounced landing. A factor in the accident was the suddenly changing wind condition.Mar 31, 1995 · N99248 · Substantial damageNTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.Mar 30, 1995 · N96746 · DestroyedNTSB FTW95LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Catoosa, OKThe pilot's failure to maintain terrain and obstacle clearance.Mar 30, 1995 · N4900Y · Substantial damageNTSB FTW95FA150Accident · 1 fatalField investigationFinal reportCessna 177RG · Dalhart, TXThe pilot's VFR flight into IMC conditions and the ensuing spatial disorientation. Factors were the pilot's self-induced pressure to reach his destination, his failure to obtain a weather briefing for the flight, and the weather conditions.Mar 30, 1995 · N35917 · DestroyedNTSB MIA95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Kissimmee, FLThe inadequate annual inspection by a mechanic that failed to detect corrosion that eventually failed the engine mounts and allowed the engine and nosegear to deflect to the side during landing roll.Mar 29, 1995 · N38606 · Substantial damageNTSB FTW95IA148Incident · 1 fatalIncident investigationFinal reportDouglas DC-9-32 · Abilene, TXIncapacitation of the first officer due to a heart attack.Mar 29, 1995 · N5342L · No damageNTSB ATL95LA072Accident · No injuriesLimited investigationFinal reportCessna 172N · Paris, TNThe failure of the pilots of both aircraft to maintain proper visual lookout during landing at the uncontrolled airport.Mar 29, 1995 · N258ER · 2 aircraft · Substantial damageNTSB ANC95LA041Accident · No injuriesLimited investigationFinal reportCessna 170A · Anchorage, AKThe pilot's failure to correct for torque/p factor when adding engine power for the go-around maneuver. The pilot's misjudged flare, delayed go-around, and lack of total experience were factors in the accident.Mar 29, 1995 · N1364D · Substantial damageNTSB ANC95LA040Accident · No injuriesLimited investigationFinal reportCessna 206G · Chevak, AKThe pilot's misjudgment of the landing flare and failure to maintain adequate airspeed to avoid stalling the airplane.Mar 29, 1995 · N756TA · Substantial damageNTSB MIA95FA094Accident · 2 fatalField investigationFinal reportCessna 172N · Venice, FLIntentional VFR flight into IMC by the pilot-in-command, failure of the pilot to maintain aircraft control, spatial disorientation, and altitude inadequate for recovery following the in flight loss of control.Mar 28, 1995 · N2196E · Substantial damageNTSB LAX95LA147Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Byron, CAthe unsuitable terrain selected by the pilots.Mar 28, 1995 · N8320A · Substantial damageNTSB ANC95T#A01Accident · No injuriesClass 3Final reportde Havilland DHC-3 · Selawik, AKMar 28, 1995 · N44NB · Substantial damageNTSB FTW95FA147Accident · 1 fatalField investigationFinal reportCessna R172E · Gladewater, TXThe pilot's failure to maintain an airspeed above stall speed, resulting in an inadvertent stall. A factor was the pilot's performance of an abrupt maneuver immediately after takeoff.Mar 27, 1995 · N1438Z · DestroyedNTSB CHI95LA111Accident · Minor injuriesLimited investigationFinal reportBaker Long EZE · Salina, KSfailure of the engine driven fuel pump. Factors associated with the accident were fuel starvation, insufficient altitude and soft terrain.Mar 27, 1995 · N3223P · Substantial damageNTSB BFO95LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean City, NJthe private pilot's inadequate compensation for the wind conditions during the landing/aborted landing sequence. Related factors are the unfavorable wind conditions and high obstructions.Mar 26, 1995 · N6131W · Substantial damageNTSB BFO95LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Oakland, MDthe student pilot's abrupt remedial action during the aborted landing attempt. Related factors are the student pilot's lack of total experience, inadequate airspeed and the low altitude.Mar 26, 1995 · N757JQ · DestroyedNTSB ANC95LA039Accident · No injuriesLimited investigationFinal reportHelio H700 · Deadhorse, AKAn overload failure of the right main gear retention/limit cable bracket bolts and installation of non-standard bolt hardware by other maintenance personnel. The pilot's failure to abort the takeoff was a factor in the accident.Mar 26, 1995 · N4059H · Substantial damageNTSB SEA95LA071Accident · No injuriesLimited investigationFinal reportCessna 172D · Lake Oswego, ORThe pilot's improper touchdown on the surface of the water.Mar 25, 1995 · N6600T · Substantial damageNTSB NYC95LA078Accident · Serious injuriesLimited investigationFinal reportBeech 1900C · Covington, KYa lack of procedures by the tug operator to prevent inadvertent movement of an unoccupied tug, which resulted in an airplane being struck by an unoccupied tug which moved on its own.Mar 25, 1995 · N34010 · Substantial damageNTSB LAX95FA145Accident · Minor injuriesField investigationFinal reportLuscombe 8E · Compton, CAThe pilot's poor preflight inspection, the mechanic's poor annual inspection, and the leaking fuel caps which allowed water to contaminate the fuel.Mar 25, 1995 · N2232K · DestroyedNTSB LAX95FA144Accident · 1 fatalField investigationFinal reportCessna 310Q · Kahului, Maui, HIthe pilot's failure to maintain an adequate terrain clearance altitude while flying in a mountainous area at night.Mar 25, 1995 · N7705Q · DestroyedNTSB FTW95LA146Accident · No injuriesLimited investigationFinal reportHughes 369HS · Burnet, TXFailure by the pilot-in-command to maintain rotor RPM during the autorotation and his delayed flare. A factor was: the pilot's failure to use the fuel boost pump while using aviation gasoline vice jet fuel.Mar 25, 1995 · N3961H · Substantial damageNTSB BFO95LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Zanesville, OHthe pilot's failure to maintain control of the airplane while taxiing after landing. Related factors were the unfavorable (gusty) wind condition, and the pilot's improper compensation for wind conditions.Mar 25, 1995 · N45631 · Substantial damageNTSB ATL95LA073Accident · No injuriesLimited investigationFinal reportCessna 150M · Fuquay-Varina, NCThe certified flight instructor's failure to complete the takeoff checklist which resulted in an attempted takeoff with the wing flaps extended.Mar 25, 1995 · N9345U · Substantial damageNTSB ANC95LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKA failure of the instructor pilot to adequately supervise the student pilot's landing approach. The student pilot's failure to maintain a proper altitude and distance to the runway touch-down point, and a snow berm at the approach end of the runway were…Mar 25, 1995 · N67563 · Substantial damageNTSB NYC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot's failure to maintain directional control and the instructor's inadequate supervision. Related factors: high winds, and a crosswind.Mar 24, 1995 · N66010 · Substantial damageNTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.Mar 24, 1995 · N23680 · Substantial damageNTSB LAX95FA148Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Toms Place, CAthe pilot's decisions to initially attempt and then continue flight into known forecast and observed adverse weather. Factors in the accident were: the pilot's inadequate preflight planning and his use of a drug.Mar 24, 1995 · N15LT · DestroyedNTSB CHI95LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Table Rock, NEthe pilot's failure to maintain directional control during an aborted takeoff. Factors related to the accident were the crosswind conditions and the berm which the airplane contacted.Mar 24, 1995 · N5771G · Substantial damageNTSB ATL95LA071Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Dauphin Island, ALThe pilot's improper use of the rudder control which resulted in a stall, and improper use of the elevator control, in that he maintained back pressure after the stall entry, keeping the airplane in a stalled conditions.Mar 24, 1995 · N83796 · Substantial damageNTSB ATL95LA070Accident · No injuriesLimited investigationFinal reportRoggio Rotorway Executive · Toccoa, GAThe pilot's failure to use carburetor heat which resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.Mar 24, 1995 · N34WR · Substantial damageNTSB MIA95WA093Accident · No injuriesForeign investigationBeech E18S · Walkers Cay, BahamasMar 23, 1995 · N8111 · Substantial damageNTSB MIA95LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Boynton Beach, FLThe failure of the pilot-in-command to obtain the proper touchdown point and his failure to flare properly.Mar 23, 1995 · N4546L · Substantial damageNTSB FTW95LA145Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Gillett, ARThe engine main rod bearing seized to the crankshaft due to worn master rod metal pieces blocking the oil passages. A factor was an engine overhaul was not performed by company maintenance personnel.Mar 23, 1995 · N5561X · Substantial damageNTSB ATL95LA069Accident · Minor injuriesLimited investigationFinal reportAerotek Zuni · Morganton, NCThe pilot's poorly planned approach which resulted in the loss of control of the aircraft because of gusty wind conditions.Mar 23, 1995 · N19PF · Substantial damageNTSB LAX95FA141Accident · 1 fatalField investigationFinal reportCessna 208B · Reno, NVthe pilot's failure to comply with published instrument approach procedures by a premature descent below the minimum altitude specified for the approach.Mar 22, 1995 · N9417B · DestroyedNTSB MIA95LA092Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Opa Locka, FLCollapse of the tailwheel gear assembly, due to improper installation of a nut by maintenance personnel.Mar 21, 1995 · N2923B · Substantial damageNTSB MIA95LA091Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fort Lauderdale, FLThe pilot-in-command's improper landing touchdown and improper recovery from a bounced landing.Mar 21, 1995 · N759LH · Substantial damageNTSB LAX95LA146Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)the loss of tail rotor control for undetermined reasons.Mar 21, 1995 · N2223P · DestroyedNTSB FTW95LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gail, TXThe pilot's failure to maintain flying airspeed resulting in an inadvertent stall at low altitude. Factors were gusty winds and inadequate altitude for maneuvering.Mar 21, 1995 · N99MP · DestroyedNTSB CHI95LA106Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Meade, KSthe pilot's not obtaining/maintaining clearance with the utility pole. A factor was the utility pole.Mar 21, 1995 · N5237S · DestroyedNTSB FTW95LA144Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Edgewood, NMThe flight's encounter with a downdraft. The lack of a suitable landing area was a factor.Mar 20, 1995 · N51947 · Substantial damageNTSB FTW95LA142Accident · Minor injuriesLimited investigationFinal reportRyan Aeronautical ST3-KR · Blue Ridge, TXThe loss of engine power for undetermined reason. A factor was the lack of suitable terrain for the forced landing.Mar 20, 1995 · N54430 · Substantial damageNTSB ATL95LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-60 · Linden, TNThe pilot's failure to attain a proper touchdown point resulting in the aircraft overrunning the runway. Gusty weather conditions and the wet runway were also contributing factors.Mar 20, 1995 · N163GA · Substantial damageNTSB ANC95LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe pilot's failure to correct for torque/p factor. The presence of snowberms that narrowed the width of the runway and the pilot's lack of total experience were factors in the accident.Mar 20, 1995 · N733RW · Substantial damageNTSB ANC95LA036Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's continued VFR flight into IMC conditions and a failure to maintain altitude. A factor in the accident was 'whiteout' weather conditions.Mar 20, 1995 · N1719U · Substantial damageNTSB NYC95LA077Accident · No injuriesLimited investigationFinal reportCessna 150J · Slatington, PAThe pilot's improper use of carburetor heat which resulted in carburetor icing and a subsequent loss of engine power. A factor is carburetor icing conditions.Mar 19, 1995 · N60949 · Substantial damageNTSB LAX95LA140Accident · No injuriesLimited investigationFinal reportCessna 182RG · Prescott, AZthe failure of the pilot to extend the landing gear prior to landing. The failure of the pilot to use a before landing checklist was a factor in this accident.Mar 19, 1995 · N9968C · Substantial damageNTSB LAX95LA139Accident · No injuriesLimited investigationFinal reportEnstrom F28C-2 · San Gorgonio, CAthe pilot's selection of an inadequate terrain clearance altitude while overflying mountainous terrain.Mar 19, 1995 · N5693W · Destroyed