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 MIA89FA044Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Molino, FLBefore takeoff, the plt was adzd of an apchg cold front in the Florida panhandle as well as a forecast of hvy thunder- storm activity in the area of pensacola. En route, he was provided VFR flt following from pensacola apch ctl while cruising at 6500 ft.…Nov 27, 1988 · N8033Y · DestroyedNTSB FTW89FA025Accident · 1 fatalField investigationFinal reportLuscombe 8E · Port Lavaca, TXThere were no records to indicate the non-instrument rated pilot received a pre-flight weather briefing from any weather reporting service. Witnesses in the area of the accident stated the night was dark and the ground was covered with fog. The airplane…Nov 27, 1988 · N2301K · DestroyedNTSB DEN89LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casper, WYThe plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground…Nov 27, 1988 · N743L · Substantial damageNTSB NYC89LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Danielson, CTFailure of the pilot to recognize a stall and take corrective action prior to experiencing a loss of control.Nov 26, 1988 · N8172P · DestroyedNTSB ATL89FA045Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Concord, NCPIC & wife flew to local residential area to photograph a house. The acft was flown in the vicinity of the accident for about 30 minutes. Radar data displayed the acft in a level left turn at 2300 feet (1700 AGL) for about 50 seconds when contact was abruptly…Nov 26, 1988 · N98369 · DestroyedNTSB NYC89LA040Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Erwinna, PAOff airport landing in unsuitable terrain due to a power loss caused by carburetor icing.Nov 25, 1988 · N8572V · Substantial damageNTSB LAX89FA058Accident · 2 fatalField investigationFinal reportCessna 182R · Gorman, CAThe aircraft entered into an uncontrolled descent. The existence of a mountain wave along the aircraft's flight route, the failure of the crew to evaluate reported weather conditions along the flight route, the crews attempt to fly into known adverse weather…Nov 25, 1988 · N5545N · DestroyedNTSB ATL89LA046Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Hamilton, OHThe pilot lost directional control while practicing crosswind landings. The winds were reported at 10 with gusts to 15 knots. The pilot did not report having an airplane system problem.Nov 25, 1988 · N45TC · Substantial damageNTSB ANC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.Nov 25, 1988 · N2930M · Substantial damageNTSB FTW89FA024Accident · 2 fatalField investigationFinal reportCessna 337A · Weatherford, TXThe pilot failed to maintain minimum required airspeed for slow flight (vs), resulting in a stall with insufficient altitude to recover. A contributing factor was the Piper pilot's unannounced fly-by, which diverted the Cessna pilot's attention.Nov 24, 1988 · N5337S · DestroyedNTSB DEN89FA036Accident · 5 fatalField investigationFinal reportCessna T210F · Cortez, COThe plt obtained a wx briefing from las vegas fss and was told that flt under VFR was not recommended for the proposed flt to durango (dro). The plt filed a VFR flt plan and departed las vegas. Over page, AZ, he filed a PIREP and was again told VFR flt not…Nov 24, 1988 · N6105R · DestroyedNTSB CHI89LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marquette, MIAfter encountering unforecast adverse wx at his intended destn, the plt circled the area a couple of times, then diverted to Marquette, MI. However, before reaching the alternate arpt, the eng lost power due to fuel exhaustion. Subsequently, the acft collided…Nov 24, 1988 · N3662W · Substantial damageNTSB CHI89FA027Accident · 2 fatalField investigationFinal reportGulfstream AA1A · North Vernon, INThe aircraft was observed to make a high speed low level pass adjacent to the runway and a climbing left turn away from the airport, heading north. A witness in a field north of the airport reported seeing the aircraft descending from a low altitude, level…Nov 24, 1988 · N9396L · DestroyedNTSB NYC89LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Berlin, NJOff airport landing in unsuitable terrain following a power loss due to fuel exhaustion in the selected tank with useable fuel in the other tank.Nov 23, 1988 · N4341T · DestroyedNTSB FTW89LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Chalmette, LAThe rated pilot's inadequate takeoff technique the the instructor pilot's momentary lack of judgement in having the pilot attempt a hydraulics off takeoff.Nov 23, 1988 · N83109 · Substantial damageNTSB BFO89FA012Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Meadows Of Dan, VAThe pilot conducted VFR flight into IMC because of inadequate inflight planning/decision. The aircraft experienced inflight brakup when the pilot was unable to maintain flight within the design stress limits of the aircraft.Nov 23, 1988 · N4194W · DestroyedNTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…Nov 23, 1988 · N6711P · Substantial damageNTSB NYC89LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palmyra, NYOff airport landing in a canal following a power loss caused by fuel exhaustion due to miscalculated fuel burn by the pilot.Nov 22, 1988 · N2885G · Substantial damageNTSB MKC89LA029Accident · No injuriesLimited investigationFinal reportAerospatiale TB-21 · Clinton, IAThe plt rprtd that while cruising at 10,000' & monitoring the eng instruments in a normal manner, power was suddenly lost as if by fuel starvation. He stated that emerg procedures were performed, but he was unable to restart the eng in spite of fuel in both…Nov 22, 1988 · N20GF · Substantial damageNTSB MKC89LA026Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Salisbury, MOThe pilot said shortly after takeoff the engine lost power. He attempted to land on a plowed field, and after rolling about fifty yards on the rough, soft terrain, the aircraft nosed over. Post accident investigation revealed the engine lost power due to fuel…Nov 22, 1988 · N8927C · Substantial damageNTSB LAX89LA056Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Twentynine Palm, CAThe pilot stated that while landing, during the flare, a gust of wind raised the left wing. The pilot corrected just prior to touchdown. When the airplane touched down it ground looped to the right. The airplane ran off the runway and collided with a berm and…Nov 22, 1988 · N8695V · Substantial damageNTSB LAX89LA055Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAThe pilot stated that he lost directional control of the gyroplane during the landing roll, departed the rwy and nosed over. The gyroplane touched down normally on the main landing gear at an indicated airspeed of about 20 mph. As the gyroplane slowed…Nov 22, 1988 · N6113S · Substantial damageNTSB ATL89LA043Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomaston, GAThe pilot and three passengers were on a night flight in an aircraft that was equipped to carry skydivers. During the approach to land, the landing light failed. While attempting to get the light to operate, the pilot allowed an undershoot to develop.…Nov 22, 1988 · N5473B · Substantial damageNTSB ANC89IA019Incident · No injuriesIncident investigationFinal reportCessna A185F · Deadhorse, AKAcft bounced several times during landing. The pilot collapsed shortly after getting out of the airplane. Blood samples, taken from the pilot three hours after landing, contained 22.1% carbon monoxide. The left engine muffler overboard tube was broken loose…Nov 22, 1988 · N20752 · No damageNTSB NYC89LA034Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Oxford, CTCollision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.Nov 20, 1988 · N468CM · DestroyedNTSB MKC89LA028Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lino Lakes, MNShortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…Nov 20, 1988 · N12MZ · Substantial damageNTSB MIA89LA041Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ocala, FLThe plt stated that while switching to the right fuel tank, the eng quit and he was unable to restart it. While attempting a forced landing in a field, the gear collapsed resulting in damage to the wings and flaps. Over 40 gallons of fuel were found in the…Nov 20, 1988 · N9064P · Substantial damageNTSB MIA89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLThe student pilot reported that during preflight inspection, he did not replace the oil cap after he checked the oil. Subsequently, oil was vented overboard during flight & the engine lost power. The nose gear collapsed during a forced landing.Nov 20, 1988 · N8262B · Substantial damageNTSB MIA89LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Holly Springs, MSThe plt stated that after he began a descent from 12,000 ft to 4000 ft, the acft lost all electrical power due to failure of the alternator. While apchg to land at Holly Springs arpt, the acft enctrd unfavorable winds & turbulence. Subsequently, it lost…Nov 20, 1988 · N4908F · DestroyedNTSB LAX89LA054Accident · No injuriesLimited investigationFinal reportCessna 175 · Tracy, CAThe airplane was found nosed over and abandoned short of the airport. The owner of the airplane was identified as the pilot, however, he does not hold a pilots license nor a medical certificate. Inspection of the airplane revealed that the fuel tanks were…Nov 20, 1988 · N6641E · Substantial damageNTSB FTW89FA023Accident · 2 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKThe plt was briefed on flt prctns for IFR conds, tstms & ocnl mod rime icing. Drg the climb, he told ATC he was having trouble with his vacuum & was disoriented. ATC clrd him for altitudes he could use & bgn providing no-gyro vectors. A wxcheck revealed there…Nov 20, 1988 · N6639R · DestroyedNTSB ATL89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Union City, TNPIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the…Nov 20, 1988 · N27947 · Substantial damageNTSB SEA89LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Oregon City, ORThe pilot was landing his aircraft on a very wet 1,170 foot grass runway. The pilot was not able to stop the aircraft before it collided with a fence at the end of the runway. According to the manufacturers performance figures, under the given temperature and…Nov 19, 1988 · N6408G · Substantial damageNTSB NYC89FA036Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Gans, PAPilot's bad judgement in flying in weather conditions beyond the capabilities of his aircraft. The pilot overstressed the aircraft and sheared the left wing by making an abrupt turn in turbulent air above the design maneuvering speed (VA). The accumulation of…Nov 19, 1988 · N2153U · DestroyedNTSB MKC89LA030Accident · No injuriesLimited investigationFinal reportCessna 170A · Mccrory, ARThe student pilot and passenger said after about 10 minutes of local flight, they experienced a partial power loss. An emergency ldg was attempted on a near by rural strip, but the plt said he had excess airspeed and was unable to land successfully. The…Nov 19, 1988 · N170KM · Substantial damageNTSB MKC89FA027Accident · 6 fatalField investigationFinal reportBeech E-90 · Locust Grove, ARThe pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.Nov 19, 1988 · N308PS · DestroyedNTSB MIA89LA038Accident · No injuriesLimited investigationFinal reportRyan Navion B · Vero Beach, FLThe plt stated that drg flt, the eng lost power & he was unable to restart it. Drg a forced landing in a field, the acft struck three cows that were in a ravine & moved in front of the acft as it was apchg to land. A post acdnt exam of the acft revealed there…Nov 19, 1988 · N5422K · Substantial damageNTSB LAX89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Santa Maria, CADuring a pleasure flight, the airplane was being flown along a ridgeline while the pilot and passenger were looking for an old airplane wreck. The pilot was distracted and did not notice the airplane was entering a canyon and rising terrain. When the pilots…Nov 19, 1988 · N6883F · Substantial damageNTSB LAX89LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Van Nuys, CAThe pilot lost control of the aircraft while descending for landing and collided with a pole. The pilot stated that he was cleared to land behind a king air, on runway 16R. The pilot stated that about the time he descended to 50 feet AGL, near the threshold,…Nov 19, 1988 · N4306M · Substantial damageNTSB LAX89LA051Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chino, CAThe plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.…Nov 19, 1988 · N1441C · Substantial damageNTSB FTW89FA022Accident · 2 fatalField investigationFinal reportCessna 150M · Fort Worth, TXFailure to the flight instructor and the student pilot to obtain a weather briefing prior to departure, and he flight instructor's failure to observe the deteriorating weather conditions in sufficient time return to the airport prior to instrument…Nov 19, 1988 · N63537 · DestroyedNTSB BFO89LA011Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Port Royal, VAThe plt received a wx briefing which forecast IFR after 1800 EST. He departed dca in light drizzle conditions. Arpx 35 NM from dca, radar service was terminated and the plt attempted to contact ATC to no avail. He reported that near the brook VOR the VOR…Nov 19, 1988 · N8215P · Substantial damageNTSB NYC89FA033Accident · 3 fatalField investigationFinal reportBeech A35 · Shirley, NYLoss of control during takeoff, due to the failure (separation) of the right rudder control cable. Contributing to the accident was improper inspection and maintenance of the cable.Nov 18, 1988 · N8697A · DestroyedNTSB MKC89LA025Accident · No injuriesLimited investigationFinal reportCessna 310 · St. Louis, MOArriving over his destination airport, the pilot said he had an unsafe right main gear light indication. After circling about two hours to lighten the fuel load, and attempting to lower the gear by emergency procedures, a landing was attempted. After…Nov 18, 1988 · N8147M · Substantial damageNTSB MIA89LA037Accident · No injuriesLimited investigationFinal reportCessna 150J · San Juan, PRThe acft departed, entered left downwind leg for touch-and-go landings. When at midfield downwind, the instructor plt stated the eng quit & he was unable to restart it. The acft continued downwind momentarily then the instructor plt turned the acft to land at…Nov 18, 1988 · N61317 · Substantial damageNTSB LAX89FA050Accident · 1 fatalField investigationFinal reportBeech 95 · Milpitis, CAThe pilot failed to maintain altitude while performing a maneuver.Nov 18, 1988 · N663Q · DestroyedNTSB ATL89LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Toledo, OHThe airplane was found wrecked on an airport taxiway when airport personnel reported for duty in the morning. It had been stolen from the blue horizon flying club at the airport and, according to the hobbs meter, had been operated for about 0.4 hours since…Nov 18, 1988 · N63212 · DestroyedNTSB ATL89LA039Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot had flown about 3.7 hours and was about 2 miles from his destination airport when the engine stopped and he was forced to land in a swamp. The pilot had topped off the acft so that it contained 42 gallons of fuel (38 gallons of usable fuel). The…Nov 18, 1988 · N2840Q · Substantial damageNTSB SEA89LA020Accident · No injuriesLimited investigationFinal reportGates Learjet 25B · Bend, ORThe pilot visually inspected the runway while making a low pass. He reported afterward that he saw no evidence of ice or snow on the runway. The copilot called UNICOM but was told, while the aircraft was on short final, that the winds were calm and the…Nov 17, 1988 · N143CK · Substantial damageNTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…Nov 17, 1988 · N1963P · Destroyed