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 ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.May 28, 1995 · N401W · Substantial damageNTSB SEA95LA107Accident · No injuriesLimited investigationFinal reportCessna 172B · Sinclair Island, WAThe pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.May 27, 1995 · N7996X · Substantial damageNTSB NYC95LA126Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Fairfield, NJThe student pilot's failure to maintain control of the helicopter. The student's lack of experience in the type of operation (solo flight) was a related factor.May 27, 1995 · N8541E · Substantial damageNTSB NYC95LA122Accident · 2 fatalLimited investigationFinal reportCessna 172N · Weston, WVthe pilot's failure to maintain airspeed which resulted in an inadvertent stall, and a subsequent uncontrolled descent and collision with the ground.May 27, 1995 · N5085G · DestroyedNTSB MIA95LA137Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Homestead, FLBinding (mechanical) of the right elevator with the right horizontal stabilizer after collision with a dog at the right horizontal stabilizer during rotation. The deformation of the stabilizer reduced the pilot-in-commmand's ability to operate the elevator.May 27, 1995 · N6167Y · Substantial damageNTSB LAX95LA196Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Montague, CAthe pilot's failure to properly connect the aileron/flaperon quick disconnect fitting during assembly of the glider, and his inadequate preflight inspection.May 27, 1995 · N64UW · Substantial damageNTSB FTW95LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-180 · Westcliffe, COThe loss of control due to the encounter with the dust devil.May 27, 1995 · N7808Z · Substantial damageNTSB CHI95LA164Accident · No injuriesLimited investigationFinal reportCessna 337B · Lemmon, SDthe pilot's failure to maintain directional control of the airplane during the landing roll.May 27, 1995 · N2385S · Substantial damageNTSB NYC95WA234Accident · Serious injuriesForeign investigationde Havilland DHC-2 · Biscarrosse, FranceMay 26, 1995 · N67672 · Substantial damageNTSB LAX95LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Boonville, CAa loss of engine power for undetermined reasons.May 26, 1995 · N5255F · Substantial damageNTSB ANC95LA059Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe failure of the pilot-in-command to identify unsafe snow conditions at the site. A factor associated with the accident is the soft snow in the takeoff area.May 26, 1995 · N1047F · Substantial damageNTSB NYC95FA123Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Wise, VAThe failure of the pilot to maintain airspeed, after the right engine lost power, which resulted in an uncontrolled descent and collision with the ground.May 25, 1995 · N9672Y · DestroyedNTSB MIA95LA136Accident · No injuriesLimited investigationFinal reportCessna A150L · Miami, FLThe dual student's improper use of the rudder following a left swerve during landing rollout which prevented the flight instructor from regaining directional control.May 25, 1995 · N6188F · Substantial damageNTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.May 25, 1995 · N6774K · Substantial damageNTSB FTW95LA219Accident · Minor injuriesLimited investigationFinal reportHispano Aviacion HB-200 · Fort Worth, TXThe failure of the hydraulic actuator for the right main landing gear. A factor was the false landing gear indications provided by the landing gear indicating system.May 25, 1995 · N212AM · Substantial damageNTSB CHI95LA168Accident · No injuriesLimited investigationFinal reportCessna 180D · Eveleth, MNthe pilot's improper setting of the flaps to the 30 degree position and an excessive descent rate during the landing.May 25, 1995 · N8611X · Substantial damageNTSB ATL95FA099Accident · 2 fatalField investigationFinal reportSchlagenhauf Lancair IV · Gastonia, NCAn in-flight fire of undetermined origin that resulted in a loss of control and impact with the ground.May 25, 1995 · N453A · DestroyedNTSB ANC95LA058Accident · No injuriesLimited investigationFinal reportCessna 206 · Bethel, AKA failure of the #2 main engine bearing and subsequent fatigue failure of the engine crankshaft. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.May 25, 1995 · N19BR · Substantial damageNTSB SEA95LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Grangeville, IDThe failure of the pilot to adequately recover from a bounced landing, and his failure to maintain directional control of the airplane during the landing roll. A factor contributing to the accident was a ditch.May 24, 1995 · N1LF · Substantial damageNTSB SEA95LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe student pilot's failure to maintain directional control while hovering, which resulted in the aircraft colliding with terrain. Contributing to the accident were gusting wind conditions.May 24, 1995 · N461H · Substantial damageNTSB NYC95LA124Accident · 1 fatalLimited investigationFinal reportBailey Quickie Q-2 · Woodsfield, OHThe loss engine power for undetermined reason and the pilot's failure to maintain control which resulted in an inflight collision with terrain.May 24, 1995 · N29BD · DestroyedNTSB NYC95LA120Accident · No injuriesLimited investigationFinal reportCessna 177B · Allentown, PAthe pilot misjudged the flare, resulting in a hard, bounced landing and impact with the runway. A factor in this accident was an improper recovery from a bounced landing.May 24, 1995 · N621PW · Substantial damageNTSB MIA95LA135Accident · No injuriesLimited investigationFinal reportBoeing 727-232 · West Palm Beach, FLThe failure of the ground pushback crew to follow delta airlines pushback procedures and place a signalman forward of the aircraft in view of the captain during pushback. This resulted in the captain not being aware that the tug tow bar had disconnected and…May 24, 1995 · N489DA · Substantial damageNTSB CHI95LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Clark, SDthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's excessive braking.May 24, 1995 · N4353S · Substantial damageNTSB ATL95LA098Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Castleberry, ALFailure of the pilot to apply carburetor heat in a timely manner, resulting in the loss of engine power. A factor was the rough terrain at the forced landing site.May 24, 1995 · N8983T · Substantial damageNTSB NYC95LA121Accident · No injuriesLimited investigationFinal reportCessna 182E · Frederick, PAThe pilot's inadequate inflight planning by failing to verify the wind direction for landing. Also causal is the pilot's failure to obtain the proper touch down point and to do a go-around.May 23, 1995 · N3168Y · Substantial damageNTSB LAX95LA194Accident · Serious injuriesLimited investigationFinal reportAero Commander 500S · Santa Barbara, CAthe inadequate visual lookout by both pilots and their failures to maintain adequate separation from each other while taxiing in a non-movement area.May 23, 1995 · N9076N · 2 aircraft · Substantial damageNTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.May 23, 1995 · N48538 · Substantial damageNTSB FTW95LA216Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe failure of the right outboard tire for undetermined reason.May 23, 1995 · N450MC · Substantial damageNTSB CHI95LA234Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INreason for the occurrence was undetermined.May 23, 1995 · N6092Y · Substantial damageNTSB NYC95LA125Accident · 1 fatalLimited investigationFinal reportCessna 310Q · Atlantic Ocean (Atlantic Ocean)the pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and subsequent ditching at sea. Darkness and the high sea condition (rough water) were related factors.May 22, 1995 · N69786 · DestroyedNTSB FTW95LA214Accident · Serious injuriesLimited investigationFinal reportCessna 172H · San Ignacio, NMThe pilot flying at an inadequate altitude to clear surrounding terrain. Factors were: high mountainous terrain and high density altitude.May 22, 1995 · N2840L · Substantial damageNTSB ANC95LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Hope, AKThe pilot's failure to adequately compensate for wind conditions. Factors associated with the accident are the trees bordering the runway, and a downdraft.May 22, 1995 · N91248 · Substantial damageNTSB NYC95LA119Accident · Minor injuriesLimited investigationFinal reportErwin Taylor Mono Plane · Freeport, PAthe pilot's improper decision to initiate a takeoff on an uphill runway with high grass, which resulted in a premature lift off, and an inadvertent stall/mush into trees.May 21, 1995 · N6155Z · Substantial damageNTSB MIA95LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Zellwood, FLA loss of aircraft climb capability after the banner pickup for an undetermined reason. A factor related to the accident was: soft terrain in the emergency landing area.May 21, 1995 · N35RA · Substantial damageNTSB LAX95LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Redding, CAthe pilot's improper use of the flight controls. The downward-sloping terrain and the intermittent gusty wind conditions were factors in this accident.May 21, 1995 · N8363Q · Substantial damageNTSB LAX95LA190Accident · 3 fatalLimited investigationFinal reportStol UC-1 · Saipan, Sarkan inflight collision with the ocean for undetermined reasons.May 21, 1995 · N108CA · DestroyedNTSB FTW95LA210Accident · No injuriesLimited investigationFinal reportCessna 175 · Malvern, ARThe pilot's failure to maintain directional control. A factor was the pilot's lack of recent experience.May 21, 1995 · N7152M · Substantial damageNTSB FTW95LA209Accident · No injuriesLimited investigationFinal reportPurdy HP-18 · Hempstead, TXThe pilot's poor in flight planning/decision. The lack of thermal lift was a factor.May 21, 1995 · N15DP · Substantial damageNTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.May 21, 1995 · N8872V · 2 aircraft · DestroyedNTSB FTW95FA206Accident · 2 fatalField investigationFinal reportNorth American T-6G · Beaumont, TXThe pilot's failure to perform a go-around and his failure to maintain airspeed. Factors in the accident were improper runway alignment and an aft center of gravity.May 21, 1995 · N2449 · DestroyedNTSB ANC95FA056Accident · 1 fatalField investigationFinal reportCessna 150 · Wasilla, AKThe student pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain clearance (or altitude) from the mountainous terrain.May 21, 1995 · N9GZ · DestroyedNTSB SEA95LA104Accident · No injuriesLimited investigationFinal reportBeech 77 · New Meadows, IDA partial loss of engine power after takeoff for undetermined reasons.May 20, 1995 · N3850J · Substantial damageNTSB SEA95FA103Accident · 2 fatalField investigationFinal reportCessna 177RG · Kent, WAThe pilot's misjudgment of distance and altitude during the approach. Factors in the accident were the dusk light condition and the shadows.May 20, 1995 · N9ER · DestroyedNTSB NYC95LA118Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Moscow, PAThe pilot's inadequate compensation for a cross wind and his failure to maintain adequate obstacle clearance. A factor is the crosswind.May 20, 1995 · N46181 · Substantial damageNTSB NYC95LA116Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Taunton, MAthe failure of the pilot to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, and a forced landing in rough terrain.May 20, 1995 · N4285K · Substantial damageNTSB NYC95LA115Accident · 1 fatalLimited investigationFinal reportPitcher W-8 · Mineral, VAan electrical system problem that resulted in a blown (failed) fuze and an inoperative electric fuel pump, which in turn resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed which resulted in an…May 20, 1995 · N13PE · DestroyedNTSB NYC95IA114Incident · No injuriesIncident investigationFinal reportBoeing 767-383ER · Newark, NJthe pilot of the B-767, LNRCK, misjudged clearance between his airplane and the B-737, N13624, resulting in an on-ground collision.May 20, 1995 · LNRCK · 2 aircraft · Minor damageNTSB MIA95LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350B · Tampa, FLThe failure of the pilot to follow manufacturers procedures after failure of the hydraulic system resulting in loss of control of the helicopter. Contributing to the accident was the failure of maintenance personnel to follow manufacturers procedures for…May 20, 1995 · N35AH · Substantial damageNTSB LAX95LA197Accident · No injuriesLimited investigationFinal reportBölkow Phoebus C · Helendale, CAthe pilot's selection of a downwind landing and his failure to attain the proper touchdown point. Factors in the accident were the inaccurate wind information provided by his ground crew which led the pilot to select the improper landing direction, and, the…May 20, 1995 · N1379 · Substantial damage