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 MKC89LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Derby, KSDrg an eng run-up before a simulated instrument flt, the crew noticed the carb heat control would only move about 1/2 of its normal travel. The plts discussed the malfunction & ran the eng for another 1 to 2 min until the oil temp gauge indcd a temp rise. Drg…Dec 28, 1988 · N2213T · Substantial damageNTSB MIA89LA059Accident · No injuriesLimited investigationFinal reportCessna 177A · West Palm Beach, FLThe private pilot contacted lakeland tower in flt about 2115 and was told that no fuel was available. He elected to continue flt. The pilot experienced an engine failure due to fuel exhaustion after 4 hours and 12 minutes of flight. He then executed a forced…Dec 28, 1988 · N30564 · Substantial damageNTSB FTW89LA033Accident · Serious injuriesLimited investigationFinal reportCessna TU206D · Alamo, TXAirplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct.Dec 28, 1988 · N72249 · DestroyedNTSB ANC89LA029Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kivalina, AKThe air taxi pilot was on a scheduled cargo flight to a remote village in western Alaska when he reportedly had a partial loss of engine power. He said that he was unable to maintain altitude and made a forced landing on a frozen lake. He is uncertain why the…Dec 28, 1988 · N9651M · Substantial damageNTSB SEA89LA030Accident · 1 fatalLimited investigationFinal reportCessna 205 · Cottage Grove, ORThe student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'…Dec 27, 1988 · N8403Z · DestroyedNTSB LAX89LA071Accident · Serious injuriesLimited investigationFinal reportUnivair Globe GC-1B · Chino, CA**This report was modified on 2/24/2016. Please refer to the public docket for this accident for additional information.** The pilot's failure to maintain airspeed during an emergency landing following an inflight loss of engine power, resulting in an…Dec 27, 1988 · N3388K · Substantial damageNTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INDec 27, 1988 · N5457A · Substantial damageNTSB SEA89LA029Accident · Minor injuriesLimited investigationFinal reportBell 47G3-B1 · Newberg, ORAs plt slowed helicopter to about 10 KTS forward speed, tail rotor effectiveness decreased. Acft yawed right into descent to ground contact.Dec 26, 1988 · N8587F · Substantial damageNTSB NYC89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Wiscasset, METhe plt lost control during an attempted go-around, and collided with trees off the side of the runway. The pilot said that a gust of wind turned the acft 45 degrees to the runway on landing roll, and during the attempted go-around he hit tree tops off to the…Dec 26, 1988 · N3736S · Substantial damageNTSB LAX89LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Corona, CAThe aircraft was found abandoned at the airport. A witness reported that the aircraft had flipped over on runway 25. The sole occupant, a male, was not injured. The aircraft was moved by the occupant and several other unidentified people to a tiedown area on…Dec 26, 1988 · N89891 · Substantial damageNTSB DCA89IA016Incident · Minor injuriesIncident investigationFinal reportBoeing 727-25 · Morgantown, WVFuselage skin 'flapped' open between body stations 1090 and 1110 and peeled downward from stringer #4 left to stringer #5 left. A scratch or scribe mark was co-located with the longitudinal crack along stringer #4. The area of damage was located on the aft…Dec 26, 1988 · N8148N · Minor damageNTSB CHI89FA036Accident · 4 fatalField investigationFinal reportBeech B23 · Jeffersonville, INPilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.Dec 26, 1988 · N6100N · DestroyedNTSB ATL89DKJ01Accident · Serious injuriesFinal reportSloan RV-4 · Russellville, ALWhile cruising at 2500 feet with ram air gate open, engine began to run rough. The plt closed the ram air gate and applied carb heat but the engine continued to run rough and then stopped. The pilot attempted to land in an open field, clearing several large…Dec 26, 1988 · N77SA · Substantial damageNTSB MKC89LA044Accident · Minor injuriesLimited investigationFinal reportMaule M-7 · Harrisonville, MODuring a crosswind landing the pilot lost directional control of the aircraft. The pilot elected to abort the landing by applying takeoff power and becoming airborne. The pilot attempted a turn at low airspeed and low altitude to avoid trees in his flight…Dec 25, 1988 · N132HL · Substantial damageNTSB LAX89FA074Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Yucca, AZPilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the…Dec 25, 1988 · N9276M · DestroyedNTSB SEA89LA031Accident · No injuriesLimited investigationFinal reportBeech 99A · Spokane, WAAcft was left overnight in heavy precip. Plt failed to ensure fuselage drains were clear and water accumulation drained before departing into below freezing flight temps. On lndg at dest, plt unable to achieve flare, resulting in hard lndg. Investigation…Dec 24, 1988 · N4954W · Substantial damageNTSB NYC89LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180T · Princeton, NJThe acft experienced a loss of power of both engines and crashed into trees near Princeton airport, Princeton, NJ. The pilot flew 4.5 hrs and after a missed approach one engine quit. While attempting to make Princeton airport the other engine quit. According…Dec 24, 1988 · N91PA · DestroyedNTSB NYC89FA059Accident · 1 fatalField investigationFinal reportBeech A36 · Bridgeport, CTTwice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…Dec 24, 1988 · N262C · DestroyedNTSB NYC89FA056Accident · 3 fatalField investigationFinal reportBeech A36 · Harrison, NYThe plt was clrd for an IFR departure from rwy 16 in instrument meteorological conditions (IMC). His departure clnc was to climb on rwy heading to 800 ft, then turn right to a heading of 320 deg. When the acft took off, tower psnl did not have visual contact…Dec 24, 1988 · N555ST · DestroyedNTSB MKC89LA046Accident · No injuriesLimited investigationFinal reportBeech A23A · California, MOThe pvt pilot said while attempting a downwind takeoff on a dark night from an unlighted sod strip, he received an intermittent stall warning horn shortly after lift-off. He lowered the nose and the acft struck the runway and rebounded into the air. He said…Dec 24, 1988 · N2364W · Substantial damageNTSB MIA89LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Starke, FLFlt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…Dec 24, 1988 · N9373B · Substantial damageNTSB LAX89FA069Accident · 2 fatalField investigationFinal reportCessna T210L · Norco, CAAccident was that the pilot became disoriented and was unable to arrest the ensuing descending spiraling turn.Dec 24, 1988 · N94210 · DestroyedNTSB DEN89LA048Accident · No injuriesLimited investigationFinal reportCessna TR182 · Lamar, COThe pilot was making a VFR approach for landing. The landing gear was lowered and full flaps were deployed. The pilot said he allowed the airspeed to get too low and the aircraft stalled. The nose and left wing dropped and the pilot added full power. The nose…Dec 24, 1988 · N757MU · DestroyedNTSB DEN89IA047Incident · No injuriesIncident investigationFinal reportCessna 210L · Roswell, NMPlt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt…Dec 24, 1988 · N59217 · Minor damageNTSB CHI89FA035Accident · 2 fatalField investigationFinal reportCessna 310R · Madison, INPilot-in-command's disregard of IFR procedures in descending below the minimum decision height for the approach to a point where collision with towers and/or wires became possible. His abrupt maneuver to avoid such collision resulted in a stall/spin, from…Dec 24, 1988 · N5121J · DestroyedNTSB ATL89FA061Accident · 2 fatalField investigationFinal reportCessna 210B · Mt Airy, NCThe pilot attempted to locate the destination airport in instrument meteorological conditions, and his failure to maintain a sufficient altitude to avoid the terrain in the area. Factors contributing to the accident were the pilot' overconfidence in his…Dec 24, 1988 · N210RW · DestroyedNTSB ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…Dec 24, 1988 · N8193B · DestroyedNTSB MIA89LA057Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Kissimmee, FLThe plt stated that he was repositioning the acft for fuel, and during a practice autorotation attempt the engine hydro-mechanical clutch failed. It did not re-engage upon the application of power and the acft was landed hard.Dec 23, 1988 · N45726 · Substantial damageNTSB MIA89LA056Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Crystal River, FLThe plt stated that he was giving a friend a ride in the acft when he inadvertantly struck powerlines and crashed in shallow water.Dec 23, 1988 · N1025J · Substantial damageNTSB LAX89LA068Accident · Serious injuriesLimited investigationFinal reportBoeing 747SP-21 · Midway Islands (Pacific Ocean)Aircraft's encounter with unforecast severve clear turbulence.Dec 23, 1988 · N146UA · No damageNTSB LAX89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Victorville, CADuring cruise flight, the engine lost power. The pilot initiated a forced landing on an interstate. During the descent, the airplane collided with transmission wires and subsequently came to rest on interstate 15. During an inspection of the wreckage, it was…Dec 23, 1988 · N4297X · Substantial damageNTSB DEN89LA049Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Winnett, MTThe pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…Dec 23, 1988 · N5570H · Substantial damageNTSB ATL89LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Sandusky, OHThe plt landed the acft on rwy 27 in winds that he estimated were from 240 deg at 10 to 15 KTS with gusts to 25 KTS. He stated that when the groundspeed had slowed to about 20 KTS, the left wing started to raise. He applied full power & the acft lifted off…Dec 23, 1988 · N1176D · Substantial damageNTSB ATL89LA060Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Gilbertsville, KYDuring preflt inspection fuel was noted to be up to the slots in the tab for the reduced fuel indicators, or 20 gal each tank. A 3 hour, dark night, cross country was flown to destination. PIC said acft arrived with about 5 gal fuel remaining in each tank. On…Dec 23, 1988 · N6046V · Substantial damageNTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHDec 23, 1988 · N84UM · DestroyedNTSB NYC89LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hyannis, MAThe acft ran off the runway and hit a landing light and terrain as the pilot attempted to make a crosswind landing, at barnstable airport, Hyannis, MA.Dec 22, 1988 · N5465P · Substantial damageNTSB NYC89FA053Accident · 2 fatalField investigationFinal reportCessna 414 · Franklin Twp, PABefore takeoff, the crew indcd the flt would be for 'check rides' & that they planned to 'shoot approaches' & proceed to the practice area to do some airwork. ATC advised the plts that the cloud bases were at 3500 feet MSL. Elevation of the terrain (where the…Dec 22, 1988 · N244RM · DestroyedNTSB MKC89LA045Accident · No injuriesLimited investigationFinal reportCessna 175 · Lawrence, KSThe plt said that shortly after takeoff, the engine began to misfire and lose power. He elected to abort the takeoff, but was unable to stop on the remaining portion of the runway. He ran off the end, into a farm field, where the acft nosed down and was…Dec 22, 1988 · N7159M · Substantial damageNTSB MKC89FA043Accident · 3 fatalField investigationFinal reportBell 206L-1 · Cape Girardeau, MOThe helicopter was dispatched at night on an emerg med svc (EMS) flt fm a hospital at Cape Girardeau, MO. Purpose of theflt was to transport a patient fm a hospital at marion, IL, to Cape Girardeau. Wx at Cape Girardeau deteriorated after the acft departed.…Dec 22, 1988 · N119CG · DestroyedNTSB MIA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLThe plt stated that he had been given a short approach for runway 4, when the tower told him to go around. He added power, retracted the flaps, and made a sharp right turn. The acft stalled and crashed into an office building aprx 1 mile from the airport.Dec 22, 1988 · N5160F · Substantial damageNTSB LAX89LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Hesperia, CAAt the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…Dec 22, 1988 · N1542Q · Substantial damageNTSB FTW89LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Houma, LAThe airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…Dec 22, 1988 · N6444U · Substantial damageNTSB CHI89IA034Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Mosinee, WIStall induced by the accretion of moderate to severe clear icing.Dec 22, 1988 · N427MQ · No damageNTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.Dec 22, 1988 · N50331 · Substantial damageNTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…Dec 21, 1988 · N2251F · DestroyedNTSB LAX89LA073Accident · 1 fatalLimited investigationFinal reportBell 206L-1 · Oakland, CAPilots intentional flight into known adverse weather condititions from which he inadvertently descended into the water at a high rate of speed. Contributing to the accident was the pilot's failure to obtain a weather briefing; lack of recent instrument flying…Dec 21, 1988 · N1072S · DestroyedNTSB FTW89DPJ02Accident · 2 fatalFinal reportErcoupe 415C · Oklahoma City, OKDuring flight, the airplane appeared to go into a steep banked spiral from which it did not recover. It struck a two-car detached garage and then the ground. Inspection revealed that the fabric of both wings had been installed improperly, and part of the…Dec 21, 1988 · N99636 · DestroyedNTSB DEN89FA045Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elephant Butte, NMDuring a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…Dec 21, 1988 · N751SP · DestroyedNTSB DCA89RA014Accident · 270 fatalForeign investigationBoeing 747-121 · Lockerbie, United KingdomDec 21, 1988 · N739PANTSB ANC89LA026Accident · No injuriesLimited investigationFinal reportCessna 185 · Porcupine Lodge, AKThe aircraft was taxiing for takeoff on the frozen Porcupine river in rural Alaska when the right main landing gear broke through the river ice, allowing the right wing to strike the ice. The pilot stated that he had landed on the river near the Porcupine…Dec 21, 1988 · N70087 · Substantial damage