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 ANC84LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Burgress Strip, AKThe plt stated that when the acft was on short final apch to land on an airstrip, it stalled. During impact, the gear box, right wing tip, prop, eng mounts, eng cowling & right elevator were damaged. The plt recommended receiving training before attempting…NTSB ANC84LA133Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Skwentna, AKDuring cruise, plt was troubleshooting rhythmic power interruption (missing) when fire broke out in the engine compartment. Plt headed for arpt, gear down, but elected to make a precautionary landing off arpt when the fire intensified. Landing gear sheared in…NTSB SEA84LA195Accident · Serious injuriesLimited investigationFinal reportCessna 210-5(205) · Mountain Home, IDDuring climb the rpms started to decrease. The acft was unable to maintain alt and a forced landing was made. During investigation a bogus fuel filter was found between the fuel control unit and the fuel injector. The filter was clogged with debris. The…NTSB SEA84FA198Accident · Serious injuriesField investigationFinal reportLuscombe 8F · Levenworth, WAAccording to the plt, downdrafts encountered after takeoff prevented a normal climb and resulted in a collision with trees at 60 to 80 ft AGL aprx 1 mile from the arpt.NTSB SEA84FA196Accident · 1 fatalField investigationFinal reportPiper PA-22-160 · Bonners Ferry, IDThe plt took off with 3 adult passengers & a 2 yr old child on board & flew aprx 1.3 hrs. Just prior to the accident, he reported on a left downwind for rwy 20. As the plt continued the apch, the acft was observed over the rwy at aprx 100' AGL, reportedly at…NTSB NYC84FA274Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Sydney, NYDuring a night arrival, the plt was cleared for a vor/circling apch to the sidney muni arpt. The published apch was from the hancock VOR with a northerly heading to the arpt of 354 deg. Subsequently, the acft crashed & burned on wooded terrain about 1 mi…NTSB MKC84LA253Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Plains, KSThe acft collided with a tall crop during an attempted takeoff from a dirt road. The acft had failed to become airborne on another road after about 2600 ft of run and the attempt was aborted. This takeoff run was about 2800 ft according to the plt. The plt…NTSB MKC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Branson, MOExcessive airspeed caused the acft to float about halfway down the rwy prior to touchdown. A go-aground was initiated with the addition of power but the plt then elected to attempt to stop due to low airspeed and minimal rwy remaining. The plt then applied…NTSB LAX84LA438Accident · No injuriesLimited investigationFinal reportCessna 152 · Cressey, CAWitnesses observed two acft making multiple low passes down the river. Each acft was seen flying under 3 electrical power lines at least 3 times. On the last pass, according to local law enforcement officers, one acft struck and severed all 3 power lines.…NTSB LAX84LA436Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Chinle, AZAt about 1400 MST, the plt took off. He climbed & leveled off at 8500 ft. he was using fuel from the right tank which ran dry, then he switched to the left tank. At that time, he thought he had 30 mins of fuel remaining. He decided to land at Chinle, AZ, &…NTSB FTW84LA345Accident · No injuriesLimited investigationFinal reportCessna A185F · Tomball, TXBefore takeoff 2 paxs boarded so the instructor could demonstrate to the student the effect that additional weight has on acft handling on water. According to the instructor the acft would not become airborne during takeoff. The acft overran the waterway,…NTSB DEN84FA259Accident · 1 fatalField investigationFinal reportCessna 172 · Lyons, COThe acft plunged to the ground after being seen doing a series of stall/spin maneuvers at a low alt. One witness saw thefinal maneuver and after seeing the acft disappear behind trees he went in search of it and found it about 100 yds southof the position he…NTSB CHI84LA405Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mackinac Island, MIPlt stated that during takeoff, at an alt of 40 feet AGL a loss of power occurred. He reported he landed straight ahead on the end of the runway. The airplane continued into a field off the departure end of the rwy, into weeds before it struck a steel fence…NTSB CHI84LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manchester, OHThe accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport…NTSB CHI84FA343Accident · 2 fatalField investigationFinal reportPiper PA-12 · Alpena, MIWitnesses stated that the acft flew at a very low altitude over the lake performing what appeared to be a series of stalls and recoveries with the acft climbing steeply to aprx 150 ft above the lake and then dropping sharply back down within a few feet of the…NTSB ATL84FLT12Accident · Serious injuriesFinal reportFred Williams KR-2 · Russellville, KYThe only witness the plts wife, said that the acft dropped out of the sky and burst into flames when it hit the ground. The plt was seriously injured and does not recall anything about the accident. The acft was a home built which was builtby the plt. The…NTSB ANC84LA135Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKThe plt was trying to land on a gravel oil drilling pad. The acft landed short of the pad and collided with a beam. After a bounce and a yaw the acft touched down again and the rt main landing gear failed. The plt said his selection of landing area was poor.NTSB SEA84FYK01Accident · Serious injuriesFinal reportCessna 172N · Creswell, ORThe acft collided with wires during an attempted go-around. The plt stated that he had made one go-around and on the 2NDLANDING attempt he landed hard in gusty wind & bounced. During the 2nd go-around he collided with wires & crashed.NTSB NYC84MA270Accident · 1 fatalMajor investigationFinal reportSikorsky S-76A · Fort Dix, NJThe aircrew of the helicopter contacted mcguire rapcon & obtained clearance to proceed thru the mcguire afb control zone at 1500 ft. a short time later, the crew declared an emergency. Witnesses on the ground heard a loud 'bang' & observed the helicopter…NTSB NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…NTSB MKC84LA247Accident · Minor injuriesLimited investigationFinal reportDarrell W. MC Moran Monnett Moni · El Dorado, ARAfter lift-off on initial test flight of this homebuilt acft, the engine ceased to develop full RPM. The plt was unable to establish a rate of climb to clear terrain obstacles in the flight path, colliding first with tree tops and then the ground. Plt…NTSB MKC84LA246Accident · No injuriesLimited investigationFinal reportCessna 305A · Blakesburg, IAThe acft mushed into tall corn off the end of the rwy during an attempted go-around. The plt said he landed long on the 2170 ft turf rwy in calm air and did not think he could stop so a go-around was initiated. He said a seat belt interfered with the…NTSB MIA84LA226Accident · No injuriesLimited investigationFinal reportAyres Thrush S2R-T15 · Quitman, GAAt the end of swath run the acft struck a piece of farm equipment during the pull-up. After the collision the plt noticed liquid trailing behind the acft as he returned to his departure airport. Upon ldg when the left wing settledclose to the rwy, the plt…NTSB LAX84LA434Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lincoln, CADuring acft pre-flight, plt checked fuel quantity by reference to gages only. Both gages indicated full. After 1 hr and 10 min flt, complete pwr loss occurred. Plt stated gages still indicated full. Forced landing on open field executed but plt flared high,…NTSB LAX84LA433Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Coulterville, CAThe plt reported that on his apch to land, the sink rate became greater than anticipated & the right main gear hit the top of a fence. Subsequently, the right main gear collapsed & the acft veered off the rwy & hit an embankment.NTSB LAX84FVM02Accident · Minor injuriesFinal reportGrumman American AA-5B · Monterey, CAThe acft collided with hilly terrain aprx 6 miles east of the arpt during the second attempted ILS rwy 10 apch. The plt stated that communication and navigation problems were experienced during the flt. He also stated he changed fuel tanks every 1/2 hr during…NTSB FTW84LA346Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Fulshear, TXOn the takeoff roll, a 'short duration cross control condition occurred' between the student and instructor pilots, resulting in the acft departing the right side of the runway, power was reduced but the acft rolled into a dirt bank and mud holes, collapsing…NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…NTSB CHI84FA342Accident · 1 fatalField investigationFinal reportPiper PA28-140E · Montmorenci, INThe acft crashed while on a x-country personal transportation flt. Prior to departure, the plt telephoned a relative at the destination, 118 miles away, & had been informed that the flt conditions (wx) at brazil were good. The plt did not obtain a wx briefing…NTSB ATL84LA253Accident · No injuriesLimited investigationFinal reportCessna 152 II · Clarksville, TNThe 13 hour student pilot was on her first supervised solo flight. The wind was reported calm and the student pilot had made two touch and go's. on the third, she added full power for takeoff and the aircraft veered left. She attempted to correct by using the…NTSB ATL84FA252Accident · Minor injuriesField investigationFinal reportBoeing A75N1 · Cumming, GAThe acft experienced a partial pwr loss during takeoff. The pilot released the banner the acft was towing, made a left turn into a valley and collided with a ditch during a forced landing. Investigation revealed maintenance deficiencies in both the carburetor…NTSB ATL84FA251Accident · 3 fatalField investigationFinal reportDouglas DC3C-S1C3G · Memphis, TNMoments after the DC-3 took off, the twr ctlr noted the l eng was torching & asked the flt if it was 'having a problem.'the crew replied 'affirmative,' then the ctlr clrd the flt to lnd on any rwy. The acft began turning left at the end of the rwy & contd…NTSB SEA84LA194Accident · No injuriesLimited investigationFinal reportBeech C-23 · Adel, ORPlt made forced landing in sagebrush covered hilly terrain following a ttl loss of pwr resulting from fuel exhaustion.NTSB MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB LAX84LA432Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Compton, CAThe student pilot attempted a second full stop landing on rwy 25R. The airport management personnel stated that the wind was favoring rwy 7. The student plt stated that the acft appeared to have a faster than normal ground speed. The acft touched down near…NTSB FTW84FA343Accident · Serious injuriesField investigationFinal reportCessna 150J · Justin, TXThe acft collided with a power line and nosed over during an attempt to recover from a simulated forced landing. The cfireportedly 'cleared' the engine during the approach but when she took over and added power to climb she claimed the engine did not fully…NTSB DEN84FA308Accident · 2 fatalField investigationFinal reportCessna L-19E · Tabernash, COThe airplane departed grandby 8/10/84 and failed to arrive at its destination. On 8/23/87, it was found on the slope of a high tree-covered ridge. Video tape recovered from the wreckage provided a visual and audio record of the flight from takeoff to impact.…NTSB ATL84LA254Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nashville, TNThe pilot reportedly set up a high rate of descent on final approach so that he could land the aircraft near the approach end of the rwy to avoid excessive braking on the wet rwy. The pilot descended the aircraft below the glide slope provided by the VASI and…NTSB SEA84LA197Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Prineville, ORWhile maneuvering plt heard a loud chatter coming from the engine accompanied by a loss of power. Plt reduced remaining power and initiated a forced landing in a rough barley field. Post accident investigation revealed the crankshaft broke near the number two…NTSB SEA84LA193Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Langley, WAThe ATP was attempting a short field three point takeoff during which trees needed to be cleared. When realizing sufficient alt had not been obtained to clear the trees, the CFI took over the controls and applied back pressure in an attempt to climb. The acft…NTSB MKC84LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot stated that during an aborted takeoff, due to an engine power loss, he was not able to stop before running off the end of the 2600 foot long runway. He said that when he felt that the airplane was ready to fly he glanced down at instrument panel and…NTSB MIA84LA223Accident · Minor injuriesLimited investigationFinal reportBeech D-55 · Atlantic Ocean (Atlantic Ocean)The plt stated that he set the throttles for 45 percent power after climbing to 1500 ft MSL. After about 4 hrs of flight the left eng failed followed by a right engine failure moments later. The acft was ditched and never recoveredbecause it sank into the…NTSB FTW84LA349Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tallulah, LAAfter applying seven (7) loads of chemicals the pilot landed and loaded both fuel and chemicals. After takeoff he completed one swath run and was just starting the second run when he allowed the wheels to contact the crop. The load was not jettisoned and the…NTSB FTW84FA342Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Tulsa, OKOn climbout from a night takeoff, a complete power loss occurred. The plt attempted to return to the airport, but insufficient altitude was available. During an ensuing forced landing, the acft collided with trees before ground impact. An investigation…NTSB CHI84LA344Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Sidney, OHThe acft collided with the ground in a corn field during a simulated forced landing after the power failed to respond to full throttle. The acft had been descended from 3000 ft AGL with throttle at idle, full flaps and carburetor heat on. In turning 180…NTSB CHI84LA341Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Delaware, OHAfter being airborne for aprx 20 min the plt landed, taxied to the end of the strip, and departed again. At about 300 ft AGL the power loss occurred. Investigation of the wreckage revealed 3 qts of oil in the eng with no apparent oil leaks, a combination of…NTSB ATL84FA250Accident · 1 fatalField investigationFinal reportCessna 150F · Banner Elk, NCAcft observed to depart short strip in hi dens alt conditions, 'wobbled into the air.' Acft did not circle for altitude, but headed straight ahead toward rising terrain 'wings rocking' at slow speed before right wing dropped and acft collided with terrain. No…NTSB MKC84LA243Accident · Minor injuriesLimited investigationFinal reportTate SNS-7 · Larned, KSPlt stated that shortly after takeoff a loss of pwr occurred. Plt pulled up to fly over pwr lines rather than hit a fence under the lines. The acft cleared the wires then stalled into a field. The plt stated the engine was running roughduring the previous flt…NTSB MKC84LA241Accident · No injuriesLimited investigationFinal reportCessna 177B · Winterset, IAThe plt had diverted & was making a precautionary landing due to an approaching storm. At about 50 ft over the rwy, the acft stalled & landed hard. It then bounced 3 times, damaging the nose gear, forward fuselage & right wing.NTSB MIA84FA225Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Navarre, FLPlt was engaged in banner tow pick up. Prior to engaging pick up line, acft struck ground nose down. Ground scars related to impact damage show wings rotated 180 degrees from path of flight prior to impact.