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 ANC84FA080Accident · 2 fatalField investigationFinal reportCessna 180G · Tyonek, AKTaking off from an abandoned road near a fishing camp, the Cessna turned back and descended with power on over his departure point, heading into the sun which was low on the horizon. It collided left wing to left wing with the Maule which had climbed out at a…NTSB NYC84LA194Accident · No injuriesLimited investigationFinal reportCessna 177B · New Paltz, NYAcft was landed on rwy 32 with wind from 60 degrees at 10 KTS. The acft bounced on touchdown, pwr was added and the acftbecame airborne. The acft drifted left and contacted a rock in grass off the left side of the rwy.NTSB MKC84LA160Accident · No injuriesLimited investigationFinal reportCessna 188 · Mcgehee, ARThe acft ran out of fuel during an approach to the arpt & landed short of the strip. During the landing, the left main gear collapsed. The plt thought he had about 8 gal of fuel remaining.NTSB MKC84FA156Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Wickes, ARThe acft was force landed in an open rolling field after the engine lost power. The plt said the engine produced a rattling noise and vibration before the loss of manifold pressure. Post accident examination showed a failed #3 connecting rod and cylinder.NTSB LAX84LAMS3Accident · 1 fatalFinal reportBellanca 17-31A · CABetween may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…NTSB FTW84LA263Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Maringouin, LAThe plt was completing the first swath pass attempting to fly under a power line and between a tree and parked farm equipment. In a slight left turn under the power line, the right wing contacted tree tops aprx 30 ft AGL. The acft continued aprx 150 yards…NTSB FTW84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bell City, LAA propeller counterweight bearing shaft failed after takeoff at max gross weight. A vibration occurred & the plt began dumping his load, but he was unable to maintain altitude. The aircraft landed in soft mud and nosed over when it collided with a rice levee…NTSB CHI84LA242Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Grayslake, ILThe plt stated that as the balloon touched down, he lost his footing & his left ankle slipped into the corner of the gondala. He suffered a fractured, dislocated ankle.NTSB ATL84LA191Accident · No injuriesLimited investigationFinal reportMaule M-2 · Troy, VAThe acft lost power during takeoff climb and crashed on the arpt during a forced landing. Examination of the acft after the accident revealed that the right fuel tank vent was clogged about 4 inches into the vent by a mud dauber nest restricting fuel flow to…NTSB NYC84LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Teterboro, NJA Piper PA-34-200T, N33086 & a Piper Aerostar 600, N8208T, were involved in an on-ground collision at night. IFR flt plans had been filed for both acft & the plts of both acft had begun taxiing for takeoff. According to the PA-34 plt, he had been cleared to…NTSB MKC84FA155Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Hills, IAThe acft impacted the ground in a 90 degree bank with the nose down about 20 degrees. The acft had been seen in a seriesof low alt dives and climbs. On this last climb over the trees a witness saw a wing suddenly drop and the acft disappear behind the trees.…NTSB FTW84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Ferriday, LAUpon landing the acft traveled off the side of the airstrip and nosed over in a small ditch. The student plt was not endorsed by a CFI for landing at this airstrip while on the x-country flight.NTSB FTW84LA260Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Odessa, TXDuring the takeoff ground roll the plt noticed the inop airspeed indicator but continued the takeoff. The acft bounced during the long fast landing and traveled off the right side of the rwy. The plt corrected back to the left and the acft touchdown hard off…NTSB FTW84LA259Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Andrews, TXThe pilot stated that the helicopter was operating at 55 percent power on the gnd while awaiting the pax to board. The passenger walked into the tailrotor and received serious injuries. The plt stated that the company does not have safety procedures for…NTSB FTW84LA257Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Ripley, OKAcft contacted three unmarked transmission power lines which crossed the cimarron river. The plt was flying over the river trying to locate a field which was to be sprayed. The acft then crashed on nearby river bed.NTSB FTW84FA258Accident · 1 fatalField investigationFinal reportCessna 152 · Fairview, OKThe acft had inflt structural failure and separation of some components and crashed in an inverted flat spin parts of the wing and aileron were never found. Some parts were found about 1/2 mile from the primary impact point. An autopsy onthe plt revealed the…NTSB DEN84LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Cheyenne, WYBefore the flight the pilot obtained a weather briefing and was informed of an approaching thunderstorm which was 10 miles northwest of the airport. The pilot stated that after a normal takeoff he climed to a altitude of about 250 ft AGL, at 70 KIAS, when he…NTSB DEN84FA166Accident · 1 fatalField investigationFinal reportBeech BB-55 · Duchesne, UTAcft collided with a mountain at an elevation of 12,000 ft MSL. Wx at roosevelt, UT, 42 NM se of the accident site at 2030 MDT was estimated 7,000 ft bkn, 25,000 ft bkn, 40 miles visibility, 70 deg f, with cumulus nimbus clouds NE and se. Radar summary charts…NTSB DCA84AA025Accident · No injuriesFinal reportBoeing 727-222 · Denver, COBefore takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…NTSB ATL84FA190Accident · Serious injuriesField investigationFinal reportMaule M-6-235 · Marietta, GAThe float equipped acft departed on a southwesterly heading from the lake. Surface winds were reported from the north at 8 KTS gusting to 15. With full flaps extended the acft got airborne and continued a downwind climb over a tree line to about 250 ft AGL.…NTSB MKC84LA154Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWhile the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over.NTSB LAX84LA324Accident · No injuriesLimited investigationFinal reportCessna 152 · Mesa, AZThe student plt entered the traffic pattern for a touch-&-go landing. During touchdown, the acft bounced. He applied full power & moved the flap selector to the 'up' position, but the acft yawed to the left. It veered off the rwy, traveled onto a graded…NTSB FTW84LA265Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355 F Ecureuil · Venice, LAThe plt landed to secure a seat belt flapping on the outside of the fuselage. The area chosen for landing was soft and the acft began to settle into the mud. The plt initiated takeoff and when the acft freed itself from the mud it started spinning. The plt…NTSB FTW84LA256Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Hominy, OKThe acft collided with a radio tower guy wire while the plt was en route to reload. During the collision, the right wing was sheared off & the acft crashed to the ground & burned. The radio tower was located about 1 mi from the arpt.NTSB FTW84LA255Accident · No injuriesLimited investigationFinal reportAmerican Aerolights Eagle 2 · Goldsby, OKThe plt of the 2 place ultralight, N951AA, & the plt of another ultralight were en route from tuttle to goldspy, OK. While flying low over a wheat filfed, the plt of the other ultralight inadvertently flew into the crop. The plt of N951AA witnessed the…NTSB DCA84AA024Accident · 4 fatalFinal reportLockheed L-188 · Chalkhill, PAAfter departing the baltimore-washington arpt, the acft had climbed to FL 220. According to info on the cockpit voice recorder (vcr), the crew experienced gyro problems during the climb. They selected the #1 vertical gyro to drive both approach horizons…NTSB SEA84LA122Accident · No injuriesLimited investigationFinal reportCessna 188B · Perrydale, ORThe plt stated that while taking off from the 1,100 ft rough strip, the acft struck a bump causing it to become airborneprematurely. The acft then settled back onto tall wheat past the end of the strip & flipped inverted.NTSB SEA84LA119Accident · No injuriesLimited investigationFinal reportCessna U-206-GII · Kenmore, WAThe plt stated that he was attempting a landing, with a left quartering crosswind, in water made rough by heavy boat activity. The left float dug into the water and the acft sank into four feet of water.NTSB MKC84LA153Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Bedford, IAThe plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft…NTSB LAX84LA325Accident · No injuriesLimited investigationFinal reportCessna 150M · Alameda, CAThe student plt was on a round-robin flt with an en route stop at red bluff, CA. He continued to state that 'in the excitement of de-briefing' after landing at red bluff, the acft was not refueled. Te plt departed and did not realize his low fuel situation…NTSB DEN84FU006Accident · 1 fatalFinal reportWeedhopper B · Beresford, SDThe ultralight was observed flying when it suddenly nosed down and crashed. One witness said he thought he heard the engine quit running before the nose down. The acft impacted in a vertical nose down attitude. Investigation showed that the pistons were…NTSB ATL84LA290Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Rockwood, TNThe acft crashed in an area of rising terrain at about the 1800 ft level. About 1 mile away the ridge line rose to an elevation of 2500 ft. when the acft was observed overflying the Rockwood arpt aprx 3 miles from the accident site the ceiling was about 1200…NTSB ATL84FA187Accident · Serious injuriesField investigationFinal reportPiper PA-30 · Charlotte, NCPlt departed rwy 18L and shortly thereafter reported to the tower that he had a stuck trim. The plt was cleared to land on rwy 18R. Witnesses observed the acft descend rapidly on downwind to approx 300 to 500 ft AGL and make a steep (90 to 120 degree) right…NTSB ANC84FA078Accident · 3 fatalField investigationFinal reportCessna 150L · Nome, AKNumerous witnesses observed the acft flying at low alt & behaving in an erratic manner. According to 3 witnesses, the plt buzzed persons fishing on a local river, an occupied roadhouse & vehicles on 2 roadways. Subsequently, the acft crashed on soft terrain…NTSB NYC84LA190Accident · No injuriesLimited investigationFinal reportCessna C190 · South Kingston, RIAnticipating deteriorating weather conditions, the pilot decided to land at an unfamiliar airstrip. He landed long and had commenced a go-around but the landing gear caught in swamp growth and collapsed.NTSB MKC84LA152Accident · No injuriesLimited investigationFinal reportAyres S2R · Wilmot, ARPlt stated a loss of pwr occurred shortly after takeoff at an alt of 100 ft AGL. The acft nosed over during the forced landing. Inspection of the engine revealed no pre-impact failue/malfunction.NTSB MKC84LA150Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Morrilton, AROn short final the plt advanced the throttle to maintain alt but the engine failed to respond. Power remained at idle RPM and the acft landed short of the rwy. On touchdown the landing gear sank in the soft ground and all three gears were broken off.…NTSB MIA84FU005Accident · 1 fatalFinal reportEipper Quicksilver GT · Lithia, FLThe ultralight crashed in the backyard of a friends house as the plt circled at low alt while waving and shouting to be seen. The acft appeared to witnesses to stall before falling on the right wing to the ground from about 50 ft AGL. The engine continued to…NTSB LAX84LA327Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS1-26D · Lucerne Valley, CAThe plt reported that his glider was the 3rd to launch (using an auto tow) on a distance completion flt. He released the tow cable at about 900 ft & began searching for lift. No lift was found. After a short time, he attempted to return to the departure…NTSB LAX84LA326Accident · No injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Piru, CAPlt was performing aerobatic manuevers in a designated practice area at an altitude of 2500 ft AGL. The plt stated that he performed a 'tail slide' maneuver and the engine stopped which 'is a normal engine response for the maneuver.' The plt was unable to…NTSB LAX84LA322Accident · No injuriesLimited investigationFinal reportBeech S35 · Kayenta, AZThe plt reported that during takeoff, he raised the nose, the acft began climbing and immediately thereafter, the stall warning horn sounded. He then lost control, the acft descended & crashed into terrain south of the rwy. The plt said that he over rotated…NTSB LAX84LA321Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Benson, AZStudent pilot was on a crosscountry when she became lost. Efforts were made to establish her position by contacting air traffic control on the emergency radio frequency. By the time her position was established the aircraft was about out of fuel. The pilot…NTSB LAX84LA320Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Boron, CAPlt stated that while soaring a 'heavy sink' was encountered. He attempted to reach borax airport but was unable to and landed in terrain 1/4 mile west of the airport. Lancaster, CA, fss stated pilot reports of 'moderate turbulence' were received throughout…NTSB LAX84LA318Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Woodland, CAAccording to the plt, the acft encountered a local whirlwind during a 90/270 ag maneuver & crashed.NTSB LAX84FA319Accident · 2 fatalField investigationFinal reportCessna 152 · Half Moon Bay, CAThe two acft collided after N1920Y declared his intention to takeoff and was airborne aprx Half way down the rwy. The other acft was in a steep descent at mid-field when he dove into N1920Y. Both acft then crashed uncontrolled into the ground from an alt of…NTSB FTW84LA252Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Port Aransas, TXPlt stated an engine miss was experienced. Plt elected a precautionary landing on the beach during which main gear dug into sand and acft nosed over. During a helicopter recovery the acft was jettisoned from aprx 500 ft AGL. Impact damage resulting from the…NTSB FTW84LA247Accident · No injuriesLimited investigationFinal reportGermany Wetherell Sonerai I · Leander, TXPrior to the flight the plt adjusted the carburetor. A local flight was made to test the carburator. During the gliding apch to the rwy the plt noticed the eng idle power was 1400 RPM. While on base leg the plt advanced the throttle, however, eng pwr remained…NTSB FTW84LA246Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Worth, TXAcft had power loss at 2500 MSL 5 min after takeoff. A forced landing was made & the acft collided with a tree during the lndg roll. Examination of acft disclosed that the mixture control cable separated from the arm at the engine where it had been over…NTSB CHI84LA211Accident · Serious injuriesLimited investigationFinal reportBell 47G · Drummond Island, MIThe plt had previously made 2 local flts, during which, he practiced water landings & takeoffs as well as other maneuvers. On the 3rd flt, he made several water takeoffs & landings. Then while on a landing, the helicopter began to roll quickly to the right.…NTSB SEA84LA121Accident · No injuriesLimited investigationFinal reportNavion A · Noti, ORAt about 4,000 ft MSL, the eng began to run rough. The plt made a 180 deg turn to return to his departure arpt. The eng then quit. He turned the fuel boost pump on, applied carburetor heat, leaned the mixture & checked the mags. The eng started & ran for…