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 SEA87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakutat, AKWhile taxiing, after landing on a murky river, the pilot did not see a sand bar. The aircraft struck the sand bar and the aircraft then nosed over inverted. The plt did not file an acc rpt and held a canadian pilot certificate.NTSB LAX87LA209Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Apple Valley, CAThe pilot lost control of the aircraft and entered an inadvertent spin during the initial climbout following a touch-and-go landing. The pilot reported a loss of power after climbing to 500 feet. Another pilot on the airport observed the aircraft in a very…NTSB CHI87DET04Accident · Minor injuriesFinal reportCessna 172P · Peru, INThe pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain.NTSB ATL87FA142Accident · 4 fatalField investigationFinal reportCessna T337G · Oxford, OHThe pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…NTSB ATL87DMG01Accident · No injuriesFinal reportGrumman G-164B · Beaufort, NCThe plt had just loaded the hopper with dylox chemical. As the acft became airborne, the plt stated, he experienced wind shear and the acft rolled to the right. The plt corrected by leveling the wings and immediately experienced a second more violent wind…NTSB SEA87LA096Accident · No injuriesLimited investigationFinal reportMooney M20F · Wagontire, ORDuring takeoff with full flaps and a density altitude of about 6,200 feet the aircraft failed to gain flying speed. Shortly after becoming airborne the aircrafts gear caught on a barbed wire fence at the departure end of the runway. The aircraft then struck…NTSB NYC87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Reading, PAAccording to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the…NTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.NTSB NYC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Falmouth, MAAbout 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…NTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…NTSB MKC87LA104Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Wamego, KSThe PIC had been airborne in the LCL area to let parachute jumpers jump fm his acft. To lose alt quickly the PIC performed a prolonged slip. On the final app the eng quit and alt was insufficient to reach the rwy for lndg. The off arpt lndg was unsuccessful.…NTSB LAX87LA211Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tucson, AZA Great Lakes 2T-1A-2 nosed over during landing. The pilot indicated that he had contacted the airport on the UNICOM frequency and was informed that the winds were favoring runway 30. On short final approach to runway 30 the pilot glanced a wind sock located…NTSB LAX87LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Turlock, CAApproximately 15 minutes into a pleasure flight, the engine experienced a partial loss of power. The pilot made an emergency landing at a nearby airport, where upon landing the aircraft ran off the runway and collided with a bush. Inspection of the engine…NTSB LAX87FA207Accident · Serious injuriesField investigationFinal reportCessna 182L · Santa Monica, CAThe acft lost power during initial climb and crashed on a residential street during an attempted forced landing. The throttle arm was found separated from the throttle shaft. The arm had been replaced 19 hours prior to the accident. Examination of the…NTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…NTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…NTSB BFO87FA037Accident · 1 fatalField investigationFinal reportCessna 150M · Elkton, MDThe acft was flying at low altitude over an area of open fields when according to witnesses the acft abruptly pitched down and descended to the ground. Some witnesses stated they heard the engine operating throughout the descent while ohter witnesses reported…NTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…NTSB NYC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Toms River, NJThe flight was involved in short field landing practice. On the third landing, the pilot allowed the aircraft to stall above the runway surface and then touch down hard, damaging the outboard sections of the wings.NTSB NYC87LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Atlantic City, NJAccording to a witness, the acft was hi & fast on final apch to lnd & touched down nosewheel 1st in a x-wind. Drg the lndg, the acft bounced, then drifted to the left & touched down on wet grass beside the rwy. Subsequently, the left main wheel strut hit a…NTSB NYC87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Honeoye Falls, NYThe acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…NTSB MIA87LA159Accident · No injuriesLimited investigationFinal reportCessna 120 · Oklawaha, FLThe plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main…NTSB LAX87LA206Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Carefree, AZAt the end of a cross-country flt, the plt was approaching the arpt for landing on rwy 6 and noticed light turbulence. On the first attempt to land the plt went around. On the second attempt the plt landed the acft. Aprx 100 ft down the rwy the acft became…NTSB FTW87LA120Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sargent, TXThe plt decided to takeoff twd the NE on a pvt road (which he referred to as 'shell rd . . . Beach'). He used 10 deg of flaps & applied full power before releasing the brakes. He stated that after becoming airborne about 2 to 5 ft, the acft 'shifted slightly…NTSB DEN87LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Sky, MTThe private plt was flying cross country in deteriorating weather conditions. Fog was forecast and light rain was in progress. The flt encountered less than VFR conditions in a mountainous area and reversed course. Weather was below VFR on the reverse course…NTSB CHI87LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Lansing, ILDuring an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also…NTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.NTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…NTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…NTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…NTSB ATL87LA139Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Raleigh, NCThe pilot failed to maintain a proper descent rate on the approach for landing. He said the right engine failed to respond when he added power to arrest the rate of descent and thereafter, he applied full power to either go-around or land further down the…NTSB ATL87LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172-N · Walhalla, SCDuring a local sightseeing flight the plt trimmed the aircraft to a slow flight configuration, and circled a lake in the mountains of south carolina at an alt of approx 1,000 ft AGL. The aircraft was near max gross weight and the ground temp was 82 deg f. the…NTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.NTSB ANC87FA070Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKThe pilot-in-command failed to maintain directional control of the airplane during landing. It nosed over during a ground loop.NTSB CHI87LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNThe plt stated that while practicing touch-and-go landings, he extended full flaps on final apch and maintained rwy alignment. According to the plt, the acft touched down hard and began to porpoise. A police officer witnessed the acft bounce three times after…NTSB SEA87LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Orvado, NVDuring landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted.NTSB NYC87LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgartown, MAThe plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was…NTSB MIA87LA161Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Missing, FLThe acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…NTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…NTSB DEN87LA127Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Limon, COThe plt reports that he was using a dirt road for aerial app operations. The acft was loaded with 40 gals fuel and 140 gals chem and the density alt is EST to have been 8100 ft. the plt said the takeoff was made to the e with a quartering tailwind of about 15…NTSB DEN87LA124Accident · No injuriesLimited investigationFinal reportBrantly Helicopter 305 · Golden, COThe commercial plt was performing hover tests in his experimental helicopter at his private helipad, located 60 feet from his residence. The plt reported winds as variable gusting to 40 knots. The plt's attention was diverted and a wind gust pushed the…NTSB CHI87DER06Accident · 1 fatalFinal reportBell 47G-2A · New Prague, MNAfter about a 5 min flight, the helicopter collided with the ground during a downwind turn on an agricultural turnaround. Impact was on a heading of 210 degrees. Wind was from 326 degrees at 14 KTS, gusts to 22 KTS. No evidence was found of powerplant, flight…NTSB ANC87LA069Accident · No injuriesLimited investigationFinal reportFairchild C-119L · Shageluk, AKThe airplane was destabilized by a slight vertical air movement on approach. The pilot touched the airplane down short of the runway proper, collapsing the landing gear before sliding off the strip into adjacent tundra.NTSB SEA87LA092Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315-D Lama · Siletz, ORDuring external load operations the chockers became loose due to improper loading. The external load longline cable became entangled with the tailrotor causing a failure of the tail rotor system. The helicopter assumed a nose down attitude and spun to the…NTSB NYC87FA146Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Sayre, PADrg initial climb after takeoff, smoke was observed in the cockpit. When the smoke became hvy, the plt decided to land. He attempted a forced landing on rising terrain in foggy conds. Subsequently, the acft crashed into the side of the hill & began burning.…NTSB LAX87WA217Accident · No injuriesForeign investigationCessna 150G · Castillejos, PhilippinesNTSB CHI87LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIAccording to the plt, he entered downwind for rwy 18 and the apch 'seemed normal.' The plt stated that he 'slipped into wind' on final apch and extended ten degrees of flaps, but when he straightened out, the acft 'veered' to the left suddenly. According to…NTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…NTSB LAX87DUM04Accident · Minor injuriesFinal reportTexas Helicopter M74L-WASP · Holtville, CADuring an aerial application flight, the pilot reported that the electrical system failed. Shortly after, the aircraft collided with power lines. Inspection of the aircraft revealed that the generator was inoperative. There were no other reported mechanical…NTSB FTW87LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nowatta, OKDuring takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…