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 ANC89LA014Accident · No injuriesLimited investigationFinal reportCessna TU206A · Soldotna, AKThe ATP certificated pilot and his two passengers were returning from a hunting trip when the turbocharged Cessna 206 caught fire soon after landing. The pilot stated that the engine quit during the landing roll and an attempt at restarting the engine as the…Oct 26, 1988 · N4850F · DestroyedNTSB MKC89FA014Accident · Serious injuriesField investigationFinal reportTaylorcraft BC-12D · Lenexa, KSThe PIC had been drinking alcoholic beverages before the flt and had taken the prescription anti-depresion drug pamelor. In combination, the adverse side-effects of the drug are magnified. The PIC decided to fly instead of drive to visit a friend working the…Oct 25, 1988 · N39231 · Substantial damageNTSB MIA89LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Homestead, FLThe plt rprtd that while climbing at night after takeoff, the eng sputtered. He suspected possible water in the fuel & landed across rows in a field. Drg the landing, the gear failed & the acft came to rest on its belly with a bent prop, torn fabric & dmgd…Oct 25, 1988 · N26820 · Substantial damageNTSB MKC89LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Liberty, MOWhile flaring for a x-wind landing, the student plt saw a large brown animal running toward the rwy. He maneuvered to avoid the animal. He stated the left main gear struck the animal, then the acft went off the rwy, bounced & nosed over.Oct 24, 1988 · N60977 · Substantial damageNTSB MKC89IA012Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Springfield, MOThe a.c. generator mounted on the left engine failed and resulted in an in-flight fire. The captain elected to shut down the left engine and divert the flight to the Springfield, Missouri regional airport. A single engine precautionary landing was completed…Oct 24, 1988 · N347AM · Minor damageNTSB MIA89IA016Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · San Juan, PRThe acft departed runway 8 at 1810 ast. The plt reported a rt eng fire and declared an emergency. The acft was landed at 1815 ast, turned off the runway, and all the passengers were evacuated via the slides. According to maintenance personnel in San Juan, the…Oct 24, 1988 · N70054 · No damageNTSB DEN89LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTThe student plt was practicing takeoffs and landings, with reported winds gusting to 14 KTS. During a landing the plt misjudged the flare and attempted to go around. He said the wind raised the right wing and that he overcorrected with aileron and pulled back…Oct 24, 1988 · N757XV · Substantial damageNTSB CHI89LA017Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Mora, MNOct 24, 1988 · N1162H · DestroyedNTSB CHI89IA018Incident · No injuriesIncident investigationFinal reportBoeing B-727-200A · Chicago, ILOn departure from Chicago, Illinois, o'hare airport the aircraft experienced a loss of the inboard left main wheel. The aircraft diverted to detroit, Michigan, where it was landed with no damage to the aircraft and no injuries to the crew or passengers.…Oct 24, 1988 · N277US · Minor damageNTSB ATL89LA017Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Advance, NCDuring takeoff climb eng quit then re-started. PIC turned to the north & engine quit again. PIC stalled acft & crashed into wheat field. Acft had STC for auto gas. Fuel in acft had water & rust contaminants. Fuel lines had dried. Carb had composite float. The…Oct 24, 1988 · N5361Z · Substantial damageNTSB SEA89LA014Accident · No injuriesLimited investigationFinal reportCessna 150G · Post Falls, IDThe plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles…Oct 23, 1988 · N3691J · Substantial damageNTSB NYC89LA017Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Trumbauersville, PAAn off airport landing in which the aircraft struck trees and a swing set, following a power loss caused by the failure of the pilot to determine that the fuel selector was in the off position and to turn it on prior to the power loss.Oct 23, 1988 · N185SH · Substantial damageNTSB MKC89FA011Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Harrisonville, MOThe plt elected to fly in winds that were gusting from the northwest. He stated that while taking off to the north, he was maintaining a normal rate of climb & airspeed, but at aprx 100 ft AGL, the acft enctrd a sudden severe downdraft & was slammed to the…Oct 23, 1988 · N42676 · Substantial damageNTSB LAX89LA024Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Phoenix, AZDuring the landing roll, the airplane began to veer to the right. The pilot applied hard left rudder for a few seconds, then the left main tire came off the rim. Subsequently, the left gear collapsed and the airplane came to rest partly off the runway.Oct 23, 1988 · N5504S · Substantial damageNTSB LAX89DUJ02Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendale, AZDuring an aerial application flight the pilot reported that the right wing suddenly went up then down. The airplane rolled to the right and collided with the terrain. Inspection of the airplane revealed that the lift strut was broken. Evidence of corrosion…Oct 23, 1988 · N7229Z · Substantial damageNTSB LAX89DUJ01Accident · Serious injuriesFinal reportCessna A188A · Casa Grande, AZDuring aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.Oct 23, 1988 · N5640J · DestroyedNTSB FTW89LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Antonio, TXThe airplane had been flown for 2.2 hours since refueling when this pilot started his flight. This pilot flew the airplane for 2.5 hours and the engine quit. During the forced landing, the airplane impacted a power pole and power lines, and then the terrain.…Oct 23, 1988 · N7185Q · DestroyedNTSB CHI89LA016Accident · No injuriesLimited investigationFinal reportBeech F35 · Milwaukee, WIWhile executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…Oct 23, 1988 · N104TG · Substantial damageNTSB ANC89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ivanof Bay, AKThe pilot was attempting to land on a 30 foot wide, 1200 foot gravel strip in gusty wind conditions. He said just prior to touchdown, the airplane encountered a strong gust of wind resulting in a hard landing short of the runway. The left main landing gear…Oct 23, 1988 · N8402S · Substantial damageNTSB ANC89LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Huslia, AKThe private pilot and his adult male passenger were both severely burned when the pilot's Piper PA-18 crashed and burned following a low altitude stall and impact with trees. The pilot's wife stated that her husband told her that he was showing his passenger…Oct 23, 1988 · N7688L · Substantial damageNTSB MKC89LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Blue Springs, MOThe plt said, while cruising over a water reservoir at about 500 feet AGL, he collided with two waterfowl, believed to be geese. One struck the wing tip, the other near the wing root. Acft control remained constant with no control problems encountered, and…Oct 22, 1988 · N50932 · Substantial damageNTSB LAX89FA023Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Pine, CAPilot's failure to maintain proper altitude.Oct 22, 1988 · N140RM · DestroyedNTSB LAX89FA022Accident · 2 fatalField investigationFinal reportCessna 172N · Petaluma, CAPilot used poor judgement when he attempted v.f.r. flight during instrument meteorological conditions and that he encountered spatial disorientation when he entered into the clouds.Oct 22, 1988 · N9372E · DestroyedNTSB FTW89FA006Accident · 1 fatalField investigationFinal reportMooney M20E · Longview, TXThe airplane was in cruise flight when the pilot transmitted that he had smoke in the cockpit. 53 seconds later contact was lost. The nose and left wing were slightly down when the acft struck trees and terrain at high speed. Fire started several minutes…Oct 22, 1988 · N79373 · DestroyedNTSB DEN89LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Peyton, COA practice touch and go landing was being made on rwy 15, with winds reported as gusting to 20 knots. During the takeoff, the wing flaps would not retract and the aircraft climbed to 15 ft AGL. The pilot said he attempted to land after flying 500 yards and…Oct 22, 1988 · N9062H · Substantial damageNTSB CHI89LA015Accident · No injuriesLimited investigationFinal reportCessna 175A · Wyoming, MNOct 22, 1988 · N7063E · Substantial damageNTSB ATL89LA016Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DISCUS-B · Whitwell, TNThe plt rprtd that thermal lift deteriorated drg the return leg of a x-country flt & he elected to make an off aprt lndg in a hay field. As he was on final apch on a westerly hdg, he saw a previously undetected power line across the field, which reqd a rapid…Oct 22, 1988 · N321SB · Substantial damageNTSB ANC89LA011Accident · No injuriesLimited investigationFinal reportCessna 180 · Seldovia, AKThe private pilot was attempting to land his Cessna 180 airplane on the beach near Seldovia, AK. The main landing gear encountered a soft spot during the landing roll, and the airplane nosed over. Afterward, the pilot elected to fly the airplane to its home…Oct 22, 1988 · N820AK · Substantial damageNTSB NYC89LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Easton, PALanding short of the runway due to a power loss of unknown reason(s).Oct 21, 1988 · N56813 · Substantial damageNTSB MKC89LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Andover, KSWhile turning base to final for landing on a private grass strip, after a personal cross country flight, the aircraft stalled and fell uncontrolled to the terrain. A post accident investigation failed to reveal any malfunction of the control systems or…Oct 21, 1988 · N8641N · Substantial damageNTSB MKC89LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · Lawrence, KSThe plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.…Oct 21, 1988 · N4190N · Substantial damageNTSB MKC89LA008Accident · No injuriesLimited investigationFinal reportDavis TRI-Q-200 · Carthage, MODrg the 2nd flt of the newly constructed home built acft, the eng began to lose power shortly after takeoff. The plt reentered the pattern for a precautionary landing, but misjudged the apch & had to go around. Drg the next apch, the eng lost power…Oct 21, 1988 · N800Q · Substantial damageNTSB MKC89FA007Accident · 2 fatalField investigationFinal reportCessna T210F · Rogers, ARContinued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…Oct 21, 1988 · N6191R · DestroyedNTSB MIA89LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · La Belle, FLDuring soft field takeoff from a rough strip the acft collided with a hole causing the nose wheel to drop onto the runway hard. The nose wheel separated and the acft veered to the right and collided with a drainage ditch. .Oct 21, 1988 · N4930D · Substantial damageNTSB MIA89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tupelo, MSThe operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running…Oct 21, 1988 · N6877Y · Substantial damageNTSB MIA89FA015Accident · Serious injuriesField investigationFinal reportLake LA-4-250 · Key West, FLThe plt reduced engine power during initial climb from a touch and go landing on the gulf of Mexico. The acft stalled and descended uncontrolled back to the water, striking the water hard. The acft then bounced and again hit the water in a nose low right wing…Oct 21, 1988 · N250MW · Substantial damageNTSB LAX89DVA02Accident · No injuriesFinal reportWSK PZL Mielec PZL-M-18 · Mendota, CAOn takeoff for an aerial application flight, the aircraft failed to clear an agricultural berm 300 ft beyond the end of the runway and nosed over. The pilot stated that the aircraft was loaded with 500 gallons of sodium chlorate and that he should have…Oct 21, 1988 · N4206A · Substantial damageNTSB CHI89LA014Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Indianapolis, INShortly after liftoff and landing gear retraction, the pilot inadvertently allowed the aircraft to touch down on the runway. The pilot stated that his attention was distracted by conversation with one of the passengers and he failed to maintain a positive…Oct 21, 1988 · N7733P · Substantial damageNTSB BFO89FA003Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Frederick, MDNonsubmittedOct 21, 1988 · N8291Z · DestroyedNTSB NYC89FA015Accident · 4 fatalField investigationFinal reportBeech A24R · Blue Bell, PAImproper VFR procedures, the pilot failed to maintian adequate airspeed for the attitude of flight of the airplane causing it to stall and collide with trees and a powerline during recovery.Oct 20, 1988 · N1RJ · DestroyedNTSB DEN89FA020Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Laketown, UTThe plt departed salt lake city on a pleasure flt to bear lake to overfly a home that he owned. Witnesses near the acc site stated they saw the acft circle over the house and then depart the area over a ridge of mtns. The acft turned out over the lake and was…Oct 20, 1988 · N6069U · DestroyedNTSB LAX89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Petaluma, CADuring a telephone interview, the pilot stated that she was attempting a touch and go landing when the airplane landed hard on its nosewheel. She lost directional control and the airplane collided with a hangar. There were no problems with the nosewheel…Oct 19, 1988 · N6184H · Substantial damageNTSB LAX89FA021Accident · 1 fatalField investigationFinal reportCessna TR-182 · Paso Robles, CAThe pilot failed to maintain the proper altitude while executing the published instrument approach procedure.Oct 19, 1988 · N739YS · DestroyedNTSB LAX89FA018Accident · 2 fatalField investigationFinal reportCessna 172P · Union City, CALoss of control of the aircraft by the pilot when he inadvertently entered instrument meteorological conditions. Factors contributing to the accident were, dark night light conditions and foggy weather conditions, inadvertent flight into IMC under visual…Oct 19, 1988 · N52222 · DestroyedNTSB DEN89LA026Accident · No injuriesLimited investigationFinal reportCessna 210D · Malta, MTThe private plt, alone in the aircraft, was performing a landing on a paved road at a hunting resort. During final approach the Cessna struck power lines and damaged the nose gear. The acft touched down on the road and the nose gear collapsed. A post accident…Oct 19, 1988 · N3811Y · Substantial damageNTSB DEN89FA019Accident · 2 fatalField investigationFinal reportBell 206L-3 · Deckers, COWhile on a corporate flt thru a canyon in marginal wx conds, the helicopter collided with the static portion of a power transmission line & crashed. The acdnt occurred where a 2,554 ft span of the power line crossed the south platte river. The power line…Oct 19, 1988 · N99TV · DestroyedNTSB DEN89DTM01Accident · 1 fatalFinal reportMickelson Mark V · Ogden, UTTotal loss of engine power for reasons undetermined which resulted in a forced landing. The pilot inadvertently stalled the aircraft during the forced landing, and that is considered a factor in the accident.Oct 19, 1988 · N555KM · DestroyedNTSB CHI89LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Pekin, ILThe pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment…Oct 19, 1988 · N5711B · Substantial damageNTSB CHI89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Big Rapids, MIThe pilot stated that he failed to maintain sufficient airspeed and altitude during an IFR circle-to-land maneuver. The pilot reported that when he thought he was going to overshoot final, he tightened up the bank. The aircraft stalled and the left wing…Oct 19, 1988 · N300HF · Substantial damageNTSB ATL89LA014Accident · No injuriesLimited investigationFinal reportRockwell 114 · Palma, KYThe pilot reported a complete engine failure while descending to traffic pattern altitude. The attempts to restart the engine failed. The pilot crashed in a field. The investigation disclosed an internal magneto timing of 30 and 27 degrees respectively. The…Oct 19, 1988 · N4753W · Substantial damage