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 CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.Feb 9, 1998 · N1958P · Substantial damageNTSB 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.Feb 8, 1998 · N89051 · Substantial damageNTSB 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.Feb 8, 1998 · N4120H · Substantial damageNTSB 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.Feb 8, 1998 · N18766 · Substantial damageNTSB ATL98LA037Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Deland, FLThe loss of engine power due to the pilots inadequate fuel management.Feb 8, 1998 · N925IT · Substantial damageNTSB NYC98LA065Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Chester, NYThe pilot's inadequate preflight which failed to reveal fuel contamination.Feb 7, 1998 · N55412 · Substantial damageNTSB MIA98LA073Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Cumming, GAThe pilot's misjudgment of distance and airspeed, and his failure to attain the proper touchdown point.Feb 7, 1998 · N1536H · Substantial damageNTSB FTW98LA123Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Conroe, TXThe pilot's delay in aborting the landing due to excessive airspeed during the approach.Feb 7, 1998 · N7117L · Substantial damageNTSB MIA98WA076Incident · No injuriesForeign investigationLockheed L-1011-385-1-15 · Panama City, PanamaFeb 6, 1998 · N103CK · No damageNTSB MIA98LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Daytona Beach, FLThe pilot's improper use of ailerons and brakes on landing rollout.Feb 6, 1998 · N406ER · Substantial damageNTSB 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.Feb 6, 1998 · N316T · Substantial damageNTSB 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…Feb 6, 1998 · N5207R · Substantial damageNTSB 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.Feb 6, 1998 · N7678L · Substantial damageNTSB 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…Feb 6, 1998 · N91029 · DestroyedNTSB SEA98LA035Accident · Minor injuriesLimited investigationFinal reportBromley Steen Skybolt · Hillsboro, ORThe pilot's failure to maintain a proper glidepath.Feb 5, 1998 · N55740 · Substantial damageNTSB 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.Feb 5, 1998 · N9213M · DestroyedNTSB 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.Feb 4, 1998 · N9489X · Substantial damageNTSB 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.Feb 4, 1998 · N13711 · Substantial damageNTSB 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.Feb 4, 1998 · N15566 · DestroyedNTSB 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.Feb 4, 1998 · N5842F · Substantial damageNTSB MIA98WA068Accident · No injuriesForeign investigationDouglas DC-3C · Moss Town, HaitiFeb 3, 1998 · N200MF · Substantial damageNTSB 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).Feb 3, 1998 · N26EA · Substantial damageNTSB 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…Feb 3, 1998 · N30TV · DestroyedNTSB 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.Feb 3, 1998 · N9204D · Substantial damageNTSB 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.Feb 3, 1998 · N4654Z · Substantial damageNTSB 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 stallFeb 2, 1998 · N79588 · DestroyedNTSB DCA98RA021Accident · 104 fatalForeign investigationMcDonnell Douglas DC-9-32 · Philippine Isla, PhilippinesFeb 2, 1998 · PC150NTSB 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.Feb 1, 1998 · N7275E · Substantial damageNTSB MIA98WA067Accident · No injuriesForeign investigationLearjet 36A · Al Manamah, BahrainFeb 1, 1998 · N27MJ · Substantial damageNTSB 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…Feb 1, 1998 · N94929 · Substantial damageNTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.Feb 1, 1998 · N78222 · Substantial damageNTSB 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.Feb 1, 1998 · N6327K · Substantial damageNTSB 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…Feb 1, 1998 · N830JT · Substantial damageNTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.Jan 31, 1998 · N50499 · DestroyedNTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.Jan 31, 1998 · N180AJ · Substantial damageNTSB 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.Jan 31, 1998 · N5975Z · Substantial damageNTSB 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.Jan 31, 1998 · N6261E · Substantial damageNTSB 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.Jan 31, 1998 · N738YK · Substantial damageNTSB 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.Jan 31, 1998 · N1200D · Substantial damageNTSB 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.Jan 31, 1998 · N2308X · Substantial damageNTSB 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.Jan 30, 1998 · N8798G · Substantial damageNTSB 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.Jan 30, 1998 · N6926A · Substantial damageNTSB 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.Jan 30, 1998 · N2804Y · Substantial damageNTSB 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.Jan 30, 1998 · N9AX · Substantial damageNTSB 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.Jan 30, 1998 · N9316F · DestroyedNTSB 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.Jan 29, 1998 · N50929 · Substantial damageNTSB 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…Jan 29, 1998 · N47744 · Substantial damageNTSB 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…Jan 29, 1998 · N43763 · Substantial damageNTSB 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.Jan 28, 1998 · N500YY · Substantial damageNTSB 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.Jan 28, 1998 · N16866 · Destroyed