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 ANC90LA008Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKPilot's failure to assure condition of runway prior to landing and failure to maintain runway alignment during landing.NTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.NTSB MIA90LA026Accident · No injuriesLimited investigationFinal reportWarren/Keleher/Lark JK-1B · Homestead, FLSeizure of the left main gear wheel. Contributing factors were: the parked aircraft and vehicle (car) near the runway.NTSB FTW90LA023Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Thelma, TXThe pilot's failure to drain all the water from the fuel system during preflight.NTSB FTW90LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Marietta, OKThe pilot's use of the wrong runway for takeoff. Factors related to the accident were: the tailwind and rising terrain beyond the departure end of the runway.NTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.NTSB BFO90LA007Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Windmill Point, VALoss of engine power due to oil starvation.NTSB BFO90FA008Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Laurel, MDLost of engine power caused by material failure of the number three cylinder exhaust valve. The failure was attributed to excessive temperature.NTSB ATL90FA024Accident · 4 fatalField investigationFinal reportBeech C90 · Gadsden, ALFailure of the pilots of both aircraft to maintain adequate visual lookout to see-and-avoid the other aircraft.NTSB SEA90LA011Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Chilcoot, CAThe pilot's improper inflight planning. Contributing to the accident was a down draft and the pilot's lack of recent expereince in this aircraft type.NTSB NYC90LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Westfield, MALoss of aircraft control for an undetermined reason, which resulted in the tail rotor striking the ground and separating from the helicopter.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB LAX90DUJ05Accident · No injuriesFinal reportBell UH-1E · Mesa, AZThe inflight separation of the tail rotor due to improper maintenance procedures and the installation of incorrect attachment hardware on the tail rotor blade pitch change linkages.NTSB FTW90LA021Accident · Minor injuriesLimited investigationFinal reportCameron N-105 · Bryan, TXPilot's misjudgement/compensation for the wind change and his delayed response in initiating a climb in order to clear the tower.NTSB ATL90LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Dyersburg, TNPilot's temporary physical condition (possible hyperventilation or anxiety attack). Soft terrain in the emergency landing area was considered to be a related factor.NTSB ATL90DKG01Accident · Serious injuriesFinal reportPond Midget Mustang · Cordele, GAImproper handling of the aircraft by the pilot, which resulted in his loss of control. His lack of experience in this type of aircraft was a related factor.NTSB MIA90WA025Accident · No injuriesForeign investigationPiper PA-31 · Stella Maris, BahamasNTSB MIA90LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Immokalee, FLFailure of the pilot to maintain proper altitude and his failure to maintain adequate visual lookout to see and avoid obstructions. The static line (obstruction) was a contributing factor.NTSB ATL90GA023Accident · 1 fatalFinal reportSikorsky SK-70 · Marathon, FLFailure of the pilot to maintain the proper altitude over the ocean water. Factors related to the accident were: continued operation of the helicopter with a known partial deficiency of the radio altimeter/warning system, darkness, the pilot's lack of visual…NTSB MKC90LA021Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Saint Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Darkness was a related factor.NTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.NTSB MIA90FA021Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Apopka, FLFailure of the pilot to maintain altitude/clearance above the water, while proceeding over a lake and approaching the vicinity of the airport.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB MIA90FA022Accident · 1 fatalField investigationFinal reportPiper 601P · Fort Myers, FLFailure of the pilot to properly follow the IFR procedure and to identify the decision height. Factors related to the accident were: the adverse weather conditions, darkness, the pilot's lack of visual perception without the approach lights, and tree(s) in…NTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.NTSB DEN90FA017Accident · 1 fatalField investigationFinal reportCessna 172RG · Laramie, WYThe loss of control of the airplane in instrument meteorological conditions after the pilot became spatially disoriented. Contributing to the accident was the failure of the vacuum system which rendered the vacuum/gyro instruments inoperative. Also…NTSB MIA90IA020Incident · No injuriesIncident investigationFinal reportClassic YMF-5 · Marathon, FLThe pilot's incorrect elevator control while taxiing with a quartering tailwind. Contributing to the incident was the tailwind condition.NTSB LAX90LA012Accident · No injuriesLimited investigationFinal reportCulver VEE · Santa Paula, CAThe pilot's failure to maintain sufficient airspeed for a positive rate of climb.NTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.NTSB CHI90DEG01Accident · 2 fatalFinal reportMccomb RV-4 · Eaton, OHPoor in-flight planning/decision by the pilot which resulted in spatial disorientation and an inadvertent spiral. Factors related to the accident were: the dark night and instrument lights not installed.NTSB SEA90LA026Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Newberg, ORFailure of the pilot to maintain runway alignment. The birds & debris (hidding obstructions) were related factors.NTSB NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB NYC90LA019Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Windham, CTThe pilot's failure to achieve proper lift-off speed.NTSB MKC90FA020Accident · 1 fatalField investigationFinal reportCessna 402B · Little Rock, ARA leak in the aircraft's fuel system which resulted in an in-flight fire. The origin of the fuel leak was not determined.NTSB LAX90LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CAThe flight instructor improperly supervised the flight and the dual student pilot failed to properly set the fuel selector valve in the proper position. Both pilots failed to use the emergency checklist.NTSB LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB LAX90LA015Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Borrego Springs, CAThe failure of the engine exhaust valve.NTSB FTW90LA019Accident · No injuriesLimited investigationFinal reportCessna 182J · Leesville, LAThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was: the lack of a suitable landing area.NTSB DCA90MA005Accident · 20 fatalClass 1 · MajorFinal reportDe Havilland DHC-6-300 · Halawa,Molokai, HIThe airplane's controlled flight into terrain as a result of the decision of the captain to continue flight under visual flight rules at night into instrument meteorological conditions (IMC), which obscured rising mountainous terrain. Contributing to the…NTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.NTSB CHI90LA020Accident · No injuriesLimited investigationFinal reportBell 47G-2A-1 · Plymouth, INThe student's improper use of the cyclic control and the instructor's (cfi's) inadequate supervision.NTSB BFO90LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Churchville, MDThe pilot not maintaining adequate clearance from the wind sock during an aborted landing. A contributing factor was the presence of another aircraft.NTSB BFO90LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Wytheville, VAThe loss of propeller control which resulted in engine shutdown and subsequent forced landing on unsuitable terrain.NTSB BFO90FA003Accident · 2 fatalField investigationFinal reportCessna 177 · Mchenry, MDThe pilot's failure to obtain adequate takeoff airspeed as a result of an improper flap setting. Contributing factors were a takeoff with a tailwind, an upsloping runway, and high density altitude.NTSB ATL90LA018Accident · No injuriesLimited investigationFinal reportBeech A23A · Roopville, GAThe pilot's disregard for a tailwind during landing, his delay in executing a go around when he noted excessive speed during the landing roll, and improper go around procedures.NTSB ATL90FA017Accident · 1 fatalField investigationFinal reportCessna 150M · Carrollton, OHThe pilot failed to maintain adequate airspeed while maneuvering, which led to an inadvertent stall/spin. Contributing to the accident were the pilot's apparent desire to show off, and the low altitude at which he chose to perform the maneuver.NTSB NYC90LA023Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Friendsville, PAThe pilot failed to maintain airspeed and stalled the aircraft.NTSB NYC90LA022Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pittstown, NJThe pilot's failure to maintain directional control during landing.NTSB NYC90LA021Accident · Minor injuriesLimited investigationFinal reportBoeing B75N · Willimantic, MEAn inadvertent stall clearing trees during a forced landing following a power loss due to a fuel line separating from the carburetor and fuel starvation.NTSB NYC90LA018Accident · No injuriesLimited investigationFinal reportMaule M-5 · Plattsburgh, NYThe pilot's inadequate preflight planning to assure clearance from the surrounding brush.