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 SEA92FA140Accident · 1 fatalField investigationFinal reportBeech A36TC · Ballantine, MTThe pilot-in-command's physical impairment and his continued VFR flight into instrument meteorological conditions. Factors relating to the accident were: the weather conditions and the hilly terrain.Jun 29, 1992 · N3696R · DestroyedNTSB NYC92LA135Accident · No injuriesLimited investigationFinal reportPiper J3 · Waynesville, OHThe pilot's failure to maintain control of the airplane on the ground due to his lack of experience in type of aircraft. This resulted in an unsuccessful aborted takeoff, the airplane veering off the runway and nosing over. A factor in this accident was the…Jun 29, 1992 · N92483 · Substantial damageNTSB NYC92LA134Accident · No injuriesLimited investigationFinal reportCessna 150L · Bethel Park, PAThe failure of the pilot to determine the fuel quantity prior to departure, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain. Factors related to the accident were an improperly reading right fuel gauge, and an improperly adjusted…Jun 29, 1992 · N6849G · Substantial damageNTSB NYC92FA133Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasant Mount, PAThe pilot's decision to perform low altitude maneuvers, resulting in a loss of airplane control and collision with trees. Factors related to the accident were the ostentatious display by the pilot, and his lack of total flight experience.Jun 29, 1992 · N757QN · DestroyedNTSB LAX92LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Brawley, CAFuel starvation due to the pilot's; 1) failure to refuel the aircraft, 2) improper use of the fuel system, and 3) his delayed positioning of the fuel selector valve to a tank containing fuel. A factor in the accident was the pilot's failure to adhere to the…Jun 29, 1992 · N1794W · Substantial damageNTSB LAX92LA266Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Coalinga, CAThe failure of the pilot to maintain the proper glide path during the night VFR approach which resulted in a landing undershoot and a subsequent collision with the raised asphalt lip of the runway edge.Jun 29, 1992 · N4065R · Substantial damageNTSB LAX92FA267Accident · 2 fatalField investigationFinal reportRobinson R22 · Richmond, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason(s) which resulted in rotor contact to the tailboom.Jun 29, 1992 · N83858 · DestroyedNTSB FTW92DRA02Accident · 2 fatalFinal reportJimi Youngblood Rans Coyote II · Bryan, TXThe pilot's inadvertent stall of the airplane.Jun 29, 1992 · N12CY · DestroyedNTSB DEN92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Glade Park, COThe pilot delayed initiation of the go around. A factor was: high density altitude.Jun 29, 1992 · N1874A · Substantial damageNTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.Jun 29, 1992 · N910WT · Substantial damageNTSB ATL92LA132Accident · 1 fatalLimited investigationFinal reportBell 206B · Bessemer, ALThe pilots failure to maintain clearance from wires.Jun 29, 1992 · N2636X · DestroyedNTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.Jun 28, 1992 · N30843 · DestroyedNTSB NYC92LA131Accident · No injuriesLimited investigationFinal reportPitts S1S · Hornell, NYThe misjudged landing by the pilot and his subsequent improper recovery from a bounced landing, which resulted in a loss of airplane control.Jun 28, 1992 · N8025 · Substantial damageNTSB NYC92IA129Incident · No injuriesIncident investigationFinal reportBoeing 767-231ER · Jamica, NYThe failure of the fifth stage low pressure turbine vanes due to fatigue.Jun 28, 1992 · N602TW · Minor damageNTSB NYC92FIG01Accident · 1 fatalFinal reportTierra II · Williamsport, MDThe pilot's alcoholic impairment of efficiency and judgement resulting in a loss of control of the airplane during a forced landing following a power loss for an undetermined reason.Jun 28, 1992 · N531PJ · DestroyedNTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.Jun 28, 1992 · N59LD · DestroyedNTSB LAX92LA264Accident · Serious injuriesLimited investigationFinal reportDanny W. Sadek S-12 · Big Bear, CAThe pilot's failure to maintain an adequate airspeed and the inadvertent entry into a stall/mush condition. Factors in the accident were the high density altitude condition and the pilots limited total experience.Jun 28, 1992 · N512 · DestroyedNTSB DEN92IA067Incident · No injuriesIncident investigationFinal reportBell 222UT · Scipio, UTAn encounter with clear air turbulence.Jun 28, 1992 · N222UH · Minor damageNTSB CHI92LA192Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Erie, ILThe pilot's failure to maintain a proper glidepath.Jun 28, 1992 · N3195T · Substantial damageNTSB CHI92LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · East Tawas, MIThe pilot's failure to adequately compensate for the wind conditions and failure to properly flare the airplane. Contributing to the accident was the crosswind condition.Jun 28, 1992 · N714WT · Substantial damageNTSB CHI92DCA03Accident · 1 fatalFinal reportPiper PA-28-180 · Mokane, MOAn inadequate visual lookout by the pilot and his failure to maintain clearance from the wires.Jun 28, 1992 · N5175L · DestroyedNTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.Jun 28, 1992 · N43364 · Substantial damageNTSB SEA92LA138Accident · Minor injuriesLimited investigationFinal reportNavion H · Gillette, WYAn engine power loss due to the collapse of the induction air ducting, inadequate maintenance, and improper approval of the modification.Jun 27, 1992 · N2550T · Substantial damageNTSB DEN92LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Mckinney, TXThe student pilot misjudged his landing and landed short of the runway. A factor was: lack of total experience on the part of the student pilot.Jun 27, 1992 · N47354 · Substantial damageNTSB CHI92LA193Accident · No injuriesLimited investigationFinal reportBell 47-2A-1 · Dubuque, IAThe pilot's failure to maintain both directional control of the helicopter and clearance from the truck.Jun 27, 1992 · N73952 · Substantial damageNTSB CHI92LA190Accident · No injuriesLimited investigationFinal reportPitts S2B · Aurora, NEThe pilot-in-command's restricted visual lookout from smoke entering the cockpit. Factors were smoke in the cockpit which resulted in the pilot becoming disoriented.Jun 27, 1992 · N92BT · DestroyedNTSB CHI92DER01Accident · Serious injuriesFinal reportGoehring Quickie · So. St. Paul, MNA loss of engine power due to carburetor ice. The lack of suitable terrain for the forced landing was a factor.Jun 27, 1992 · N533C · Substantial damageNTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.Jun 27, 1992 · N8198L · Substantial damageNTSB SEA92LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mckinnon, WYWater in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.Jun 26, 1992 · N6089A · DestroyedNTSB SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.Jun 26, 1992 · N2724Q · DestroyedNTSB NYC92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Durhamville, NYThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. Factor related to the accident was the pilot misjudged the flare/touchdown.Jun 26, 1992 · N69005 · Substantial damageNTSB MIA92FA142Accident · 1 fatalField investigationFinal reportHughes 369HS · Labelle, FLThe pilot-in-command's improper application of collective pitch during an autorotative landing resulting in insufficient rotor RPM and in-flight collision with trees and the terrain. Contributing to the accident was the total loss of engine power due to fuel…Jun 26, 1992 · N9089F · DestroyedNTSB LAX92LA265Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe student pilot's misjudging the landing flare, the cfi's delayed remedial action and his failure to adequately supervise the conduct of the flight.Jun 26, 1992 · N9447E · Substantial damageNTSB LAX92LA263Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Prescott, AZThe airplane's failure to achieve an adequate rate of climb because of degraded aerodynamic performance and the pilot's intentional operation of the aircraft with known deficiencies. A factor in the accident was the high density altitude condition.Jun 26, 1992 · N601DE · Substantial damageNTSB ANC92T#A05Accident · No injuriesClass 3Final reportPiper PA-18-160 · Cold Bay, AKJun 26, 1992 · N745 · Substantial damageNTSB ANC92IA100Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Dillingham, AKThe pilot in command's failure to maintain a visual lookout. Factors were the drizzle and fog and the impossibility of updating the recorded weather information by ATC personnel.Jun 26, 1992 · N620PA · 2 aircraft · No damageNTSB ANC92IA097Incident · No injuriesIncident investigationFinal reportCessna 150 · Anchorage, AKThe driver of the other vehicle not following procedures and directives and colliding with the airplane.Jun 26, 1992 · N66281 · Minor damageNTSB SEA92LA134Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ronan, MTThe pilot's operation with known deficiencies in equipment and erratic operation of the fuel control system. A factor contributing to the accident was: soft terrain.Jun 25, 1992 · N4690C · Substantial damageNTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.Jun 25, 1992 · N88522 · Substantial damageNTSB NYC92LA128Accident · No injuriesLimited investigationFinal reportFairchild SA-227AC · Boston, MAThe loss of airplane control during a crosswind landing resulting in a hard bounced landing and a collision with the runway.Jun 25, 1992 · N2691W · Substantial damageNTSB NYC92LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lancaster, PAThe failure of the left engine turbochargers bearings, which resulted in a loss of power and subsequent degradation of climb performance.Jun 25, 1992 · N700MM · DestroyedNTSB NYC92LA109Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAThe student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…Jun 25, 1992 · N1793Q · Substantial damageNTSB MIA92T#A01Accident · No injuriesClass 3Final reportContinental Copters Tomcat MK6B · Punta Gorda, FLJun 25, 1992 · N17H · Substantial damageNTSB FTW92FA169Accident · 1 fatalField investigationFinal reportRockwell 690B · Konawa, OKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent spiral and subsequent rapid descent. The design stress limits of the airframe were exceeded resulting in an overload failure of the empennage. Factors related to the…Jun 25, 1992 · N690JC · DestroyedNTSB DEN92FA064Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Alamagordo, NMThe failure of the pilot to exercise adequate VFR departure terrain avoidance procedures, and the failure of the controller to issue a safety alert to the pilot. Factors which contributed to the accident were: the pilot's lack of familiarity with the…Jun 25, 1992 · N108SC · DestroyedNTSB CHI92LA189Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Oxford, IAWas the pilot's failure to maintain directional control of the airplane during the landing. Factors related to the accident were the pilot's lack of experience in tail wheel airplanes and the gusty wind conditions.Jun 25, 1992 · N1652G · Substantial damageNTSB CHI92LA186Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Napoleon, MIAn inadvertent stall on takeoff.Jun 25, 1992 · N2888X · Substantial damageNTSB CHI92FA188Accident · Minor injuriesField investigationFinal reportBeech 24R · Oak Creek, WIA result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.Jun 25, 1992 · N2195W · DestroyedNTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.Jun 25, 1992 · N500ZZ · Substantial damageNTSB ATL92LA131Accident · No injuriesLimited investigationFinal reportBell 47D1 · Centre, ALThe pilot's inadequate visual lookout, resulting in a collision with a wire.Jun 25, 1992 · N68632 · Substantial damage