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 DEN99LA110Accident · No injuriesLimited investigationFinal reportCessna 182A · Salt Lake City, UTA total loss of engine power (nonmechanical) for reasons undetermined. Factors were the existence of conditions conducive to carburetor icing, and unsuitable terrain on which to make a forced landing.Jul 1, 1999 · N6165B · Substantial damageNTSB ANC99LA112Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe student pilot's inadvertent ground loop during the takeoff roll. A factor in this accident was the a left crosswind.Jul 1, 1999 · N2806C · Substantial damageNTSB SEA99LA099Accident · Minor injuriesLimited investigationFinal reportWhithington Kitfox 1200 · Caldwell, IDThe pilot's failure to maintain clearance from obstacles along his departure path. Factors include the pilot's incorrect positioning of the flaps prior to takeoff, and a transmission wire and trees along the aircraft's flight path.Jun 30, 1999 · N818HW · Substantial damageNTSB MIA99LA192Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rock Springs, NC**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.Jun 30, 1999 · N4784N · Substantial damageNTSB LAX99LA238Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe airplane's encounter with turbulent air from the rotor wash of a large military helicopter, which resulted from the instructor's decision to continue the approach while the helicopter was on the runway.Jun 30, 1999 · N63614 · Substantial damageNTSB LAX99LA237Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Williams, CAThe pilot's inadequate preflight planning and verification that fuel was available for the intended flight. A factor was the fuel quantity false indication.Jun 30, 1999 · N7173F · Substantial damageNTSB DCA99WA075Accident · 2 fatalForeign investigationBeech 99 · Leige, BelgiumJun 30, 1999 · DIBEX · DestroyedNTSB DCA99WA066Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesJun 30, 1999 · N582FE · Substantial damageNTSB CHI99LA203Accident · No injuriesLimited investigationFinal reportCessna 172R · Kokomo, INthe student pilot's failure to maintain directional control during landing. Factors to the accident were the pilot's lack of experience and the VOR station.Jun 30, 1999 · N2632Y · Substantial damageNTSB ANC99LA083Accident · No injuriesLimited investigationFinal reportCessna TU206 · Talkeetna, AKThe pilot not following emergency procedures, and improper use of the electric fuel boost pump, while attempting to restart the engine in flight. A factor associated with this accident was the inadequate fuel consumption calculations by the pilot.Jun 30, 1999 · N126KT · Substantial damageNTSB NYC99LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Forest, VAThe pilot's misjudgment of distance/speed, also causal was his failure to execute a go-around. Contributing factors were the night conditions and the tailwind.Jun 29, 1999 · N5481B · Substantial damageNTSB MIA99LA191Accident · No injuriesLimited investigationFinal reportMooney M20F · Liberty, NCImproper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…Jun 29, 1999 · N7114V · Substantial damageNTSB LAX99LA233Accident · No injuriesLimited investigationFinal reportErcoupe E · Winnemucca, NVAn improperly installed and maintained float needle in the carburetor, which would not seat sufficiently to stop fuel flow and caused the engine to run excessively rich, resulting in a complete loss of engine power.Jun 29, 1999 · N3640H · Substantial damageNTSB DEN99FA109Accident · 1 fatalField investigationFinal reportBoeing Stearman A75 · Carpenter, WYPilot incapacitation for unknown reasons.Jun 29, 1999 · N801RB · DestroyedNTSB CHI99IA204Incident · No injuriesIncident investigationFinal reportBoeing 767-323 · Chicago, ILthe pilot's failure to maintain clearance from the parked aircraft while taxiing. A factor in the accident was the failure of ATC to issue a traffic advisory.Jun 29, 1999 · N384AA · Minor damageNTSB ATL99FA102Accident · 2 fatalField investigationFinal reportBeech BE-58 · Atlanta, GAThe loss of engine power for undetermined reasons, and the pilot's failure to follow emergency procedures that resulted in the uncontrolled collision with trees.Jun 29, 1999 · N17915 · DestroyedNTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.Jun 28, 1999 · N17902 · Substantial damageNTSB IAD99FA051Accident · No injuriesField investigationFinal reportCessna 172P · Gaithersburg, MDwas the pilot's failure to obtain the proper rotation speed and his subsequent loss of directional control. A factor in the accident was the improper setting of the elevator trim.Jun 28, 1999 · N62284 · Substantial damageNTSB FTW99FA176Accident · 2 fatalField investigationFinal reportCessna T210L · Petersburg, TXThe failure of the pilot to maintain obstacle clearance.Jun 28, 1999 · N93058 · DestroyedNTSB DCA99WA064Accident · No injuriesForeign investigationAirbus Industrie A310 · Manila, PhilippinesJun 28, 1999 · N420FE · Substantial damageNTSB CHI99LA201Accident · No injuriesLimited investigationFinal reportCessna 172G · Union, INThe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.Jun 28, 1999 · N5869R · Substantial damageNTSB MIA99LA190Accident · No injuriesLimited investigationFinal reportBeech A23 · Pinehurst, NCThe flight crew's improper fuel management resulting in engine loss of power due to fuel starvation and damage to the airplane due to collision with trees in the subsequent forced landing.Jun 27, 1999 · N1455L · Substantial damageNTSB FTW99LA174Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Laredo, TXThe pilot's failure to refuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jun 27, 1999 · N8329M · Substantial damageNTSB SEA99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Winthrop, WAThe pilot/passenger's failure to maintain directional control. A contributing factor was the fence.Jun 26, 1999 · N5059Z · Substantial damageNTSB SEA99LA096Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Nampa, IDDirectional control was not maintained. Diverted attention was a factor.Jun 26, 1999 · N1895B · Substantial damageNTSB NYC99FA161Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Dawson, MDThe pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, downdraft, and the pilot's decision to operate at a weight in excess of the maximum allowable gross weight.Jun 26, 1999 · N1548N · DestroyedNTSB NYC99FA160Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dawson, MDwas the pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, and unfavorable winds.Jun 26, 1999 · N29832 · Substantial damageNTSB LAX99LA239Accident · No injuriesLimited investigationFinal reportCessna 150K · Hesperia, CAThe pilot's misjudged landing flare point and failure to maintain an adequate airspeed margin, resulting in a stall and hard landing.Jun 26, 1999 · N6171G · Substantial damageNTSB LAX99LA229Accident · Serious injuriesLimited investigationFinal reportAerostar Rally RX-7 · Prescott Valley, AZThe pilot's inadequate visual lookout and subsequent failure to maintain adequate clearance with the wires.Jun 26, 1999 · N6426K · Substantial damageNTSB FTW99LA207Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Lafayette, LAThe pilot's inadvertent flight into an adverse weather condition. A factor was the turbulence.Jun 26, 1999 · N650SW · No damageNTSB CHI99LA200Accident · Serious injuriesLimited investigationFinal reportGillmore Benson B&M · Greencastle, INthe failure of the cyclic control rod. Factors were aircraft control not possible for the pilot.Jun 26, 1999 · N2152G · Substantial damageNTSB CHI99LA199Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Kalamazoo, MIThe pilot's failure to maintain directional control of the airplane during landing. A factor was the variable wind condition.Jun 26, 1999 · N2PP · Substantial damageNTSB CHI99LA198Accident · No injuriesLimited investigationFinal reportMahler BD-4 · Baldwin City, KSThe pilot not maintaining directional control with the runway centerline during takeoff. A factor was the high vegetation off the left side of the runway.Jun 26, 1999 · N184BD · Substantial damageNTSB CHI99LA197Accident · Minor injuriesLimited investigationFinal reportPorter Searey · Morenci, MIthe pilots inadequate preflight planning and his failure to maintain airspeed. Factors to the accident were the high trees at the departure end of the runway, and the stall encountered.Jun 26, 1999 · N827P · Substantial damageNTSB CHI99FA202Accident · 1 fatalField investigationFinal reportRans S-10 Sakota · La Crosse, KSdirectional control not maintained by the pilot.Jun 26, 1999 · N108AN · DestroyedNTSB CHI99FA196Accident · 1 fatalField investigationFinal reportBeech C-23 · Mandan, NDthe pilot failed to maintain aircraft control on approach to the airport after encountering high winds, gusts, rain, and thunderstorms in the area.Jun 26, 1999 · N9703Q · DestroyedNTSB NYC99LA159Accident · Minor injuriesLimited investigationFinal reportDuci Lancair 235 · Hamilton, OHThe pilot's failure to maintain control of the airplane. Factors included the pilot's inexperience in the airplane and his failure to compensate for the crosswind condition.Jun 25, 1999 · N789TD · Substantial damageNTSB MIA99WA198Accident · 2 fatalForeign investigationBeech T-34B Mentor · San Isidro, Dominican RepublicJun 25, 1999 · N1611 · DestroyedNTSB MIA99LA189Accident · Minor injuriesLimited investigationFinal reportBoeing HU-369-OH6A · Murrells Inlet, SCAn inflight loss of control due to loss of tail rotor effectiveness as a result of the pilot's inadequate compensation for the winds and improper weather evaluation.Jun 25, 1999 · N6247A · Substantial damageNTSB MIA99FA188Accident · 2 fatalField investigationFinal reportBeech C90 · Munson, FLThe poor in-flight weather evaluation by the pilot-in-command and his operation of the airplane at an indicated airspeed greater than the design maneuvering speed (Va) in a thunderstorm contrary to the pilot's operating handbook resulting in an in-flight…Jun 25, 1999 · N3019W · DestroyedNTSB LAX99LA236Accident · Serious injuriesLimited investigationFinal reportMiller Rotorway Exec 162F · Pacoima, CAThe pilot's improper valve adjustments and failure to follow the manufacturer's instructions, which resulted in a loose number 3 cylinder rocker arm and a loss of engine power.Jun 25, 1999 · N112WM · Substantial damageNTSB LAX99LA231Accident · No injuriesLimited investigationFinal reportCessna TU206F · Saline Valley, CAThe pilot's failure to verify the fuel quantity prior to departure, which led to fuel exhaustion.Jun 25, 1999 · N8728Q · Substantial damageNTSB LAX99LA227Accident · No injuriesLimited investigationFinal reportCessna 120 · Chino, CAA preexisting fatigue fracture of the right axle.Jun 25, 1999 · N2651N · Substantial damageNTSB LAX99IA230Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · San Diego, CAfailure of the number three bearing. The resulting oil leak from the bearing led to coke/carbon buildup, which resulted in chafing of the turbine's low-pressure compressor drive shaft on the rear compressor seal tube and subsequent fracture of the drive shaft.Jun 25, 1999 · N450AA · No damageNTSB IAD99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman PT17 · Lock Haven, PAthe pilot's improper inflight decision to fly at an inadequate altitude and his improper visual lookout which resulted in a collision with wires.Jun 25, 1999 · N61467 · DestroyedNTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.Jun 25, 1999 · N6617Y · Substantial damageNTSB DEN99LA108Accident · No injuriesLimited investigationFinal reportBeech B90 · Creede, COOverload failure of the right main landing gear scissors torque link precipitated by preexisting fatigue fractures. A factor was wind shear.Jun 25, 1999 · N221NC · Substantial damageNTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.Jun 25, 1999 · N2263J · Substantial damageNTSB ANC99LA084Accident · No injuriesLimited investigationFinal reportJasper THUNDERBIRD-2C · Chugiak, AKThe failure of the pilot in command to maintain the proper rate of descend and flare, following an engine failure for undetermined reasons.Jun 25, 1999 · N63832 · Substantial damageNTSB SEA99LA095Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Big Sandy, MTThe pilot's failure to maintain clearance between the wire and his aircraft. A transmission wire and downdraft were factors.Jun 24, 1999 · N4788Q · Substantial damage