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 LAX99LA256Accident · No injuriesLimited investigationFinal reportCessna 172E · Emeryville, CAThe pilot's inadequate in-flight planning and inadequate fuel consumption calculations, resulting in a total loss of engine power due to fuel exhaustion. Factors were the pilot's failure to have all appropriate flight manuals aboard the airplane and the low…Jul 24, 1999 · N5784T · Substantial damageNTSB DEN99LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Limon, COThe pilot's selection of the wrong runway for takeoff. Factors were a direct tailwind and high density altitude that deteriorated the airplane's climb capability, and unsuitable terrain on which to make a forced landing.Jul 24, 1999 · N4540A · Substantial damageNTSB CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.Jul 24, 1999 · N9799E · Substantial damageNTSB CHI99LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 401B · Mccanna, NDthe inadvertent stall by the pilot.Jul 24, 1999 · N6006A · Substantial damageNTSB CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.Jul 24, 1999 · N9330C · Substantial damageNTSB SEA99LA125Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · American Falls, IDA loss of engine power for undetermined reasons, and overload of the (right) main landing gear. A contributing factor was the rough terrain.Jul 23, 1999 · N3649X · Substantial damageNTSB NYC99LA183Accident · No injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe student pilot's failure to execute a go-around. Factors include excessive airspeed on the final approach, and the student pilot's attempt to land beyond a safe touchdown point.Jul 23, 1999 · N6017R · DestroyedNTSB NYC99LA182Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Newton, NJThe pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.Jul 23, 1999 · N9712X · Substantial damageNTSB MIA99LA203Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Drew, MSa loss of engine power due to the failure of cylinder No. 4 boss, which was caused by fatigue cracking, resulting in a forced landing in marshy terrain and subsequent nose over.Jul 23, 1999 · N2368R · Substantial damageNTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.Jul 23, 1999 · N6712W · Substantial damageNTSB FTW99LA198Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · Fort Worth, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jul 23, 1999 · N59646 · Substantial damageNTSB FTW99FA199Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Bethany, OKThe pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.Jul 23, 1999 · N345LS · DestroyedNTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.Jul 23, 1999 · N6726R · DestroyedNTSB DEN99LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA28-160B · Pueblo, COTotal loss of power during initial climb for undetermined reasons.Jul 23, 1999 · N5595W · Substantial damageNTSB CHI99LA254Accident · No injuriesLimited investigationFinal reportBeech G18S · Minneapolis, MNthe premature gear retraction and proper runway alignment not maintained during takeoff by the pilot. An additional cause was the proper descent rate not maintained by the pilot. Contributing factors were the carburetor icing conditionsJul 23, 1999 · N621KE · Substantial damageNTSB CHI99LA250Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Udall, KSthe failure of maintenance personnel to properly safety the aileron control cable during installation, the disconnected aileron control cable, and the unavailability of aileron control to the pilot.Jul 23, 1999 · N6726G · Substantial damageNTSB CHI99LA249Accident · No injuriesLimited investigationFinal reportCessna 152 · Berrien Springs, MIFailure to obtain a proper climb rate and the delayed remedial action by the certified flight instructor. Contributing factors were the uphill terrain and trees.Jul 23, 1999 · N95534 · Substantial damageNTSB CHI99LA248Accident · No injuriesLimited investigationFinal reportRobinson R22 · Spring Green, WIthe pilots failure to maintain clearance with the wire. A factor was the wire.Jul 23, 1999 · N2313D · Substantial damageNTSB ATL99LA113Accident · No injuriesLimited investigationFinal reportBeech BE23 · Vidalia, GAPilot's decision to attempt a takeoff from an unsuitable pasture. A factor contributing to the accident consisted of previous damage to the leading edges of the wings.Jul 23, 1999 · N2381Z · Substantial damageNTSB ATL99LA112Accident · No injuriesLimited investigationFinal reportBeech 77 · Dawson, GAThe loss of engine power due to fuel starvation that resulted from a blocked fuel line check valve.Jul 23, 1999 · N38482 · Substantial damageNTSB ANC99LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Mcgrath, AKThe pilot's improper management of the fuel supply, and subsequent fuel starvation. A factor in the accident was unsuitable terrain for a forced landing.Jul 23, 1999 · N4811T · Substantial damageNTSB MIA99LA248Accident · No injuriesLimited investigationFinal reportDouglas DC3C-S4C4G · Charlotte, NCthe pilot-in-command did not use the check list which resulted in the right main landing gear collapsing.Jul 22, 1999 · N79017 · Substantial damageNTSB MIA99LA200Accident · No injuriesLimited investigationFinal reportBell OH-13H/M74A · Sparta, GAthe pilot's inadequate preflight which resulting in his failure to remove all the tie downs, and the subsequent impact with the ground.Jul 22, 1999 · N51857 · DestroyedNTSB FTW99LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Fabens, TXThe pilot's inadvertent flight into adverse weather conditions. A factor was the windshear weather conditions.Jul 22, 1999 · N6736Z · Substantial damageNTSB DEN99LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Peyton, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. Factors were the crosswind and the ditch.Jul 22, 1999 · N5696T · Substantial damageNTSB CHI99LA247Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Keokuk, IALoss of engine power for undetermined reasons.Jul 22, 1999 · N4902K · Substantial damageNTSB ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.Jul 22, 1999 · N4949E · Substantial damageNTSB FTW99LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Alvaredo, TXThe student pilot's failure to maintain a proper glidepath during his short-field approach.Jul 21, 1999 · N5230W · Substantial damageNTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.Jul 21, 1999 · N6073U · Substantial damageNTSB FTW99LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Frisco, TXThe pilot's failure to maintain directional control of the airplane during the simulated soft field takeoff.Jul 21, 1999 · N5144L · Substantial damageNTSB CHI99LA261Accident · Serious injuriesLimited investigationFinal reportHodre-Buull-Kolb Mark III · Plymouth, MNThe failure of the airplane's rudder control pulley due to corrosion and inadequate maintenance inspection of the airplane by the owner/pilot mechanic of the airplane.Jul 21, 1999 · N93JL · DestroyedNTSB SEA99LA135Accident · Minor injuriesLimited investigationFinal reportQuicksilver MX II A-HP · Coram, MTThe non-rated pilot's failure to maintain clearance from trees while taking off from a gravel pit. Factors include a downdraft.Jul 20, 1999 · UNREG · Substantial damageNTSB LAX99LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Huntington Bch, CAFuel exhaustion due to the pilot's failure to ensure that adequate fuel was on board to complete the flight. The pilot's basic lack of knowledge of the airplane's fuel capacity was a factor.Jul 20, 1999 · N60169 · Substantial damageNTSB IAD99RA057Accident · 16 fatalForeign investigationCessna 208B · Bluefields, NicaraguaJul 20, 1999 · YNCEDNTSB DEN99LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lamar, COThe left brake locked during takeoff roll for undetermined reasons.Jul 20, 1999 · N400MA · Substantial damageNTSB CHI99LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boscobel, WIthe pilot's improper approach to landing. Factors included the carburetor icing, the delayed use of carburetor heat, the unsuitable terrain for landing, and the ditch.Jul 20, 1999 · N6316P · Substantial damageNTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.Jul 20, 1999 · N3558E · Substantial damageNTSB ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.Jul 20, 1999 · N56AW · Substantial damageNTSB ATL99LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Asheboro, NCThe pilot's failure to maintain flying speed that resulted in a stall and the subsequent collision with trees.Jul 20, 1999 · N704ET · Substantial damageNTSB ANC99LA095Accident · No injuriesLimited investigationFinal reportHelio H-395 · Igiugig, AKThe pilot's inadequate compensation for wind conditions during the downwind to upwind taxi turn. Factors associated with this accident were the high crosswind, the pilot's improper use of flaps, and his self-induced pressure because he was behind schedule.Jul 20, 1999 · N4198D · Substantial damageNTSB SEA99LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Oakridge, ORThe pilot's failure to maintain aircraft control during a go-around. A downdraft during the approach is a factor.Jul 19, 1999 · N1990M · Substantial damageNTSB DEN99FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Magdalena, NMThe pilot's inadvertent flight into adverse weather and the subsequent in-flight breakup. Factors were the pilot's lack of experience in high altitude flying and the thunderstorm.Jul 19, 1999 · N22KC · DestroyedNTSB CHI99LA244Accident · No injuriesLimited investigationFinal reportCessna 182N · Green Bay, WIThe pilot's delayed flare and his improper recovery from a bounced landing.Jul 19, 1999 · N92215 · Substantial damageNTSB CHI99LA243Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marshall, MNthe inadvertent stall and the checklist not followed by the pilot. Contributing factors were the baggage door not secured and the precautionary landing attempt by the pilot.Jul 19, 1999 · N7141V · Substantial damageNTSB ANC99LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Teller, AKThe pilot's improper starting procedure.Jul 19, 1999 · N3675P · Substantial damageNTSB ANC99LA093Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingham, AKThe inadequate preflight by the pilot, which failed to detect water contamination of the airplane's fuel.Jul 19, 1999 · N3780M · Substantial damageNTSB SEA99LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Silverdale, WAThe pilot-in-command's misjudgment of distance/altitude (undershoot) on final, and his failure to maintain directional control during the aborted landing.Jul 18, 1999 · N3900D · Substantial damageNTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.Jul 18, 1999 · N235TL · Substantial damageNTSB FTW99LA193Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaumont, TXThe student pilot's excessive rate of descent resulting in the hard landing and his improper recovery from a bounced landing.Jul 18, 1999 · N150WM · Substantial damageNTSB DEN99LA122Accident · Serious injuriesLimited investigationFinal reportRader Long EZ · Buena Vista, COThe pilot's failure to maintain control of the airplane. Factors were his unfamiliarity with the airplane, and the soft terrain that caused the airplane to nose over.Jul 18, 1999 · N6577C · Destroyed