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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW95LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-180 · Westcliffe, COThe loss of control due to the encounter with the dust devil.NTSB CHI95LA164Accident · No injuriesLimited investigationFinal reportCessna 337B · Lemmon, SDthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB NYC95WA234Accident · Serious injuriesForeign investigationde Havilland DHC-2 · Biscarrosse, FranceNTSB LAX95LA193Accident · No injuriesLimited investigationFinal reportCessna 172F · Boonville, CAa loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW95LA216Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe failure of the right outboard tire for undetermined reason.NTSB CHI95LA234Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INreason for the occurrence was undetermined.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX95LA190Accident · 3 fatalLimited investigationFinal reportStol UC-1 · Saipan, Sarkan inflight collision with the ocean for undetermined reasons.NTSB 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.NTSB FTW95LA209Accident · No injuriesLimited investigationFinal reportPurdy HP-18 · Hempstead, TXThe pilot's poor in flight planning/decision. The lack of thermal lift was a factor.NTSB 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.NTSB 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.NTSB 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.NTSB SEA95LA104Accident · No injuriesLimited investigationFinal reportBeech 77 · New Meadows, IDA partial loss of engine power after takeoff for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…