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 MIA95RA162Accident · 2 fatalForeign investigationConvair CV-440 · La Ramona, Dominican RepublicJun 27, 1995 · N356SANTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.Jun 27, 1995 · N2362N · Substantial damageNTSB MIA95LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · New Port Richey, FLThe pilot landed on the wrong runway. The tailwind contributed to the loss of directional control.Jun 27, 1995 · N69140 · Substantial damageNTSB MIA95LA163Accident · No injuriesLimited investigationFinal reportBeech A36 · Titusville, FLfailure of the No. 6 cylinder barrel due to corrosion fatigue, which resulted in a loss of power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Jun 27, 1995 · N72016 · Substantial damageNTSB MIA95LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe failure of the pilot-in-command [CFI] to use carburetor heat during reduced power descent.Jun 27, 1995 · N25406 · Substantial damageNTSB FTW95LA264Accident · No injuriesLimited investigationFinal reportCessna 404 · Alamosa, COFBO personnel improperly serviced the aircraft with jet fuel. A factor was the lack of suitable terrain for a forced landing.Jun 27, 1995 · N36998 · Substantial damageNTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.Jun 27, 1995 · N8685H · Substantial damageNTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.Jun 27, 1995 · N1349A · Substantial damageNTSB CHI95IA204Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Green Bay, WIthe weather condition (turbulence in clouds). A factor was the flight crew's abrupt control of the airplane.Jun 27, 1995 · N131AA · No damageNTSB BFO95FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Cohocton, NYthe pilot's failure to maintain control of the airplane during a turn which led to an inadvertent stall/spin. Related factors were the low ceiling, and the non-instrument rated pilot's flight into known adverse weather.Jun 27, 1995 · N15124 · DestroyedNTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.Jun 27, 1995 · N5523B · Substantial damageNTSB ATL95LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Summerville, SCThe disconnected carburetor mixture control linkage that resulted in a loss of engine power, and the subsequent collision with trees.Jun 27, 1995 · N16345 · Substantial damageNTSB ANC95LA085Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta Junction, AKThe pilot's improper compensation for the wind conditions which resulted in dragging the right wing and shearing off the nose gear.Jun 27, 1995 · N4804E · Substantial damageNTSB SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.Jun 26, 1995 · N5460B · Substantial damageNTSB MIA95TA159Accident · Serious injuriesFinal reportRobinson R22 · Windemere, FLThe inadequate preflight inspection by the pilot-in-command in that he failed to drain all the water from the fuel system, resulting in an total loss of power. Contributing to the accident was the unsuitable terrain encountered by the pilot during the…Jun 26, 1995 · N869BD · Substantial damageNTSB MIA95LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Rosewood, FLThe failure of the pilot-in-command to maintain speed and distance on final approach resulting in an overrun and collision with trees. A contributing factor was the failure of the pilot to obtain an adequate weather briefing prior to flight.Jun 26, 1995 · N6116J · Substantial damageNTSB MIA95LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Brooksville, FLA loss of engine power after takeoff for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.Jun 26, 1995 · N3431W · DestroyedNTSB LAX95LA224Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chandler, AZFuel exhaustion resulting from the pilot's failure to determine the amount of fuel onboard at departure. The reduced ambient lighting was a factor in this accident.Jun 26, 1995 · N2362C · Substantial damageNTSB LAX95LA223Accident · No injuriesLimited investigationFinal reportCessna 182P · Susanville, CAthe pilot's failure to maintain directional control of the aircraft during the landing roll.Jun 26, 1995 · N9148M · Substantial damageNTSB LAX95FA225Accident · Serious injuriesField investigationFinal reportHughes 369D · Highland, CAthe pilot's failure to verify the security of his passenger's cargo/personal belongings which departed the aircraft striking the tailrotor.Jun 26, 1995 · N1089N · Substantial damageNTSB FTW95LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Mimbres, NMInadequate preflight planning and the selection of unsuitable terrain for takeoff by the pilot-in-command.Jun 26, 1995 · N3032R · Substantial damageNTSB FTW95FA259Accident · 2 fatalField investigationFinal reportCessna 152 · Ben Wheeler, TXThe pilot's intentional low level flying and not maintaining a clearance from the trees. A factor was the pilot exceeded the maximum allowable gross weight of the airplane.Jun 26, 1995 · N4963H · DestroyedNTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.Jun 25, 1995 · N66727 · Substantial damageNTSB SEA95LA130Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Challis, IDThe pilot's failure to maintain an adequate supply of fuel for the flight. The terrain condition was a factor.Jun 25, 1995 · N9768Y · DestroyedNTSB SEA95LA129Accident · Minor injuriesLimited investigationFinal reportSagerser Rotorway Executive · Enumclaw, WAA power surge for undetermined reasons, and the pilot's misjudgement of distance and altitude during the autorotation.Jun 25, 1995 · N336CS · Substantial damageNTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…Jun 25, 1995 · N719JX · DestroyedNTSB MIA95IA157Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-103 · Atlantic Ocean (Atlantic Ocean)Failure of the passengers and flight attendants to comply with the flightcrew's instruction to fasten their seatbelts.Jun 25, 1995 · N13983 · No damageNTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.Jun 25, 1995 · N3737B · Substantial damageNTSB BFO95LA072Accident · No injuriesLimited investigationFinal reportKolb Twinstar · Abingdon, VAThe loss of engine power due to undetermined reasons. Factors found to be involved in this accident were the condition inspection was overdue and the inadequate training received by the student pilot owner/builder.Jun 25, 1995 · N7165L · DestroyedNTSB ANC95LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anaktuvuk, AKThe pilot's inadvertent flight into instrument meteorological conditions. Factors relating to the accident were: the pilot's inadequate weather evaluation, and the weather and terrain conditions.Jun 25, 1995 · N4278Q · Substantial damageNTSB ANC95FA086Accident · 4 fatalField investigationFinal reportPiper PA-31 · Valdez, AKThe pilot's failure to follow the published IFR (missed approach) procedure and assure adequate altitude/clearance from mountainous terrain.Jun 25, 1995 · N62851 · DestroyedNTSB SEA95LA126Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAThe failure of company maintenance personnel to perform adequate inspections of the helicopter, and the failure of the cyclic control rod due to corrosion.Jun 24, 1995 · N1968H · Substantial damageNTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.Jun 24, 1995 · N88856 · Substantial damageNTSB MIA95LA156Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Atlantic Ocean (Atlantic Ocean)Loss of engine power for an undetermined reason(s).Jun 24, 1995 · N57880 · DestroyedNTSB LAX95LA230Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Avalon, CAcomplete brake failure due to improper replacement and service of the brakes by company maintenance personnel.Jun 24, 1995 · N56484 · Substantial damageNTSB LAX95LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palm Springs, CAthe failure of the pilot to maintain clearance from a fence post while taxiing.Jun 24, 1995 · N6911P · Substantial damageNTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.Jun 24, 1995 · N5424H · No damageNTSB CHI95LA203Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Hampshire, ILthe pilot's failure to attain liftoff speed. A factor in the accident was the ditch.Jun 24, 1995 · N2086K · Substantial damageNTSB CHI95LA201Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Cameron, MOThe pilot misjudged the flare and improper recovery from a bounced landing.Jun 24, 1995 · N84FB · Substantial damageNTSB CHI95LA199Accident · No injuriesLimited investigationFinal reportCessna 310L · Crawfordsville, INthe pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.Jun 24, 1995 · N3298X · Substantial damageNTSB CHI95LA197Accident · Minor injuriesLimited investigationFinal reportGriner Bushby Mustang I · Shelbyville, INthe pilot's allowing the airplane to inadvertently liftoff. A factor was a malfunction of the flight control system.Jun 24, 1995 · N30878 · Substantial damageNTSB CHI95FA200Accident · 1 fatalField investigationFinal reportCocchi Lancair 320 · Marengo, ILpilot incapacitation due to cardiac arrhythmia (heart attack).Jun 24, 1995 · N3118J · DestroyedNTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.Jun 24, 1995 · N1284S · DestroyedNTSB ATL95LA118Accident · No injuriesLimited investigationFinal reportPiper J3 · York, SCThe loss of engine power for undetermined reasons.Jun 24, 1995 · N41105 · Substantial damageNTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.Jun 24, 1995 · N84468 · Substantial damageNTSB SEA95LA125Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Monroe, WAThe pilot's failure to maintain airspeed.Jun 23, 1995 · N2790X · Substantial damageNTSB NYC95WA146Incident · No injuriesForeign investigationCessna 182 · Grenchen, SwitzerlandJun 23, 1995 · N7369X · Minor damageNTSB MIA95FA155Accident · Serious injuriesField investigationFinal reportCessna 402A · Miami, FLThe pilot-in-command's failure to maintain airspeed (VMC) after loss of power of one engine while on final approach, resulting in an in-flight loss of control and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of…Jun 23, 1995 · N7884J · DestroyedNTSB MIA95FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Orlando, FLThe failure of the pilot-in-command to insure the landing gear was retracted following loss of power in one engine resulting in the aircraft being unable to climb and clear trees in the aircraft's flight path.Jun 23, 1995 · N4403Q · DestroyedNTSB LAX95LA222Accident · No injuriesLimited investigationFinal reportSpreuer Cozy · Oceanside, CAThe pilot's premature rotation of the aircraft and failure to attain the proper liftoff airspeed.Jun 23, 1995 · N84CZ · Destroyed