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 CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.NTSB MIA98LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe CFI's improper planning and decision to taxi behind a multi-engine airplane conducting an engine run-up.NTSB IAD98LA026Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Davis, WVA loss of power due to blockage of the fuel screen and one of the four fuel injector nozzles. A contributing factor was snow covered terrain.NTSB CHI98LA092Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe pilot's improper raising of flaps and not maintaining directional control of the aircraft during the go-around sequence.NTSB ATL98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Deland, FLThe loss of engine power due to the pilots inadequate fuel management.NTSB NYC98LA065Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Chester, NYThe pilot's inadequate preflight which failed to reveal fuel contamination.NTSB MIA98LA073Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cumming, GAThe pilot's misjudgment of distance and airspeed, and his failure to attain the proper touchdown point.NTSB FTW98LA123Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Conroe, TXThe pilot's delay in aborting the landing due to excessive airspeed during the approach.NTSB MIA98WA076Incident · No injuriesForeign investigationLockheed L-1011-385-1-15 · Panama City, PanamaNTSB MIA98LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Daytona Beach, FLThe pilot's improper use of ailerons and brakes on landing rollout.NTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.NTSB FTW98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Port Lavaca, TXThe pilot's failure to maintain clearance from the power line. Factors were the gusty winds, the pilots lack of experience in the type of operation, inadequate training and insufficient standards/requirements by the company/operator management, and the power…NTSB ANC98LA020Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKThe pilot's poor in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power.NTSB ANC98FA019Accident · 1 fatalField investigationFinal reportCessna 207 · Homer, AKA fatigue failure, and partial separation of the number 6 engine cylinder head assembly, the operator's inadequate progressive inspection performed by company maintenance personnel, and the pilot's inadvertent stall during a maneuvering turn toward an…NTSB SEA98LA035Accident · Minor injuriesLimited investigationFinal reportBromley Steen Skybolt · Hillsboro, ORThe pilot's failure to maintain a proper glidepath.NTSB FTW98FA121Accident · 1 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot attempting VFR flight into instrument meteorological conditions and his lack of an instrument rating. Factors were weather conditions that included mountain wave activity conducive to turbulence, and clouds obscuring the mountainous terrain.NTSB FTW98LA120Accident · No injuriesLimited investigationFinal reportCessna 210A · Morgan, UTfailure of the pilot to maintain control of the aircraft, which resulted in an inadvertent ground swerve. A related factor was the lack of experience in the make and model of aircraft.NTSB FTW98LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Bulverde, TXThe pilot's failure to maintain the proper glidepath following a total electrical failure resulting from an inoperative voltage regulator. Factors were the dark night conditions, the pilot's lack of experience in night flying, and the trees.NTSB FTW98FA117Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Graford, TXThe pilot's failure to maintain clearance with the ground. Factors were the dark night, the rising terrain, and the ground fog obscuring the ground.NTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.NTSB MIA98WA068Accident · No injuriesForeign investigationDouglas DC-3C · Moss Town, HaitiNTSB MIA98LA070Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLThe pilot's improper use of flight controls (cyclic) while attempting a takeoff to a hover, which led to an on-ground loss of control (dynamic rollover).NTSB MIA98GA069Accident · 4 fatalFinal reportBell UH-1H · Savannah, TNfailure of the flight crew to maintain sufficient altitude/clearance from the pole and workman. Related factors were: the gusty wind condition, inadequate communication/coordination between the flight crew and ground personnel, and an improper external system…NTSB LAX98LA093Accident · No injuriesLimited investigationFinal reportBoeing MD600N · Mesa, AZthe attempt by flight test engineers to verify a height/velocity data point that was subsequently shown to be outside the aircraft's performance capabilities.NTSB FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.NTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallNTSB DCA98RA021Accident · 104 fatalForeign investigationMcDonnell Douglas DC-9-32 · Philippine Isla, PhilippinesNTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.NTSB MIA98WA067Accident · No injuriesForeign investigationLearjet 36A · Al Manamah, BahrainNTSB MIA98LA066Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ochopee, FLpartial loss of engine power due to a fractured number 4 exhaust valve, which resulted in a forced landing; and the lack of sufficient airspeed to maneuver over power lines during an attempt to abort (go around from) an emergency landing, which resulted in an…NTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB CHI98LA090Accident · No injuriesLimited investigationFinal reportCessna 150M · Troy, MIthe student pilot's failure to maintain direction control of the airplane. Factors relating to this accident were: the crosswind, and wet/soft terrain (mud) beside the runway.NTSB CHI98LA089Accident · No injuriesLimited investigationFinal reportChinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, ILinadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…NTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.NTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.NTSB MIA98LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · New Smyrna Bch, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.NTSB MIA98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Valkaria, FLthe pilot's inadequate preflight, and subsequent loss of engine power, due to fuel exhaustion, which resulted in a forced landing and impact with trees.NTSB MIA98LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe failure of the student to recover (pull-up) from the intentional maneuver resulting in the in-flight collision with terrain. Contributing to the accident was the ostentatious display by the student.NTSB MIA98FA064Accident · 1 fatalField investigationFinal reportCessna 170A · Miami, FLfailure of the pilot to maintain adequate airspeed during a banner pickup, which resulted in an inadvertent stall and collision with the terrain. The lack of altitude for a stall recovery was a related factor.NTSB LAX98LA083Accident · No injuriesLimited investigationFinal reportRobinson R22 · Oxnard, CAThe pilot's improper use of the collective during the initiation of the rollover, which prevented the recovery from the condition.NTSB SEA98LA031Accident · 1 fatalLimited investigationFinal reportCessna 150F · Havre, MTThe student pilot's loss of control after his failure to maintain airspeed. Factors include his lack of total flight experience and incapacitation due to alcohol.NTSB FTW98LA116Accident · No injuriesLimited investigationFinal reportCessna 172 · Laramie, WYThe pilot's improper flare and subsequent improper go-around in that he failed to use compensating elevator control, and his loss of directional control.NTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.NTSB FTW98LA114Accident · No injuriesLimited investigationFinal reportCessna 500 · Horseshoe Bay, TXthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darknes was a related factor.NTSB ANC98LA018Accident · Minor injuriesLimited investigationFinal reportCessna 208A · Port Heiden, AKThe pilot's inadequate in-flight decision resulting in airframe ice accumulation to the extent that degraded aircraft performance and insufficient airspeed occurred followed by a stall. Contributing factors were freezing rain and icing conditions.NTSB MIA98LA061Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Wrightsville, GAThe failure of the pilot to maintain airspeed (Vs) resulting in the inadvertent stall during the initial climb.NTSB LAX98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chinle, AZthe airport personnel's failure to provide an adequate perimeter barrier to prevent animals from entering the runway area. A factor in the accident was the dark night lighting conditions which hindered the pilot's ability to detect animals on the runway…NTSB FTW98LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lone Grove, OKThe total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced…NTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.NTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.