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 NYC88FA072Accident · 1 fatalField investigationFinal reportCessna 337E · Friedens, PAThe 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…Feb 2, 1988 · N1201M · DestroyedNTSB MKC88IA046Incident · Minor injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Fayetteville, ARThe capt rprtd that drg the lndg roll, there was a loud noise from the left eng followed by hvy smoke & an eng fire warning bell. He stopped the acft on a twy & ordered an evacuation. The flt attendant had difficulty opening the floor-level emerg exit. No…Feb 2, 1988 · N322PX · Minor damageNTSB LAX88FA103Accident · 2 fatalField investigationFinal reportCessna 150J · Douglas, AZInadvertent entry into a stall/spin by the pilot-in-command.Feb 2, 1988 · N61305 · DestroyedNTSB LAX88FA101Accident · 2 fatalField investigationFinal reportCessna U206F · Lk Havasu City, AZPilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.Feb 2, 1988 · N60566 · DestroyedNTSB SEA88LA043Accident · 2 fatalLimited investigationFinal reportBeech 58P · Ketchikan, AKAcft collided with trees 1400 ft short of rwy during ILS approach. The acft was left of centerline and about 100 ft below glideslope at that time. Witnesses heard sounds of increased power and impact. When the approach clearance was given the wx was 1000 ft…Feb 1, 1988 · N3689D · DestroyedNTSB NYC88LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Bangor, METhe crew rprtd that drg takeoff, a power surge occurred after the acft had climbed about 400 to 500 ft. the coplt saw what he later said was a right fuel flow fluctuation & told the plt (PIC) that the right eng was losing power. The PIC told the coplt to…Feb 1, 1988 · N4175G · Substantial damageNTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDFeb 1, 1988 · N11312 · Substantial damageNTSB BFO88LA016Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Wheeling, WVThe acft landed after an ILS apch to rwy 03. According to the plt shortly after touchdown he saw deer ahead on the rwy. Before he could take evasive action the acft struck two deer. Afterwards brake pressure was lost. The plt steered the acft onto grass off…Feb 1, 1988 · N287W · Substantial damageNTSB NYC88LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Meriden, CTAfter performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass…Jan 31, 1988 · N1077D · Substantial damageNTSB MIA88LA098Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Clearwater, FLPlt stated acft stalled during landing flare resulting in a hard landing. After the hard landing the acft bounced into the air and veered to the left. Before a go-around could be completed the acft collided with a dirt mound between the runway and taxiway…Jan 31, 1988 · N28571 · Substantial damageNTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.Jan 31, 1988 · N9260U · Substantial damageNTSB MIA88FA097Accident · Serious injuriesField investigationFinal reportTimm N2T-1 · Pompano Beach, FLPilot experienced complete loss of engine power while on short final. While making forced landing on a city street the acft collided with a car. Post crash examination of the acft and crash site revealed the acft to contain approx. 3 ounces of fuel with no…Jan 31, 1988 · N60789 · DestroyedNTSB LAX88LA104Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAAt the end of a local pleasure flight, during the landing roll, the pilot lost control of the aircraft and ground looped. There were no reported mechanical failures or malfunctions of the aircraft.Jan 31, 1988 · N5058K · Substantial damageNTSB DEN88LA073Accident · No injuriesLimited investigationFinal reportCessna 182R · Pueblo, COThe instrument rated pvt plt was completing a personal IFR flight from telluride, Colorado, to Colorado springs, Colorado, with three pax. The destination wx went below IFR minimums prior to the flight's arrival and the aircraft diverted to Pueblo, Colorado,…Jan 31, 1988 · N9393H · Substantial damageNTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…Jan 31, 1988 · N9458U · DestroyedNTSB ATL88LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Barnwell, SCThe CFI and her student became lost on the last leg of a dual x-c flt after encountering rainshowers and low ceilings. After unsuccessfully attempting to locate their destination arpt, the CFI located another arpt and elected to land there. The engine…Jan 31, 1988 · N6254G · Substantial damageNTSB MIA88LA095Accident · No injuriesLimited investigationFinal reportSikorsky S-58E · Sanford, FLPlt was attempting to give himself a checkout in the helicopter for he believed the fee for a check plt was too expensive. During a second attempt at hover flt he positioned himself with a 90 degree, 12 knot right crosswind. As the acft became light on the…Jan 30, 1988 · N2769P · Substantial damageNTSB FTW88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe airplane was descending toward the airport when the engine lost power. Application of carburetor heat restored power until next descent. Second descent was started with full carburetor heat applied and power was lost again and could not be restored. Pilot…Jan 30, 1988 · N6614H · DestroyedNTSB DEN88LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Peyton, COJan 30, 1988 · N62491 · Substantial damageNTSB ANC88LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Cold Bay, AKThe ATP certificated pilot in command departed on a solo, cargo-only air-taxi flight at 1104 a.k.s.t. for a destination 83SM to the n.e. the pilot was normally assigned to copilot duties on a multi-engined airplane, and was not familiar with the terrain he…Jan 30, 1988 · N123TA · Substantial damageNTSB SEA88LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Twin Falls, IDWhen the pilot attempted to reduce power to descend to land he was unable to obtain a power reduction due to the throttle rod end separating in flight. The pilot made a spiralling descent and then shut down the engine. The pilot misjudged his altitude and…Jan 29, 1988 · N4290R · Substantial damageNTSB LAX88IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227AC · S. Lake Tahoe, CACaptain's failure to follow flight manual procedures in the operation of the anti-ice/de-ice systems.Jan 29, 1988 · N368AE · No damageNTSB ATL88DKG03Accident · 1 fatalFinal reportDavis RV-3 · Loxley, ALThe pilot was making touch and go landings at a private airstrip. On the third takeoff witnesses said the aircraft climbed steeply and appeared to enter a hammerhead stall. The aircraft impacted the ground near the departure end of the runway. The…Jan 29, 1988 · N1387K · DestroyedNTSB NYC88LA074Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Decatur, MIThe flight attendant was pulling a beverage cart up the aisle when the pad the coffee pot was resting on caught against a curtain. The pad was pulled off the cart and the full pot of coffee spilled in a passengers lap. The passenger service cart has a…Jan 28, 1988 · N262AA · No damageNTSB MKC88LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Ottawa, KSThe student pilot was on a solo cross country flight. During the landing, the aircraft began to porpoise. The pilot performed remedial action, however, the aircraft had already sustained substantial damage.Jan 28, 1988 · N4717A · Substantial damageNTSB MKC88LA045Accident · No injuriesLimited investigationFinal reportCessna 195 · Rolla, MOShortly after takeoff, during a personal flight, the engine progressively lost power. The PIC attempted an emergency ldg in a pasture. During the ldg roll, the acft collided with a tree, causing substantial damage to the right wing. Post accident aircraft…Jan 28, 1988 · N1071D · Substantial damageNTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…Jan 28, 1988 · N1246T · Substantial damageNTSB ATL88FA085Accident · Serious injuriesField investigationFinal reportBell 204B · Stockton, ALJan 28, 1988 · N8514F · DestroyedNTSB SEA88LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172M · St. Anthony, IDDuring landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted.Jan 27, 1988 · N2320E · Substantial damageNTSB MIA88LA093Accident · No injuriesLimited investigationFinal reportCessna 305A · Chuluota, FLPlt stated electric boost pump was operated longer than normal during power off glide for banner pickup. After banner pickup when full throttle was applied for climb the engine sputtered and lost power. The nose was lowered in preparation for a landing…Jan 27, 1988 · N5290G · Substantial damageNTSB MIA88FA094Accident · 1 fatalField investigationFinal reportCessna 411 · Venice, FLWitnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into…Jan 27, 1988 · N235UV · DestroyedNTSB LAX88LA100Accident · No injuriesLimited investigationFinal reportCessna 150F · Lake Havasu Cty, AZDuring a pleasure flt, while on final approach, the engine experienced a pwr loss. An emergency landing was made short of the rwy where the acft collided with a telephone pole, slowing the acft during the landing roll. Inspection of the engine revealed that…Jan 27, 1988 · N7069F · Substantial damageNTSB LAX88LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · El Toro, CAThe student plt was practicing touch-&-go landings & was cleared for an apch behind a C-130. He stated that he noted the touchdown point of the C-130 & planned his apch to remain above the C-130'S flt path. However, just before landing, when the acft was at…Jan 27, 1988 · N4914H · DestroyedNTSB LAX88DUK01Accident · Minor injuriesFinal reportColman BD-4 · Half Moon Bay, CAJan 27, 1988 · N49RC · Substantial damageNTSB CHI88LA054Accident · Minor injuriesLimited investigationFinal reportMooney M20A · La Porte, INThe aircraft experienced a complete power failure and while the pilot was attempting to make an emergency landing ran through a fence and between two trees substantially damaging the aircraft. The pilot sustained minor injuries. Post acc invest revealed a…Jan 27, 1988 · N6072X · Substantial damageNTSB NYC88IA078Incident · No injuriesIncident investigationFinal reportBeech 1900C · Philadelphia, PAThe Beech 1900C took off on a scheduled commuter flt. When attempting to level the aircraft at 5000 ft, the co-pilot was unable to push the control wheel forward FAR enough to level off. By reducing power, the crew was able to compensate. The crew…Jan 26, 1988 · N818BE · No damageNTSB LAX88LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Diamond Springs, CADuring a dual instructional flt, approaching the airport the engine experienced a total loss of power. The plt made a forced landing in a field where during the landing roll the acft nosed over. There were no mechanical failures or malfunctions reported. The…Jan 26, 1988 · N1706Q · Substantial damageNTSB LAX88LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Redbluff, CADuring a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…Jan 26, 1988 · N7929E · Substantial damageNTSB FTW88DQG03Accident · No injuriesFinal reportBeech G35 · Friona, TXAfter touchdown on the landing strip, the left landing gear collapsed, and the airplane went off the left side of the strip. The airplane went into a water pit, and struck a pump station and associated equipment. Later the pilot stated to his son that he had…Jan 26, 1988 · N313B · Substantial damageNTSB CHI88LA053Accident · No injuriesLimited investigationFinal reportCessna T310R · Urbana, ILAfter the aircraft experienced a complete electrical failure the gear was extended manually and a precautionary landing was made. On roll out the landing gear collapsed. Subsequent investigation revealed that 10 turns remained on the manual gear extension…Jan 26, 1988 · N5120J · Substantial damageNTSB ATL88LA084Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Block Island, RIThe capt rptdly advised the flight attendants to secure the cabin and be seated due to turbulence expected during descent. About 5 minutes later, the airplane briefly encountered severe turbulence while passing through about FL230. A flight attendant…Jan 26, 1988 · N117DL · No damageNTSB FTW88LA054Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Borger, TXShortly after takeoff there was smoke in the cabin. The plt started a turn back toward the runway. When he turned off the electrical master switch the engine stopped producing power. Attempts to restart the engine were not successful. He impacted a heavy…Jan 25, 1988 · N8250R · Substantial damageNTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…Jan 24, 1988 · N3316Z · Substantial damageNTSB NYC88FA069Accident · 2 fatalField investigationFinal reportCessna 182L · Waynesburg, PAShortly after departure from runway 26, the aircraft engine failed. The aircraft banked to about 90 degrees, descended and impacted the ground. A flight instructor described the wind as very gusty and varying out of the south at approximately 10-20 knots. The…Jan 24, 1988 · N3467R · DestroyedNTSB LAX88LA095Accident · No injuriesLimited investigationFinal reportHughes 369D · Rialto, CAJan 24, 1988 · N8366F · Substantial damageNTSB CHI88LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Fond Du Lac, WIJan 24, 1988 · N75716 · Substantial damageNTSB CHI88DEP03Accident · Minor injuriesFinal reportPiper PA-38-112 · Sheboygan, WIThe aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.Jan 24, 1988 · N25760 · Substantial damageNTSB BFO88FA014Accident · No injuriesField investigationFinal reportCessna T210N · Sterling, VAAbt 2.7 hrs after takeoff, the student plt & instructor (CFI) were practicing instrument apchs when the eng lost pwr. The CFI took control of the acft & made a forced lndg, but the acft was damaged on rough terrain. An exam of the acft revealed the right &…Jan 24, 1988 · N5350A · Substantial damageNTSB NYC88LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Mendon, MAOff airport landing due to engine power loss for undetermined reasons.Jan 23, 1988 · N663FL · DestroyedNTSB LAX88LA093Accident · 2 fatalLimited investigationFinal reportCessna TU206G · Kirkland, AZDuring a cross country flt, the acft struck power lines that were stretched across a canyon. The unmarked wires were aprx 500 ft AGL. There were no reported mechanical failures or malfunctions. No explanation was given for the low flying.Jan 23, 1988 · N4884U · Destroyed