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 NYC94LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, CTThe loss of engine power for undetermined reasons.Jul 31, 1994 · N8453B · Substantial damageNTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.Jul 31, 1994 · N35AE · Substantial damageNTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.Jul 31, 1994 · N2313 · 2 aircraft · Minor damageNTSB LAX94LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devore, CAwas the failure of the pilot to follow checklist and emergency procedures, which resulted in an improper decision to land on a dirt road within two miles of an airport.Jul 31, 1994 · N2500Y · DestroyedNTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1994 · N5580G · Substantial damageNTSB FTW94LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75 · Comfort, TXThe pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.Jul 31, 1994 · N60459 · Substantial damageNTSB CHI94LA260Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Waterford, MIthe failure of the pilot to maintain directional control.Jul 31, 1994 · N44MK · Substantial damageNTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.Jul 31, 1994 · N32736 · DestroyedNTSB CHI94LA252Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Flushing, MIthe pilot's improper touchdown position on the runway. A factor associated with the accident is the moving vehicle on the adjacent road.Jul 31, 1994 · N90074 · Substantial damageNTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.Jul 31, 1994 · N43111 · Substantial damageNTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.Jul 30, 1994 · N81705 · Substantial damageNTSB MIA94LA188Accident · Minor injuriesLimited investigationFinal reportPiper J5C · Yazoo City, MSPartial blockage of the carburetor by a wasp nest, which was not visible during preflight, and which resulted in the loss of power.Jul 30, 1994 · N74669 · Substantial damageNTSB LAX94LA305Accident · No injuriesLimited investigationFinal reportCessna 172N · Cameron Park, CAthe pilot's improper use of the elevator control during the landing flare.Jul 30, 1994 · N739RF · Substantial damageNTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.Jul 30, 1994 · N6749D · Substantial damageNTSB LAX94LA301Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Livermore, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering and his subsequent entry into an inadvertent stall/mush. A factor was fuel starvation due to the pilot's failure to select the proper fuel tank.Jul 30, 1994 · N20707 · Substantial damageNTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.Jul 30, 1994 · N84514 · Substantial damageNTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.Jul 30, 1994 · N57TH · Substantial damageNTSB ATL94GA148Accident · Minor injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for undetermined reasons.Jul 30, 1994 · N789MC · Substantial damageNTSB ANC94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, AKUndetermined.Jul 30, 1994 · N3849M · Substantial damageNTSB ANC94LA094Accident · Serious injuriesLimited investigationFinal reportBell 206 · Kenai, AKThe pilot attempting to operate the helicopter in an environment which exceeded the aircraft's performance envelope.Jul 30, 1994 · N90315 · Substantial damageNTSB SEA94T#A02Accident · No injuriesClass 3Final reportLockheed P2V-7 · Missoula, MTJul 29, 1994 · N918AP · DestroyedNTSB SEA94LA200Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Connell, WAThe pilot's failure to maintain airspeed while conducting aerial application activities.Jul 29, 1994 · N3649Y · DestroyedNTSB NYC94LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Towanda, PAThe pilot's improper recovery from a bounced landing.Jul 29, 1994 · N43078 · Substantial damageNTSB MIA94LA187Accident · No injuriesLimited investigationFinal reportCessna 210-M · Orlando, FLThe improper installation of a nose gear actuator hydraulic line by an unknown person that bent it at installation. Contributing to the accident was the failure of the line allowing all hydraulic fluid to vent overboard disabling the normal and emergency gear…Jul 29, 1994 · N761VX · Substantial damageNTSB MIA94LA186Accident · No injuriesLimited investigationFinal reportCessna 152 · Palatka, FLThe student pilot's improper landing flare and failure to properly recover from a bounced landing.Jul 29, 1994 · N757GD · Substantial damageNTSB LAX94LA302Accident · No injuriesLimited investigationFinal reportCessna 421C · Polacca, AZthe pilot's attempt to make a 180-degree turn in soft sand at a speed which imposed side loading on the nose gear. Factors were the pilot's decision to continue the approach beyond the planned touchdown point, the effect of the runway surface on braking…Jul 29, 1994 · N985RA · Substantial damageNTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.Jul 29, 1994 · N4268Y · Substantial damageNTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.Jul 29, 1994 · N4029 · Substantial damageNTSB CHI94LA255Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marshalltown, IAA partial loss of engine power for undetermined reasons.Jul 29, 1994 · N8144Y · Substantial damageNTSB CHI94LA250Accident · No injuriesLimited investigationFinal reportCessna 421C · Oshkosh, WIthe pilot-in-command's misjudging the flare and his failure to maintain airspeed.Jul 29, 1994 · N819RA · Substantial damageNTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.Jul 29, 1994 · N93572 · Substantial damageNTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.Jul 29, 1994 · N79752 · DestroyedNTSB CHI94DER02Accident · No injuriesFinal reportAir Tractor AT-301 · Halstad, MNthe commercial pilot's failure to maintain clearance from terrain during the attempted takeoff. Related factors are the soft terrain and the deterioration in aircraft performance due to the high gross weight.Jul 28, 1994 · N3611Z · Substantial damageNTSB ATL94LA149Accident · No injuriesLimited investigationFinal reportMiller, John Skybolt · Muscle Shoals, ALThe fatigue failure of the main landing gear strut that resulted in a loss of control.Jul 28, 1994 · N919JM · Substantial damageNTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.Jul 27, 1994 · N6824P · Substantial damageNTSB MIA94LA185Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe pilot-in-command's improper use of carburetor heat. The carburetor icing conditions were a factor.Jul 27, 1994 · N68165 · Substantial damageNTSB LAX94LA300Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Elko, NVa loss of engine power from fuel exhaustion due to the pilot's improper preflight and fuel consumption calculations while operating with known equipment malfunctions.Jul 27, 1994 · N180BK · Substantial damageNTSB LAX94LA299Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAthe improper adjustment of the fuel control unit by contract maintenance personnel.Jul 27, 1994 · N3627Q · Substantial damageNTSB LAX94LA298Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Corona, CAAn undetermined partial loss of engine power.Jul 27, 1994 · N8972L · Substantial damageNTSB FTW94LA251Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COAn inadvertent stall. A factor was the pilot's excessive flare.Jul 27, 1994 · N739VN · DestroyedNTSB CHI94LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Lomax, ILthe pilot's failure to maintain clearance from a transmission wire, and the pilot's failure to maintain an appropriate altitude. A factor associated with the accident is the transmission wire.Jul 27, 1994 · N9409A · Substantial damageNTSB CHI94LA245Accident · No injuriesLimited investigationFinal reportMooney M20C · Macon, MOthe student pilot's decision to land on a closed runway under construction. A factor associated with the accident is the partial loss of engine power for an undetermined reason.Jul 27, 1994 · N6327Q · Substantial damageNTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.Jul 26, 1994 · N761TK · Substantial damageNTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.Jul 26, 1994 · N8026 · Substantial damageNTSB NYC94LA139Accident · No injuriesLimited investigationFinal reportCessna 172A · Block Island, RIThe pilot's improper decision to initiate VFR flight into instrument meteorological conditions. The dark night light conditions and the fog were contributing factors.Jul 26, 1994 · N5647A · Substantial damageNTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.Jul 26, 1994 · N2564R · Substantial damageNTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.Jul 26, 1994 · N218LW · Substantial damageNTSB ANC94LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe partial loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.Jul 26, 1994 · N4341Z · Substantial damageNTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.Jul 25, 1994 · N32925 · Substantial damageNTSB NYC94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lumberton, NJThe pilot's (1) improper recovery from a bounced landing and (2) failure to maintain directional control during an aborted landing. A factor is the pilot's improper landing flare.Jul 25, 1994 · N40996 · Destroyed