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 MIA88IA230Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Tampa, FLShortly after depg, the plt elected to rtrn to the arpt for paperwork he had forgotten. He rprtd the apch & touchdown were normal, but drg the lndg roll, the left main gear collapsed. Subsequently, the acft veered off the rwy & hit a rwy lgt before stopping.…NTSB LAX88LA267Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chico, CADuring a cross country flight, the pilot noted a loss of oil pressure. Shortly after, the pilot heard a loud bang and the engine lost power. A forced landing was made short of the airport where the airplane collided with the terrain during the landing roll.…NTSB LAX88DUJ05Accident · Minor injuriesFinal reportGrumman G-164B · Parker, AZDuring an aerial application flight, the pilot dispensed the load and was returning to the airstrip due to an approaching thunderstorm. Enroute, the visibility was reduced to near zero from blowing dust. The pilot lost control of the airplane and collided…NTSB FTW88FA136Accident · 3 fatalField investigationFinal reportDouglas DC-6A · Golden Meadow, LAAfter abt 4.3 hrs on an overwater flt, the crew rprtd they had 15 min of fuel remaining. Subsequently, 3 of 4 engs lost pwr fm fuel exhaustion. Drg an emerg lndg, the acft hit a levee & was extensively dmgd. Most of the wreckage came to rest in a dainage…NTSB CHI88DEE07Accident · No injuriesFinal reportHughes 269C · Sandwich, ILThe plt rprtd that while he was conducting spraying opns, he noted a significant loss of eng power. He made a run-on landing in a bean field. As he landed, the left skid dug into a furrow & the helicopter rolled over. During the investigation, which included…NTSB ATL88LA217Accident · No injuriesLimited investigationFinal reportMooney M20E · Lawrenceville, GAThe plt reported that the engine failed shortly after takeoff. The pilot made a 180 degree turn and landed downwind on the runway. He elected to land gear up to avoid a drop-off past the runway end. The acft slid off the runway end, but came to a stop before…NTSB SEA88LA134Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Eastsound, WAPlt was cruising at 200 feet over the water, looked down to get a chart under his seat and collided with the water.NTSB LAX88LA265Accident · No injuriesLimited investigationFinal reportCessna 152 · Dixon, CAThe plts stated that while they were cruising in close formation, the rgt wing of one acft (Cessna 152, N6469M) raised up & collided with the left main lndg gear of the other acft (Cessna 152, N6239H). N6469M received substantial damage to the wing & N6239H…NTSB LAX88FA264Accident · 1 fatalField investigationFinal reportBeech 76 · Portola Valley, CAWhile dining with friends with whom he resided, the pilot told them that he was 'going flying'. At the completion of the flight he would fly over the house before he returned to palo alto airport (pao). The pilot twice circled the residence which is abt 7…NTSB FTW88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · La Grange, TXThe pilot said he flew over the airport and found the winds favored a landing on runway 18. He said he descended to the downwind leg, and when he added power, the engine would not respond. However, he said the engine continued to run. He decided to make an…NTSB FTW88DPJ08Accident · Minor injuriesFinal reportCessna 152 · Heavener, OKDuring a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR…NTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…NTSB BFO88FA067Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Chantilly, VAThe pilot inadvertently misused the flaps, by failing to set the flaps to the proper setting. The flaps were set full down. This caused the aircraft to pitch up steeply after liftoff. Additionally, the flight control lock was probably installed during some…NTSB ANC88LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bettles, AKThe pilot reported that the aircraft ran out of fuel approximately 25 miles from the airport. The aircraft crashed into a wooded area. The pilot stated that both fuel indicators were indicating at or near empty at the time of the accident.NTSB MKC88LA133Accident · No injuriesLimited investigationFinal reportGrumman 164A · Poplar Bluff, MOThe pilot experienced an engine failure while attempting to land during an aerial application flight. Altitude was not adequate to select a suitable forced landing area. The aircraft impacted in a pipeline right of way and came to rest in a small stream,…NTSB MKC88LA132Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Knobel, ARProper touchdown point not attained, and aircraft control not maintained by the pilot in command.NTSB MIA88LA228Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Lambert, MSThe plt stated there were tstrms in the area when he attempted to takeoff on an aerial application flt. He began his takeoff roll from the duster strip & a strong wind gust from the approaching tstrm blew the tail around. The acft came to rest on its belly in…NTSB DEN88LA163Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Glendive, MTNTSB CHI88LA169Accident · No injuriesLimited investigationFinal reportBeech E18S · Elyria, OHDuring the takeoff roll, the right engine 'surged'. The pilot was unable to maintain directional control of the aircraft, and the aircraft swerved to the right, departed the right side of the runway, struck a ditch and groundlooped, collapsing the left main…NTSB NYC88LA189Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Saltsburg, PAThe plt launched on a local Balloon sight-seeing flight at 1850 local time with the forecast of thunderstorm activity to commence in the area after midnight. After 40 mins of smooth flt, the temp dropped sharply and shortly thereafter turbulence was…NTSB NYC88LA172Accident · No injuriesLimited investigationFinal reportCessna 150 · Massena, NYThe student pilot on a crosscountry flight to Massena, new york stated that during the landing approach he felt that he was too low and when he tried to correct, the aircraft bounced. On the second touchdown the nose gear collapsed and the aircraft slid off…NTSB NYC88FA185Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Egg Harbor Twsp, NJThe Bellanca was maneuvering and had hooked up with a banner, when control was lost and it impacted the ground. Witnesses said the aircraft was at full power when it went into a nose high attitude and stalled to the right. After impact with the ground the…NTSB MKC88LA131Accident · No injuriesLimited investigationFinal reportRockwell S2R · Swifton, ARThe PIC was conducting ag-spray maneuvers dispensing liquid fertilizer to rice. During a procedure turn to return to the field the eng quit. The PIC chose an open field abt 60 degrees to his rt to land the aircraft. The field was wet, soft and rough. The acft…NTSB MIA88LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Moorhead, MSWhile on an aerial application flt during the ground roll the wind changed from a headwind to a tailwind. The plt dumped the load of chemical in an attempt to climb but the acft crashed into a fish pond.NTSB MIA88LA227Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St. Petersburg, FLThe 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt…NTSB MIA88LA225Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Clewiston, FLThe plt stated the fuel gages indicated 20 gals when he took off on spraying flt. He had just completed the spray run & started to pull up from about 10 ft & 25 mph. At that time the eng quit '& sounded just like it would if it ran out of gas'. There was not…NTSB LAX88LA266Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Springerville, AZShortly after takeoff, the engine experienced a loss of power. The pilot made a forced landing where during the landing roll, the airplane collided with the terrain. During the engine inspection, it was found that the left magneto fired only one sparkplug.…NTSB LAX88LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Ajo, AZThe plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…NTSB DEN88LA161Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Buchanan, NDThe plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…NTSB CHI88DEV02Accident · No injuriesFinal reportGrumman G-164A · Cape Girardeau, ILThe plt was applying chemicals to a field with 3 radio transmission towers along one side. He rprtd that as he was finishing the field, he circled one of the towers, them made a final swath run across the end of the field. He stated that as he pulled up from…NTSB CHI88DEI02Accident · Serious injuriesFinal reportGeddes Commander 503 · North Lima, OHPilots continued operation of the aircraft with a known deficiency and attempting to stretch his partial power descent to reach a runway rather than land off airport.NTSB ANC88LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Illiamna, AKDuring the takeoff roll on the beach, the aircraft struck a large rock and the pilot lost directional control of the aircraft.NTSB ANC88DAG06Accident · No injuriesFinal reportAir Command 532 Elite · Palmer, AKDuring landing approach an excessive rate of descent developed very near the runway. The gyroplane landed hard. After the hard landing the pilot reported that he pulled the control column to its aft position abruptly. The small tail wheel struck the runway…NTSB NYC88LA184Accident · No injuriesLimited investigationFinal reportMooney M20F · Princeton, NJThe Mooney M20F made a takeoff and as the pilot turned crosswind, he experienced a partial power loss. He returned for a landing and the engine smoothed out. He made extensive ground runs and could not duplicate the problem. However he did not have…NTSB MKC88LA128Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Holdrege, NEThe plt said that after completing a spraying operation and depleting his chemical load, he flew to a near-by farm field to check it over. Enroute, the engine quit, and attempts to restart it were unsuccessful. An emergency ldg was attempted in a plowed farm…NTSB MIA88FA224Accident · 2 fatalField investigationFinal reportBeech 95 · Destin, FLPlt reported arpt in sight and was cleared for visual approach. Witnesses reported seeing acft on left downwind & said it flew into a thundershower. The flt was not heard from again. The acft's wreckage was found in the bay 1 1/4 miles north of the runway.…NTSB LAX88LA262Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Dana Point, CADuring a fish spotting operation over the ocean, the engine began to run rough and vibrate. The engine quit completely shortly thereafter and the airplane was ditched in the ocean. The airplane was not recovered. The plt stated that the eng lost power then…NTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…NTSB DEN88LA162Accident · No injuriesLimited investigationFinal reportCessna 177RG · Santa Teresa, NMAn unknown person or persons took a Cessna 177RG from a small airport near the mexican border, without permission. State police found it crashed in a field 2 miles southwest of Santa Teresa airport, and notified the owner. No witnesses have been found to…NTSB DEN88LA160Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Boulder, COAccording to the plt, he was returning to Boulder after making a flt to aspen. He said he started the morning flt with 2/3 fuel load (about 40 gallons) but didn't know how much flt time he accumulated during the day. During his VFR approach to the Boulder…NTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.NTSB SEA88FA131Accident · 1 fatalField investigationFinal reportApplebay Zuni 2 · Wellington, NVThe plt (with only 13 hrs flt time in the hi performance sailplane) took off at 1330 PDT. Psn rprts with her gnd crew were normal until 1630, then another plt offered to relay messages. After ctcg her gnd crew, the otr plt tried calling her back at aprx 1645,…NTSB NYC88LA188Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Wellsville, NYAbout 35 hot air balloons were entered in the great Wellsville balloon rally. At 0625 EDT, the plt (of c-gdgk) attended a wx briefing that was given to the plts by the balloonmeister. The plt said the balloonmeister indicated that there would be suitable…NTSB NYC88LA183Accident · No injuriesLimited investigationFinal reportAeronca S11BC · Livingston Mnr, NYThe pilot had just departed from the surface of a lake, when at an altitude of 50 ft AGL and in a left turn, the engine quit. There was not enough altitude to make it back to the lake. The aircraft impacted trees and was destroyed. The pilot had experienced…NTSB NYC88LA182Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Candlewood Lake, CTThe LA-4-200 made a takeoff under reported conditions of gusty wind and waves of 1 to 2 feet. The maximum demonstrated wave height for the aircraft is 1 foot. The pilot reported he aborted the takeoff due to a person on a jet ski in his way and as he tried to…NTSB MIA88LA226Accident · No injuriesLimited investigationFinal reportEvans Maxair MU503 · Fort Walton Bch, FLWhile on a personal flt with reported thunderstorms in the vicinity, the plt lost control of the homebuilt acft while on final aprch to land. The acft descended & collided with terrain.NTSB MIA88LA222Accident · No injuriesLimited investigationFinal reportCessna 150G · Keystone Height, FLWhile on a personal flt during the seventh touch & go landing, the acft bounced & drifted off the left side of the rwy. The plt added power & rolled the acft into a right bank to correct this but the right wing collided with terrain. The acft then nosed over…NTSB MIA88FA223Accident · Serious injuriesField investigationFinal reportRockwell 100-180 · Paxton, FLPlt's license was suspended at time of accident and his medical certificate was expired. Plt failed to get weather briefing prior to departure. Plt continued flt into deteriorating weather conditions and while attempting to land at a private airport due to…NTSB LAX88LA261Accident · No injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe plt rpted that the engine cylinder temperature was very high as he crossed mountainous terrain. He elected to make a downwind precautionary landing to a short airstrip with a high density altitude. The acft touched down beyond the normal touchdown zone,…