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 SEA85FA113Accident · 2 fatalField investigationFinal reportCessna 177RG · Murphy, IDPlt received a preflight wx brief indicating a recent frontal passage in the area with strong winds and trubulence associated with thundershowers along the initial route of flight until clear of the owyhee mountains. No flt plan was filed. Radar tracked the…NTSB NYC85LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Morristown, NJAccording to the student, the acft encountered a sudden wind shift from the east as he was landing. He stated that this caused the plane to tip over to the plt's right & come to rest on its top. The student also reported that the wind was from 050 deg at 7…NTSB MKC85LA101Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Osage Beach, MOThe plt landed the acft mid-field on the 3205 ft rwy, the acft landing speed was higher than normal and a decision was made to continue the landing instead of going around for another attempt. The plt applied brakes & the acft skidded off the rwy. The plt…NTSB LAX85LA257Accident · Serious injuriesLimited investigationFinal reportCessna T303 · Mesa, AZPlt took off from scottsdale at 1934 MST for a 13 NM flt to reposition the acft to home base. Within minutes the plt advised ATC that he was 6 mi out with minimum fuel and requested no delay. He then asked for clearance to rwy 22R and was cleared to land on…NTSB FTW85FA224Accident · 1 fatalField investigationFinal reportCessna 310F · Marfa, TXThe plt experienced a partial pwr loss from the right eng during the takeoff climb and in his haste to circle back and land did not allow the acft to gain alt. He then failed to maintain adequate airspeed and as a result, lost control of the acft and stalled…NTSB ANC85LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKWhile cruising at about 2000 ft, the top eng cowling came off, rupturing an eng oil line & breaking a hole in the left side of the windshield. Oil then covered the windshield. Due to the loss of oil, the plt shut down the eng & landed on a beach. During the…NTSB SEA85LA111Accident · No injuriesLimited investigationFinal reportBeech H-35 · Owyhee Reserv., IDThe flt departed from boise, Idaho, on the left main fuel tank. Fifteen minutes into the flt the plt switched to the left auxiliary tank. Several minutes later, the engine ceased operating dispite the plts switching back to the left main fuel tank. An engine…NTSB LAX85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Morgan Hill, CAOn a personal flt, the plt & pax flew to an uncharted, dirt airstrip located in a state park. The plt acknowledged that on apch the acft was high and fast. After initially touching down, the plt stated that he tried to go-around. A park ranger reported that…NTSB LAX85LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Atwater, CAOn the student plt's third supervised solo flt he landed the acft. After touchdown he applied pwr to make a touch & go, & then raised the flaps. The acft veered left, rolled off the rwy, collided with a small dirt mound & nosed over. The student had 18.2…NTSB LAX85FA253Accident · 2 fatalField investigationFinal reportCessna 177B · Ojai, CAWitnesses observed the acft enter a box canyon in level flt at an alt below the tops of the surrounding ridges. The eng pwr sounds were reported as 'normal' by the witnesses. Shortly after the acft disappeared behind a ridge, the witnesses saw black smoke…NTSB FTW85LA223Accident · No injuriesLimited investigationFinal reportCessna 210D · Austin, TXThe plt touched down long on rwy 17 with 30 degs of flaps, apparently goind downwind. He attempted a go-around, drifted to the right and the left main gear hit a large boulder separating the gear from the acft. The plt then flew to another nearby arpt and…NTSB FTW85FA220Accident · 2 fatalField investigationFinal reportCessna 182RG · Odessa, TXWhile flying at approx 100' AGL, the acft struck a 5/8' static line on a newly constructed powerline. The cable was not yet anchored, except with pulley's on each tower and had about two miles of slack. The wire engaged the left front eng cowl and 1 prop…NTSB DEN85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Rapelje, MTThe acft settled back to ground contact after reaching an alt (EST by the plt) of 60 ft AGL during takeoff initial climb. The plt stated that he recognized the acft was settling toward the ground & noticed a dissipation of airspeed. The plt said that he then…NTSB ANC85LA082Accident · No injuriesLimited investigationFinal reportCessna C-185 · Anchorage, AKThe pilot in command touched down on a dry runway in a crab angle and lost control of the airplane resulting in ground loop.NTSB ANC85IA083Incident · No injuriesIncident investigationFinal reportCessna 207A · Cape Simpson, AK# 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.NTSB MIA85FLD02Accident · No injuriesFinal reportPiper PA-22-150 · Fort Pierce, FLPrior to a flt from the Bahamas to west palm beach, FL, the plt noted a problem with the quick-drain for the left fuel tank. After landing in west palm beach, fuel was only added to the right tank since the plt anticipated replacing the left quick-drain. On…NTSB FTW85LA219Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Corsicana, TXThe acft received substantial damage during a forced landing following a loss of power as a result of fuel starvation. The plt had selected the left fuel tank for takeoff. The left fuel gage indicated the tank was full when in fact it was empty.NTSB DEN85FA134Accident · 1 fatalField investigationFinal reportEnstrom F-28F · Carrizozo, NMThe student pilot departed albiquerque, NM with less than full fuel tanks and a worn out eng driven fuel pump which allowed fuel to be pumped overboard. No flt plan was filed. During his VMC x-country flt, the eng failed and an unsuccessful autorotation…NTSB CHI85LA194Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Lake Geneva, WIHigh sink rate developed on short final. Acft touched down 13 ft prior to runway before sink rate could be arrested. Landing gear collapsed after contacting edge of rwy which is 7 inches higher than surrounding terrain. Tail section of acft caught fire just…NTSB ATL85LA162Accident · No injuriesLimited investigationFinal reportCessna 172N · Broxton, GAThe acft collided with power lines on final apch to a private airstrip. The acft was landed in a field next to the rwy. The wires were not marked. The plt reported he was aware of the large power lines near the apch end of rwy 36 but was unaware of the small…NTSB ATL85LA161Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Savannah, GAThe plt ldg the acft with the ldg gear retracted. He stated that he evidently forgot to extend the gear.NTSB ATL85LA160Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Atkins, VAThe acft nosed over during a forced landing following a loss of pwr which resulted from fuel exhaustion. On the day prior to the accident the acft had experienced a total electrical failure. The plt stated that on the day of the accident, he lowered a rope…NTSB ANC85LA109Accident · No injuriesLimited investigationFinal reportCessna 207 · Emmonak, AKThe pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the…NTSB NYC85LA122Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Toughkenamon, PAThe glider was being towed for takeoff & had just become airborne when the canopy came open. The plt tried to latch the canopy, but was unable, so he released the glider from the tow plane. While the plt continued to try to latch the canopy, the glider went…NTSB NYC85FFJ02Accident · No injuriesFinal reportRotec Engineering Rally 3 · Constantia, NYThe pilot and passenger in a rally 3 had been airborne for approximately 3 minutes when he experienced a engine failure. The pilot set up for a landing and eventually got the engine restarted. After flying close to the ground for about 1/4 mile he started…NTSB NYC85FA120Accident · 2 fatalField investigationFinal reportCessna 210M · Morrisville, NYShortly after t/o the pilot experienced a rough running engine, continued maneuvering at a low altitude and the engine quit due to undetermined cause. The pilot attempted to stretch the glide to an open field and stalled the aircraft, which mushed into the…NTSB MIA85LA168Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Stuart, FLThe plt stated that after releasing his banner, he made a steep right bank & the acft stalled & collided with the ground. He reported that the winds were variable. Aprx 30 south, the 1335 wind was from 040 deg at 12 KTS.NTSB LAX85LA256Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pacoima, CAPlt attempted a no-flap landing during which excessive airspeed was used. The acft drifted off the right side of the rwy during the flare and subsequently touched down in soft terrain. While braking directional control was lost and the acft collided with a…NTSB FTW85LA222Accident · No injuriesLimited investigationFinal reportBeech M-23 · Willow City, TXDuring the return leg of a x-country flt to California, the plt became lost and elected to make a precautionary landing. The acft wing contacted a sign post during the landing.NTSB FTW85LA217Accident · 1 fatalLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe pilot was tow launching a glider. When about 200 feet above ground level and for unknown reasons the glider suddenly gained unwanted altitude and climbed above the tow plane. This pitched the nose of the tow plane downward before the tow line could be…NTSB FTW85IA221Incident · No injuriesIncident investigationFinal reportBoeing B767-232 · D/Fw Airport, TXThe B767 was on the takeoff roll. The pressure regulator and shutoff valve coupled with the high presure shutoff valve malfunctioned resulting in pressures being developed in the downstream aircraft ducting in excess of 300 psig. A coupling in the air…NTSB DEN85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Reserve, NMPlt stated that shortly after takeoff at an alt of aprx 100 ft AGL, the acft stopped climbing and started descending. Unable to arrest the descent, the plt attempted a forced landing in a field. Prior to touchdown the left main gear contacted the top of a…NTSB CHI85LA196Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Conneaut, OHThe plt stated that he elected to begin his takeoff roll 300 ft down the rwy due to a mud hole located at that point. During his initial climb, the plt believed the acft might not clear trees at the departure end of the rwy & elected to turn right in an…NTSB ATL85LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Andalusia, ALThe student plt reported that during a landing roll, the acft veered to the right, went off the right side of the rwy & collide with a dirt bank.NTSB ATL85LA158Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Greenville, ALThe plt stated that he made a normal apch for a full stop, 3-point landing. During the landing roll, the acft began to vibrate & shake laterally. The plt reported that the vibration was caused by a tail wheel shimmy, but at first, he did not realize what…NTSB ATL85FA157Accident · 3 fatalField investigationFinal reportMooney M20J · Covington, TNAfter takeoff, the flt progressed normally, except one ARTCC controller had difficulty communicating with the plt during the early part of the flt. After cruising at 11,000 ft for aprx 2 hrs, the plt obtained updated wx info & requested clearance to descend…NTSB ANC85LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKPlt did not use all available takeoff area and failed to recognized need to abort until too late. Possible overweight airplane loaded beyond centre of gravity rangeNTSB ANC85LA080Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot in command stated he was flying in whiteout conditions when he observed an island pass by the right side of the airplane. He started a right turn and the right wing struck the lake ice surface. He stated he did not realize he was that low.NTSB SEA85LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Rexburg, IDWhile en route, the plt circumnavigated around several storms. When the acft was about 20 mi from the destination arpt, fuel exhaustion ocurred. Subsequently, the acft nosed over during a forced landing on soft uneven terrain.NTSB NYC85LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Hancock, MAThe acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find…NTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…NTSB LAX85FA252Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ocotillo Wells, CAAccording to witnesses on a dune buggy & a honda trx 200, the acft was flying at low alt in strong winds when it seemed to encounter turbulence & go out of control. Some of the witnesses said it temporarily leveled at about 200 ft AGL. All agreed that it was…NTSB LAX85FA251Accident · 1 fatalField investigationFinal reportBeech A-36 · Hayward, CAAccording to the ATCT tapes, 3 mins elapsed between the time the acft called for taxi from parking to ready for takeoff at the active rwy. Just after liftoff the acft experienced a 'missing' & 'backfiring' engine as reported by witnesses. Plt radioed the…NTSB FTW85LA218Accident · No injuriesLimited investigationFinal reportCessna 421 · Mckinney, TXAfter landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The…NTSB CHI85LA199Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Troy, MIThe plt stated that his intended destination was the Troy-oakland arpt where he intended to land on rwy 27. However, he inadvertently landed on rwy 27 at the big beaver arpt which was aprx 3 mi away. He was expecting to have 3800 ft of rwy, but the rwy at big…NTSB MKC85FA100Accident · 2 fatalField investigationFinal reportBell 47G · Calwood, MON951B crashed in a wooded area during a powerline patrol flt which included photography of the powerline. According to witnesses, the helicopter was flying parallel to the powerline in a westerly direction when the accident occurred. Exam of the wreckage…NTSB LAX85LA250Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colusa, CADuring an ag flight, the eng began to severly backfire & lose power. The plt attempted to make a forced ldg on the nearby duster airstrip but had insufficient altitude to be properly aligned with the rwy. The acft overan the edge of the end disclosed that its…NTSB LAX85LA249Accident · No injuriesLimited investigationFinal reportHiller 12-C · Casa Grande, AZThe plt was demonstrating autorotations to a touchdown on a dirt rwy into a 5 kt headwind. On the final landing he said that the touchdown felt the same as others he had done. Speed at touchdown was 15 mph and the helicopter slid forward in a straight line…NTSB DEN85FA131Accident · 1 fatalField investigationFinal reportConsolidated-Vultee PBY-5A · Lewistown, MTDuring taxi to takeoff the brakes failed. The plt attempted to groundloop the acft. The acft rolled down hill and collided with a gully. The plt was fatally injured. During preflight the co-plt inadvertently added hydraulic fluid in the alcohol tank. The…NTSB ATL85LA163Accident · No injuriesLimited investigationFinal reportCessna 182A · Dover, TNThe student plt and his pax, a private plt, flew to another arpt and made several takeoffs and landings. Then returned to the private airstrip where their flight had originated. The student plt was at the controls on this apch. After touchdown the acft became…