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 ANC89LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe air taxi pilot stated that he had encountered freezing drizzle and other icing conditions prior to landing, accumulating approximately 3/8' of ice on the airplane. He said that as he began his landing flare, the airplane stalled, and he was unable to…Dec 21, 1988 · N9948M · Substantial damageNTSB NYC89LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Pedricktown, NJDuring landing the pilot lost directional control of the aircraft and ran off the left side of the runway, hit a dirt bank and flipped over.Dec 20, 1988 · N24824 · DestroyedNTSB CHI89LA033Accident · No injuriesLimited investigationFinal reportCessna 414 · Pontiac, MIDec 20, 1988 · N414CM · Substantial damageNTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…Dec 20, 1988 · N17696 · Substantial damageNTSB MKC89LA042Accident · No injuriesLimited investigationFinal reportBeech 58 · Elkhart, KSWhile attempting to land in strong crosswind conditions, the plt lost directional control. The acft veered off the runway and was substantially damaged. The winds were gusting over 40 knots, with occasional gusts of 60 knots.Dec 19, 1988 · N18434 · Substantial damageNTSB MIA89LA053Accident · Minor injuriesLimited investigationFinal reportPilatus P-2/05 · St. Augustine, FLAfter an en route stop, the pilot took off in the newly acquired acft. Shortly after gear and flap retraction, the eng sustained a partial loss of power. The plt stated that all eng gages appeared normal and a turn was begun in an attempt to return to the…Dec 19, 1988 · N109PL · DestroyedNTSB ATL89IA057Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Atlanta, GA1St officer was observed to be sick & was replaced on the flt prior to departing the originating city. Subsequently, he was confronted by an intervention group regarding his condition and requested medical assistance under the company employee assistance…Dec 19, 1988 · UNK · No damageNTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.Dec 18, 1988 · N5012J · Substantial damageNTSB MKC89LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Creve Coeur, MOThe student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty…Dec 18, 1988 · N757YE · Substantial damageNTSB LAX89LA065Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Phoenix, AZThe pilot lost control during the landing roll and collided with a fence. He reported that he was completing his landing roll on runway 25L, when the aircraft was blown sideways by a gust of wind. He stated that he then applied power to avoid a ground loop.…Dec 18, 1988 · N36627 · Substantial damageNTSB DEN89LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COThe student plt was practicing a touch and go landing. During a turn to final, the plt heard an acft report final for a straight in. He said he became distracted and failed to extend the landing gear. The acft landed with the gear up and slid 500 feet, coming…Dec 18, 1988 · N6843P · Substantial damageNTSB ANC89LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt rprtd that drg an apch to land, a x-wind caused the acft to drift to the left. Subsequently, the left wing struck trees along the edge of the rwy & the acft crashed. The plt rprtd the wind was from 120 deg at 6 gusting 10 KTS.Dec 18, 1988 · N3138B · Substantial damageNTSB SEA89LA028Accident · No injuriesLimited investigationFinal reportCessna 210D · Twin Falls, IDPrior to landing, the pilot was unable to lower the nose gear by using either the normal or emergency systems. Subsequently, he landed the acft with the main gear extended & the nose gear in the retracted position. After landing, the nose gear uplock actuator…Dec 17, 1988 · N3815Y · Substantial damageNTSB NYC89LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stacyville, METhe student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run…Dec 17, 1988 · N6558P · DestroyedNTSB MKC89LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Rolla, MOWhile returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed…Dec 17, 1988 · N704LB · Substantial damageNTSB LAX89FA064Accident · 2 fatalField investigationFinal reportCessna T210L · Buena Park, CAThe pilot used poor judgement in beginning the flight with inadequate fuel; his failure to follow normal v.f.r. procedures; and his poor preflight inspection.Dec 17, 1988 · N4675Q · DestroyedNTSB DEN89LA046Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Hammond, MTThe plt, who was a veterinarian, landed his acft in rough, cultivated farm fld at a ranch in order to conduct business. Upon completion of his business, the plt selected a smoother area in the same field for takeoff. The area was smoother but was shorter and…Dec 17, 1988 · N78654 · Substantial damageNTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…Dec 17, 1988 · N6122T · Substantial damageNTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.Dec 17, 1988 · N5225K · Substantial damageNTSB SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…Dec 16, 1988 · N67638 · Substantial damageNTSB NYC89LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Lyme, CTImproper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees.Dec 16, 1988 · N63136 · Substantial damageNTSB MIA89LA051Accident · No injuriesLimited investigationFinal reportCessna 172G · Venice, FLThe pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression…Dec 16, 1988 · N4419L · Substantial damageNTSB MIA89IA052Incident · Minor injuriesIncident investigationFinal reportCessna 150 · Naples, FLTower personnel observed the acft on a high fast final apch. They stated that it appeared the acft was forced on the rwy, where it hit on the nosewheel & bounced back into the air. On the 2nd contact with the rwy, the nosewheel fork split & the nosewheel…Dec 16, 1988 · N8484U · Minor damageNTSB FTW89RA034Accident · 2 fatalForeign investigationLearjet 24B · Cuatro Cienegas, MexicoDec 16, 1988 · N234CMNTSB DEN89LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt was flying a cross-country flight. She said that 3 miles from her destination, the engine quit when the plane ran out of fuel. A landing on an ice covered asphalt road was performed. During roll out, the left main gear went off the road and the left…Dec 16, 1988 · N49209 · Substantial damageNTSB DCA89WA019Accident · No injuriesForeign investigationBoeing 747-124 · Hong Kong SAR ChinaDec 16, 1988 · N822FT · Substantial damageNTSB CHI89LA032Accident · No injuriesLimited investigationFinal reportCessna 152II · Lake In The Hls, ILThe pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience.Dec 16, 1988 · N714ZE · Substantial damageNTSB SEA89LA025Accident · No injuriesLimited investigationFinal reportCessna 177RG · Monroe, WAPlt was lndg on unlit strip (center reflectors) at night and allowed acft to drift left on lndg roll. Acft contacted dirt mound adjacent to runway.Dec 15, 1988 · N51386 · Substantial damageNTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…Dec 15, 1988 · N3110Q · DestroyedNTSB SEA89FA027Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Kasaan, AKThe plt planned to land at a seaplane base that was located in a bowl-shaped cove. Drg the landing, the acft touched down long on water swells & the plt elected to go around. Witnesses rprtd that drg the go-around, the plt initiated a steep turn while still…Dec 14, 1988 · N89U · DestroyedNTSB MIA89TF#01Accident · Serious injuriesClass 3Final reportAerospatiale AS-350B · Okeelanta, FLDec 13, 1988 · N152BC · DestroyedNTSB LAX89DVM03Accident · 1 fatalFinal reportBeard Varieze · Palo Alto, CAThe acft crashed 200 ft short of the rwy in a pond and nosed over. Witnesses heard the sounds of low power. Evidence of low/no power was shown by the prop. Investigation revealed that unapproved engine mods were made by pilot/owner. An untested carb heat…Dec 13, 1988 · N226RB · Substantial damageNTSB NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.Dec 12, 1988 · N6538G · Substantial damageNTSB NYC89LA048Accident · Serious injuriesLimited investigationFinal reportEnstrom F28F · Bradford, NHAn inflight contact with trees during takeoff after the student pilot experienced a loss of control due to his failure to adequately compensate for the winds.Dec 12, 1988 · N5699M · Substantial damageNTSB LAX89LA063Accident · No injuriesLimited investigationFinal reportHughes 369E · Hanalei, HIDuring a local sightseeing flight, the pilot reported that he heard a muffled bang and simultaneously the engine out warning lights and audio alarm activated. The pilot initiated a forced landing on the beach which resulted in the helicopter nosing over. An…Dec 12, 1988 · N7733H · Substantial damageNTSB FTW89DRA01Accident · Minor injuriesFinal reportHughes 369D · Kountze, TXFalse indications of the fuel quantity system, which led the pilot to believe ha had more fuel than he did.Dec 12, 1988 · N58261 · Substantial damageNTSB ATL89LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Athens, GADuring descent toward his intended destination, the pilot noted a floating ammeter needle and shortly thereafter he noted his oil pressure was zero. The engine seized and he selected a straight stretch of paved road for his forced landing. In the final stages…Dec 12, 1988 · N14695 · Substantial damageNTSB ANC89LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Napaskiak, AKDuring an aborted takeoff, the airplane collided with a bulldozer on the departure end of the snow covered runway. The pilot reported that he elected to abort the takeoff due to a low fuel flow indication. The director of operations stated that during an…Dec 12, 1988 · N70076 · Substantial damageNTSB NYC89LA047Accident · No injuriesLimited investigationFinal reportMooney M20J · New Alexandria, PALoss of control experience during landing rollout after an off airport landing was made due to a power loss caused by contaminated fuel. Water had been removed prior to departure.Dec 11, 1988 · N3820H · Substantial damageNTSB NYC89LA046Accident · No injuriesLimited investigationFinal reportBeech 24R · Oxford, MAFailure of the pilot to stop the aircraft on the available runway due to a long landing.Dec 11, 1988 · N9233S · Substantial damageNTSB LAX89IA062Incident · Minor injuriesIncident investigationFinal reportCessna 152 · Haleiwa, HIThe aircraft experienced a partial loss of power and collided with the terrain while completing an emergency landing in a sugar cane field. During this particular maneuver the CFI indicated that he was reasonably sure he cleared the engine at least once a few…Dec 11, 1988 · N94825 · Minor damageNTSB CHI89LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · Varna, ILThe student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A…Dec 11, 1988 · N704KV · Substantial damageNTSB MKC89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jacksonville, ARDuring a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.…Dec 10, 1988 · N8356P · Substantial damageNTSB MKC89FA038Accident · No injuriesField investigationFinal reportCessna 650 · Hutchinson, KSPurpose of flight was to prepare the left-seat pilot for a type rating, and this was his first landing since completing ground school. There was another student in the jump seat, and two more in the back of the airplane. The airplane was landing on runway 31;…Dec 10, 1988 · N61BE · Substantial damageNTSB MIA89LA049Accident · No injuriesLimited investigationFinal reportCessna 182E · Ocala, FLShortly after rotation at an alt of aprx 20 ft AGL, the plt stated the control column would not move. He closed the throttle & the acft landed hard, bounced, then came to rest off the rwy. Examination of the acft revealed 3 of the 4 lower instrument panel…Dec 10, 1988 · N9261X · Substantial damageNTSB ANC89FA022Accident · No injuriesField investigationFinal reportCessna 172I · Chugiak, AKThe pilot lost control, skidded off the left side of the wet icy runway, and nosed over in a snowbank during the landing phase of an attempted touch and go landing. He stated that while on downwind, he saw the wind sock indicate a change of wind direction,…Dec 10, 1988 · N8319L · Substantial damageNTSB DCA89LA012Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2J · Missing (Pacific Ocean)During a flt at night from majuro, marshall islands to cairns, australia, the plt requested a dscnt from FL 190 to 12,000 to remove ice from the airframe. Later, he requested a climb to FL 200. After starting the climb, he made a mayday call to sidney flt…Dec 9, 1988 · N296MA · DestroyedNTSB ATL89LA052Accident · No injuriesLimited investigationFinal reportCessna 150M · Walbridge, OHDrg a dual instructional flt, the student plt made an apch to rwy 22 on a dark night using the VASI. According to the instructor (CFI), the student leveled the acft aprx 8 to 10 ft above the rwy & allowed the airspeed to decay. The CFI warned the student &…Dec 9, 1988 · N714MK · Substantial damageNTSB ATL89FA054Accident · 2 fatalField investigationFinal reportAero Commander 720 · Alcoa, TNAfter encountering icing conditions in flight and experiencing problems maintaining altitudes and headings, the pilot elected to divert from his planned destination of dayton, oh to knoxville, TN. While on final approach after descending 1300 ft below minimum…Dec 9, 1988 · N120G · DestroyedNTSB MKC89LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crete, NEThe pvt pilot said shortly after takeoff, the engine coughed, sputtered, then quit. An emergency ldg was attempted on a farm field which resulted in substantial damage to the acft, serious injury to the pax and minor injuries to the pilot. Post accident…Dec 8, 1988 · N5875W · Substantial damage