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 CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.Aug 27, 1997 · N9026H · Substantial damageNTSB ANC97LA135Accident · Serious injuriesLimited investigationFinal reportCessna 185E · Igiugig, AKfailure of the pilot to maintain adequate airspeed, during a maneuvering turn at low altitude, which resulted in an accelerated stall and subsequent collision with the terrain. A factor relating to the accident was: the lack of altitude to recover from the…Aug 27, 1997 · N2743J · DestroyedNTSB FTW97LA329Accident · No injuriesLimited investigationFinal reportFairchild Heli-Porter PC6/B2-H2 · Gillette, WYFailure by the pilot in command to follow procedures and retrim the stabilizer for landing.Aug 26, 1997 · N354F · Substantial damageNTSB CHI97LA273Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIfailure of a connecting rod in the engine assembly, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: lack of a recommended engine overhaul, and the lack of suitable terrain for an emergency landing.Aug 26, 1997 · N21639 · Substantial damageNTSB CHI97FA272Accident · 1 fatalField investigationFinal reportKellums Sonerai 1 · Scottsburg, INa loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.Aug 26, 1997 · N76457 · DestroyedNTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.Aug 26, 1997 · N6216Q · Substantial damageNTSB ANC97LA133Accident · No injuriesLimited investigationFinal reportCessna 185E · King Salmon, AKThe pilot's failure to maintain directional control while landing the oversize tire equipped airplane on dry, newly surfaced, asphalt.Aug 26, 1997 · N454CF · Substantial damageNTSB ANC97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKbinding or braking action of the left brake for undetermined reason(s).Aug 26, 1997 · N9771D · Substantial damageNTSB NYC97FA170Accident · 1 fatalField investigationFinal reportCessna 337B · Warren Township, NJthe pilot's loss of control in flight for undetermined reasons and the subsequent collision with terrain.Aug 25, 1997 · N2442S · DestroyedNTSB LAX97LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Mecca, CAfuel exhaustion as a result of the student pilot's inadequate preflight and failure to refuel.Aug 25, 1997 · N152RJ · Substantial damageNTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.Aug 25, 1997 · N7VX · Substantial damageNTSB LAX97LA302Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kenwood, CAthe pilot's improper planning/decision, which resulted in fuel exhaustion and a forced landing, due to an inadequate supply of fuel.Aug 25, 1997 · N733QD · Substantial damageNTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.Aug 25, 1997 · N222M · DestroyedNTSB FTW97LA321Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Sudan, TXThe loss of engine power due to the failure of a compressor turbine blade. A factor was the lack of suitable terrain for the forced landing.Aug 25, 1997 · N3654G · Substantial damageNTSB ANC97LA131Accident · No injuriesLimited investigationFinal reportCessna 185F · Barrow, AKthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and damage to the airplane. A factor relating to the accident was: the crosswind condition.Aug 25, 1997 · N20752 · Substantial damageNTSB SEA97LA195Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Elk City, IDOil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.Aug 24, 1997 · N3964V · DestroyedNTSB LAX97IA300Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300 B4-203 · Los Angeles, CASeparation of the landing gear tire tread and subsequent ingestion of the tread into the intake of the engine.Aug 24, 1997 · N862PA · Minor damageNTSB IAD97FA112Accident · 3 fatalField investigationFinal reportClassic YMF-5 · Ocean City, MDThe pilot performed an aerobatic maneuver at a low altitude, which resulted in an inadvertent stall/spin.Aug 24, 1997 · N68SH · DestroyedNTSB FTW97LA327Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Terrell, TXthe student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).Aug 24, 1997 · N8057Z · Substantial damageNTSB CHI97LA269Accident · No injuriesLimited investigationFinal reportCessna 177 · Maple Lake, MNthe pilot failure to maintain control of the airplane while landing and his improper recovery from the bounced landing. Factors associated with the accident were the night conditions and the pilot lack of recent experience with night operations.Aug 24, 1997 · N29379 · Substantial damageNTSB ATL97LA129Accident · Serious injuriesLimited investigationFinal reportKolb FIRESTAR-II · Albany, GAthe pilot's physical impairment, and his failure to maintain adequate airspeed while maneuvering, which led to a stall and ground impact.Aug 24, 1997 · UNREG · Substantial damageNTSB ATL97LA124Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Anderson, SCthe pilot misjudged distance and speed on final approach to land and failed to attain a proper touchdown point during the landing, which resulted in an overrun of the runway and collision with a fence. A related factor was the loss of engine power during…Aug 24, 1997 · N4668N · Substantial damageNTSB ATL97LA123Accident · 1 fatalLimited investigationFinal reportJurka P51D Mustang · Fort Pierce, FLloss of engine power for undetermined reason(s); and failure of the pilot to maintain adequate airspeed, while starting to maneuver for an emergency landing, which resulted in loss of aircraft control (stall) and collision with terrain.Aug 24, 1997 · N151MS · DestroyedNTSB ANC97LA130Accident · No injuriesLimited investigationFinal reportCessna 170A · Iliamna, AKthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and overload failure of the right main landing gear. Factors related to the accident were: the…Aug 24, 1997 · N9540A · Substantial damageNTSB ANC97LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Bethel, AKthe pilot's improper selection of a fuel tank that did not contain fuel, which resulted in subsequent fuel starvation and loss of engine power. A factor relating to the accident was: the inability to reach suitable terrain for a forced landing.Aug 24, 1997 · N4170R · Substantial damageNTSB NYC97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencerport, NYfailure of the pilot to maintain directional control of the airplane, while landing. The crosswind was a related factor.Aug 23, 1997 · N7682H · Substantial damageNTSB MIA97FA239Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Brownsville, TNthe pilot's inadequate preflight, and his improper in-flight planning/decision, which led to fuel exhaustion and a forced landing at night on unprepared terrain. Factors relating to the accident were: darkness, and the lack of a suitable area for an emergency…Aug 23, 1997 · N5678K · DestroyedNTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.Aug 23, 1997 · N7240E · Substantial damageNTSB FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…Aug 23, 1997 · N7929J · Substantial damageNTSB FTW97LA325Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Marietta, OKThe pilot's failure to follow procedures/directives for takeoff. Factors were the runway's rough/uneven condition and the hilly terrain on the departure end of the runway.Aug 23, 1997 · N177MM · Substantial damageNTSB FTW97LA324Accident · No injuriesLimited investigationFinal reportCessna 182A · Delta, COFailure by the pilot to properly plan for the flight in that the fuel aboard was insufficient for the planned flight. Factors were: inaccurate fuel gauges and terrain condition for the forced landing.Aug 23, 1997 · N4930D · Substantial damageNTSB CHI97LA267Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Coopersville, MIthe pilot inadequate fuel system management which led to a fuel starvation.Aug 23, 1997 · N178RA · Substantial damageNTSB ANC97LA128Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fort Yukon, AKfailure of the pilot to maintain directional control of the airplane, which resulted in a swerve and collision with a tree as the pilot continued the takeoff, subsequently jamming the stabilator and causing the plane to crash in water.Aug 23, 1997 · N6465V · Substantial damageNTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.Aug 22, 1997 · N1808F · DestroyedNTSB LAX97LA298Accident · No injuriesLimited investigationFinal reportBeech H35 · Vacaville, CAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.Aug 22, 1997 · N4689D · Substantial damageNTSB CHI97LA271Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Zionsville, INfailure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.Aug 22, 1997 · N600JP · DestroyedNTSB ANC97LA127Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Anchorage, AKthe baggage tug driver's disregard for wet taxiway/ramp conditions, which resulted in his inability to avoid a taxiing airplane as he came around the end of a concourse building. Darkness, rain, and the wet ramp conditions were related factors.Aug 22, 1997 · N27188 · Substantial damageNTSB NYC97LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Blairsville, PAthe pilot's inaccurate fuel consumption calculations and improper in-flight planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing.Aug 21, 1997 · N47900 · Substantial damageNTSB MIA97LA238Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLa hard landing resulting in a wing contacting the runway. A factor in this accident was the nose landing gear would not extend due to the steering ball being off its track.Aug 21, 1997 · N55322 · Substantial damageNTSB MIA97IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Tampa, FLin-flight collision with a bird.Aug 21, 1997 · N602SW · Minor damageNTSB LAX97LA297Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lancaster, CAImproper flare.Aug 21, 1997 · N9710B · Substantial damageNTSB FTW97RA323Accident · 3 fatalForeign investigationBell 206L-1 · Arica, PeruAug 21, 1997 · N2246QNTSB FTW97LA322Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Columbus, NMa loss of engine power due to failure of an exhaust side rocker box and valve mechanism, and pilot incapacitation due to loss of consciousness after being struck in the head by parts separating from the engine.Aug 21, 1997 · N4893X · Substantial damageNTSB CHI97LA268Accident · No injuriesLimited investigationFinal reportBeech G35 · Belleville, MIthe pilot's improper planning/decision by failing to assure that the airplane was either tied down or chocked prior to pulling the propeller through, which started the engine with no one at the controls.Aug 21, 1997 · N4630D · Substantial damageNTSB ANC97GA126Accident · 1 fatalFinal reportBell BH-206B · Dillingham, AKThe pilot's intentional VFR flight into instrument meteorological conditions (IMC). Factors associated with the accident are the pilot's failure to activate the cabin heating system, the lack of an operable windshield defogger, the pilot's overconfidence in…Aug 21, 1997 · N18FH · DestroyedNTSB FTW97LA320Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Hayden, COThe pilot in command's inadequate visual lookout.Aug 20, 1997 · N35164 · Substantial damageNTSB CHI97LA266Accident · Minor injuriesLimited investigationFinal reportSwearingen SA226TC · Des Moines, IAthe pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…Aug 20, 1997 · N224AM · Substantial damageNTSB CHI97LA265Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grayslake, ILexcessive airspeed and the pilot's failure to attain the proper touchdown point during landing. Factors associated with the accident were inadequate aircraft preflight and the ditch.Aug 20, 1997 · N44C · DestroyedNTSB SEA97LA194Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hamilton, MTThe pilot's excessive speed taxispeed and failure to maintain wing clearance from a taxiway sign.Aug 19, 1997 · N52AS · Substantial damageNTSB NYC97LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brickerville, PAFuel starvation as a result of the pilot performing a takeoff with the fuel selector in the 'OFF' position.Aug 19, 1997 · N8262K · Substantial damage