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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA88LA237Accident · No injuriesLimited investigationFinal reportMooney M-20E · Punta Gorda, FLThe plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated…NTSB LAX88DVA09Accident · Serious injuriesFinal reportStephenson U-2 · Porterville, CADuring a pleasure flight, while soaring with the engine at idle, the flying wing motor glider inadvertently entered a stall. The pilot did not recover from the stall and the airplane began to spin. The pilot was able to regain control at approximately 50 feet…NTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…NTSB DEN88IA167Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Denver, COWhile taxiing to the cargo ramp, the left wing collided with a lightpole as the flight crew were directed by gnd pers. One taxi director attempted to handoff the flight to another but the second misunderstood and turned away. A third person, who was not a…NTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…NTSB NYC88FA193Accident · 1 fatalField investigationFinal reportCessna 150J · Palmyra, NYCessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…NTSB MKC88LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · Underwood, IAThe CFI and student were performing maneuvers near Underwood, IA as part of 14 CFR 61 stu pilot trng. The acft was flown for abt 1/2 hr, prior to the CFI taking control of the acft when the stu experienced a loss of eng pwr during recovery fm a maneuver. The…NTSB MIA88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Sanford, FLThe CFI stated they had completed 2 touch & go ldgs without incident. On the next, the acft 'suddenly yawed to the left & the side load must have weakened the gear as the gear warning horn began to sound indicating the gear was no longer down & locked'. He…NTSB MIA88LA236Accident · 1 fatalLimited investigationFinal reportPiper PA-60-700P · Cocoa Beach, FLFlt entered near vertical descent while flying in area of level 1 and 2 thunderstorms just after plt had called requesting permission to deviate around rain showers. A level 5 thunderstorm was present 8 miles west. The acft descended at rates up to 13,800…NTSB LAX88LA291Accident · No injuriesLimited investigationFinal reportCessna T210K · Huntington Bch, CADuring the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…NTSB LAX88LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CAThe student plt rprtd that drg a lndg on a solo instructional flt, his final apch was a little fast. Drg the lndg, the airplane began to porpoise. However, before the student regained control, the nose gear collapsed.NTSB DEN88LA174Accident · No injuriesLimited investigationFinal reportCessna 172M · Gillette, WYThe student plt was completing his first solo x-country flt. During touchdown, the airplane bounced and began to porpoise. On the third bounce, the nose wheel fork failed. Subsequently, the acft turned 180 deg to the left & came to rest on the left side of…NTSB DEN88LA166Accident · No injuriesLimited investigationFinal reportKrall Dragonfly · Mitchell, SDDrg the 1st attempt to land, the acft bounced several times, then the plt made a go-around. On the 2nd attempt, the acft bounced again & began to porpoise. A witness heard the eng RPM increase to 'what sounded like full power.' The acft lifted off, but…NTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…NTSB ANC88LA151Accident · 1 fatalLimited investigationFinal reportCessna U206F · Lake Minchumina, AKThe plt said he was taxiing the floatplane from a windy/wavy location to a small protected cove for a final preflt. While taxiing, the top cap of the left float was open & the float began filling with water. Subsequently, the float- plane rolled over & sank.NTSB NYC88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Smoketown, PAThe plt reported that the eng lost power at about 300 ft AGL after takeoff. A forced landing was made in a corn field. During the landing roll the aircraft nosed over. The wreckage was examined after the accident and water was discovered in the fuel system.…NTSB MKC88LA135Accident · No injuriesLimited investigationFinal reportMooney M20-F · Lawrence, KSThe pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport.NTSB MIA88LA233Accident · No injuriesLimited investigationFinal reportCessna 310 · Homestead, FLWhile on a personal flt during normal cruise both engs quit due to fuel exhaustion. The plt attempted to land the acft on a road, after which it departed the road surface, and collided with trees. The plt did not file an acc report.NTSB MIA88IA231Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Miami, FLFlt experienced failure of the number two engine shortly after takeoff when the combustion outer case ruptured. Metallurgical examination revealed the ruptured case had a 1/2 inch crack in it when it went through overhaul 16 cycles before the failure. It was…NTSB MIA88FA234Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Daytona Beach, FLThe acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on…NTSB MIA88FA232Accident · 1 fatalField investigationFinal reportRockwell S2R · O'Brien, FLThe purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck…NTSB FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…NTSB CHI88DEX10Accident · No injuriesFinal reportWilliams Waco · Madison, INThe plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…NTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…NTSB BFO88LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Windsor, VAWhile on long final after a glider tow flight the eng lost power. A forced landing was made in an open field and when the plt applied brakes, the acft nosed over. Post accident exam of the acft revealed 1 gallon of fuel remained. The plt reported that he…NTSB BFO88FA068Accident · 2 fatalField investigationFinal reportCessna R182RG · Stevensville, MDThe acft departed bay bridge arpt at aprx 0415 EDT. The passenger, also a plt, was reading back an IFR clearance to ATC when communication ended in the middle of a sentence without any sign of distress. Comparison of ATC and radar tapes indicates that N9997C…NTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…NTSB NYC88LA191Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Pendleton, NYLoss of control of the aircraft after the pilot had hooked the banner.NTSB MKC88LA122Accident · No injuriesLimited investigationFinal reportRockwell S2R · Brinkley, ARDuring the take-off roll for an aerial application operation, the pilot said he lost his left wheel braking capability. He continued the take-off, flew to the farm field to be treated, applied the load, then returned to a near by alternate landing strip…NTSB MIA88LA235Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLAfter a normal lndg, during the lndg roll at aprx 50-55 mph, the acft rolled through a 1-2' deep puddle of water. The acft slowed & at aprx 35 mph, the rt main lndg gear slowly began rotating aft. The acft came to rest supported by the rt horizontal…NTSB LAX88DUD01Accident · Minor injuriesFinal reportFerris VARI-EZE · Hawthorne, CADuring a local flight, while on final approach, the pilot reported that a gust of wind from the right raised the right wing resulting in the left wing contacting the runway. The pilot lost control of the airplane which nosed over during the landing roll.…NTSB FTW88DRA15Accident · 1 fatalFinal reportAir Command Elite 532 · Baytown, TXAcft was observed to takeoff and turn right crosswind. Drng the crosswind, the RPM increased suddenly. The acft pitched nose downwards, impacted the ground in a vertical descent and burned. The plt/builder had a total of 5 hrs in the new acft. No evidence of…NTSB FTW88DPA05Accident · No injuriesFinal reportLuscombe 8A · Burleson, TXThe airplane was on downwind when the pilot pulled on the carburetor heat and reduced the RPM. When he reapplied power, the engine would not respond. During the forced landing, the pilot got the airplane on the airport but hit the right wing and tailwheel on…NTSB CHI88LA172Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Greenfield, INDuring a dual instructional flight for purpose of practicing landings in a conventional gear aircraft, the student pilot abruptly nosed the aircraft toward the turf runway. The instructor pilot did not take remedial action and the aircraft struck the ground,…NTSB ATL88FA219Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Winston-Salem, NCN7942N crashed into a building shortly after liftoff from runway 21. The pilot was cleared for a left turnout over runway 33. A witness estimated that the airplane had reached 300 feet when the pilot lost control and crashed. The investigation failed to…NTSB ANC88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Kongiganak, AKThe aircraft touched down approximately 2/3 of the way down the runway. During the ldg roll, aircraft hit a rut on the runway. The plane nosed over and came to rest on its back, off the departure end of the rwy. The FAA flt info publication states that this…NTSB SEA88LA194Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Ephrata, WAThe pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft.NTSB LAX88LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Redlands, CADuring the takeoff ground run on a solo instructional flight, the student pilot lost control of the airplane. The airplane veered to the left. The pilot applied right rudder, however, the airplane continued to the left, exited the runway and collided with the…NTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…NTSB LAX88DUJ06Accident · No injuriesFinal reportGrumman G-164B · Chandler, AZDuring an aerial application flight, the engine experienced a loss of power. A forced landing was made in an open field and during the landing roll the airplane nosed over. Inspection of the engine revealed that the number five cylinder dome separated from…NTSB FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…NTSB FTW88LA138Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Sayre, OKThe pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…NTSB FTW88DPA04Accident · No injuriesFinal reportAtkins ACRO-SPORT · Fort Worth, TXDuring a personal flight, the engine failed and the pilot made a forced landing into an open field. During the landing, the airplane flipped to the inverted position. Investigation revealed no fuel in the tank or fuel system and no fuel spilled on the ground.NTSB CHI88LA173Accident · No injuriesLimited investigationFinal reportPiper J-3 · Minneapolis, MNWhile practicing a landing on a solo instructional flight, the student pilot allowed the aircraft to drift off the left side of the runway and strike the VASI lights. The student pilot had only flown 2 hours, including 10 takeoffs and landings, in the past 90…NTSB CHI88LA171Accident · No injuriesLimited investigationFinal reportCessna 182E · Cedar Springs, MIDuring cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel…NTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…NTSB ATL88LA218Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Somerville, TNThe CFI was attempting a demonstration of a forced landing following a simulated loss of engine power. Just as he started to recover and climb back to altitude, the student plt spotted wires and yelled. Company policy required a recovery at 500 ft. the…NTSB ANC88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKThe pilot reported that he lost control of the aircraft. The plane crashed approximately 500 feet off the departure end of the airstrip. The flight was a part 135 on-demand air taxi flight. At the time of the accident, the aircraft was above maximum certified…NTSB SEA88LA135Accident · No injuriesLimited investigationFinal reportSchweizer G164A · Colfax, WAOn departure with a load of chemical, ag plt attempted to outclimb rising terrain ahead. The aircraft collided with terrain in a stall/mush.NTSB NYC88LA190Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Greenland, NHThe intention of the flight was to give people at an annual company picnic a ride in the aircraft. After takeoff and while starting a left turn the pilot stated that he encountered a 'sudden windshear/downdraft.' The aircraft never got above 200 feet and…