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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DCA99WA075Accident · 2 fatalForeign investigationBeech 99 · Leige, BelgiumNTSB DCA99WA066Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesNTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB DEN99FA109Accident · 1 fatalField investigationFinal reportBoeing Stearman A75 · Carpenter, WYPilot incapacitation for unknown reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW99FA176Accident · 2 fatalField investigationFinal reportCessna T210L · Petersburg, TXThe failure of the pilot to maintain obstacle clearance.NTSB DCA99WA064Accident · No injuriesForeign investigationAirbus Industrie A310 · Manila, PhilippinesNTSB 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.NTSB 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.NTSB 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.NTSB SEA99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Winthrop, WAThe pilot/passenger's failure to maintain directional control. A contributing factor was the fence.NTSB SEA99LA096Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Nampa, IDDirectional control was not maintained. Diverted attention was a factor.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW99LA207Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3H4 · Lafayette, LAThe pilot's inadvertent flight into an adverse weather condition. A factor was the turbulence.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI99FA202Accident · 1 fatalField investigationFinal reportRans S-10 Sakota · La Crosse, KSdirectional control not maintained by the pilot.NTSB 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.NTSB 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.NTSB MIA99WA198Accident · 2 fatalForeign investigationBeech T-34B Mentor · San Isidro, Dominican RepublicNTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB LAX99LA227Accident · No injuriesLimited investigationFinal reportCessna 120 · Chino, CAA preexisting fatigue fracture of the right axle.NTSB 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.NTSB 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.NTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.