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 CHI85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Mosinee, WIThe plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft.NTSB CHI85FEX03Accident · Serious injuriesFinal reportPiper PA-28-180 · Orleans, INDuring flt, the plt noted that the eng RPM dropped from 2500 to 2000. He could not restore the RPM. He then heard a loud noise from the eng compartment & the eng seized. Subsequently, the acft was damaged during an emerg landing in a corn field. A teardown of…NTSB ATL85FA191Accident · 1 fatalField investigationFinal reportPiper J5A · Cleveland, GAThe plt took off from a private strip with his 5 yr old daughter on board. He then made several low passes by a guest house so that his daughter could wave to her grandparents. The acft was last seen headed generally in a northerly direction when it banked…NTSB ANC85LA101Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bering River, AKThe plt stated that during a 15 to 20 min period after he had landed, the wind velocity increased greatly. He managed to taxi the float plane to an area where he could takeoff into the wind. As the acft was on the step for takeoff, the left wing lifted as if…NTSB ANC85LA098Accident · No injuriesLimited investigationFinal reportCessna 180 · Northway, AKDuring arrival, the plt landed the tail wheel equipped acft on rwy 22 with a x-wind from 290 deg at 8 KTS. After touchdown, the acft entered a ground loop & was damaged. A check of the plt's blood showed an alcohol level of 0.249%.NTSB ANC85FA102Accident · Minor injuriesField investigationFinal reportGrumman G-44 · Dillingham, AKThe amphibious acft crashed as the plt was landing on glassy water at the inlet of nerka lake. Subsequently, it sank & came to rest inverted in clear water on the bottom of wood river with the gear retracted & the flaps extended. Moderate rain was falling…NTSB ANC85FA100Accident · Minor injuriesField investigationFinal reportCessna 180H · Theordore River, AKThe plt landed the float plane on the Theordore River which had a maximum width of about 90 ft & had few straight runs of more than 400 ft. the River had many sharp turns, some in excess of 150 degs, & its depth was as low as 18 inches at low tide. The plt…NTSB ANC85FA099Accident · 1 fatalField investigationFinal reportMaule M-5 · Theodore River, AKThe pilot caught left wing tip while turning to land and lost control of the airplane crashing into turg.NTSB NYC85LA160Accident · No injuriesLimited investigationFinal reportCessna 182P · Newport, NHThe acft collided with trees during an attempted go-around following a loss of directional control. The plt was advised by UNICOM that a 'bit of a crosswind' existed at the arpt. The plt initiated a go-around after a gust of wind was misaligned the acft…NTSB NYC85FA152Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-B · Waitsfield, VTThis glider was involved in a soaring championship course. About 52 minutes after starting the course witnesses observed the aircraft maneuvering for a landing on an open field. While in a steep bank the aircraft stalled and impacted the ground.NTSB MKC85FA134Accident · 1 fatalField investigationFinal reportRyan Navion A · Kingman, KSAfter departing a pvt strip the acft was observed to perform some low altitude aerobatic maneuvers. The maneuvers consisted of two snap rolls at about 100 feet off the ground. The acft was observed descending steeply on the second roll maneuver until striking…NTSB MIA85IA197Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Ft. Pierce, FLThe landing check list was not properly followed and both pilots neglected to extend the landing gear in preparation for landingNTSB LAX85LA284Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Glenn, CADuring initial climb on an ag flight the plt reported experiencing a loss of eng power. From the acft's alt of 30 ft AGL the plt attempted an emergency landing but did not have sufficient alt to negotiate a turn back toward the road from which he had…NTSB FTW85FA259Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Rocksprings, TXAs the acft was climbing thru 14,800' for 19,000', the plt reported a rapid decompression. Two minutes later, he reported that he has lost the tail. Acft impacted in an inverted flat spin and the tail and a section of empennage were found about 3/4 mile away…NTSB DCA85AA023Accident · Serious injuriesFinal reportGeneral Dynamics 240-27 · West Trenton, NJThe coplt bgn takeoff (tkof) with 2700 RPM & 52 to 53.5' of manifold pressure (mp). Wtr injection was not used altho 12 gal was available. At 150 to 250 ft AGL, the l eng lost pwr & the l prop autofeathered. The capt took control (ctl) & took action to verify…NTSB ANC85LA097Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKPlt lost control on landing and ground looped. Wx and field conditions not a factor.NTSB SEA85LYE02Accident · No injuriesFinal reportAero Commander 600S-20 · Pasco, WAThis Aero Commander 600S-20 departed on an aerial application flight. Shortly after takeoff the pilot noticed flames coming from the engine compartment, experienced a power loss and made a forced landing in sand dunes, substantially damaging the aircraft.…NTSB SEA85FA142Accident · 3 fatalField investigationFinal reportMaule M-6-235 · Gibbonsville, IDThe plt and two passengers departed on a 2 hr flt for the purpose of conducting aerial observation of mine sites. The acft was operating in mountainous terrain during hot temp conditions resulting in a high density alt. There were no witnesses to the…NTSB MIA85IA195Incident · No injuriesIncident investigationFinal reportPiper PA-38-112 · Miami, FLThe acft wing dropped to the rwy after lndg. The CFI said that the lndg was smooth with the student plt at the controls. When the wing started dropping the CFI said he took the controls but could not keep the wing up. Post acc invest showed that the left main…NTSB FTW85FRD02Accident · 1 fatalFinal reportTeratorn Tierra II · Lake Charles, LAThe acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground…NTSB DEN85LA168Accident · No injuriesLimited investigationFinal reportHughes 269C · Grand Forks, NDOn June 18, 1985, a student plt and his instructor were on alocal tng flt. Prior to completing the mission, the instructor had his student execute a 180 degree autorotation. During the maneuver, the main rotor RPM was allowed to decay into the critical range…NTSB CHI85LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Peoria, ILIt was reported that the plt made an intersection takeoff with about 4500 ft available. Lift off was made with about 2700 ft of rwy left. The acft did not climb. Low but smooth power output was heard. The flight overflew about three fields that reportedly…NTSB CHI85LA236Accident · No injuriesLimited investigationFinal reportCessna 172 · Jenison, MIThe plt leveled the wings during the landing flare in a x-wind but failed to remove rudder input. The acft drifted to the right of the rwy and touched down in a grass area where it contacted a gully and nosed over.NTSB CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…NTSB SEA85LA140Accident · Serious injuriesLimited investigationFinal reportCessna 188A · Pocatello, IDDuring aerial application the aircrafts engine ceased operating. During engine tear down it was discovered that the engine's #2 connecting rod was broken and had come through the top of the crankcase. Recommended overhaul time is 1200 hours. This engine had a…NTSB MKC85FA133Accident · 2 fatalField investigationFinal reportHildebrand Spezio Sport DAL-1 · Gravois Mills, MOWitnesses reported that the acft made at least two complete circles over a cove on lake of the ozarks at low alt. Part of the acft track took it over the southeast shoreline where several lake homes are located. During the third circle, as the acft approached…NTSB LAX85LA279Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAEng failed due to fuel exhaution while the acft was on final apch to rwy 18 at Apple Valley. A forced landing on rough terrain short of the rwy resulted in substantial damage to the acft.NTSB LAX85FA283Accident · Serious injuriesField investigationFinal reportBeech 35 · Cameron Park, CAIt could not be determined which of the two private plts on board the acft was serving as PIC & at the controls of the acft. The density alt was computed to be 4100 ft. there was very little wind & the max allowable gross weight was exceeded by aprx 123…NTSB DEN85LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clovis, NMAs the plt was pulling up over a power line at the end of a spray run, the eng lost power & smoke began coming from the right side of the eng. The plt turned to land in a field, but was unable to align the acft with forrows. During a forced landing, the acft…NTSB DEN85FA167Accident · 8 fatalField investigationFinal reportCessna 402B · Bailey, COGround witnesses observed the acft enter low clouds going south, then emerge from clouds going went. Acft collided with mountain in wings-level and powered attitude. Mountains were reported to be obscured by clouds and fog.NTSB CHI85LA235Accident · No injuriesLimited investigationFinal reportBeech V35B · Boscobel, WIThe engine failed on final approach. The aircraft did not clear a wooded area resulting in an uncontrolled descent. The camshaft had failed at the number 1 journal oil groove.NTSB ANC85LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mulchatna River, AKPlt reported that left wheel axle broke during aborted takeoff from gravel bar, causing acft to ground loop. Plt failed to provide complete info & broken axle for analysis.NTSB SEA85LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · North Plains, ORAn overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine…NTSB NYC85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Champlain, NYDuring the landing in a pasture with tall grass, the main wheels contacted the grass, the acft slowed rapidly and nosed over.NTSB NYC85LA148Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Peru, NYThe acft nosed over while landing on a private sod airstrip. The plt reported touchdown was made on an unmowed portion of the airstrip. The acft slowed quickly and nosed over just prior to coming to a stop.NTSB MKC85FCD01Accident · 1 fatalFinal reportJoel K. Senter RV-4 · Jefferson, IAThe acft crashed out of control after & low alt demonstration passes above rwy at about 50 ft AGL. After the last pass, a low airspeed maneuver. The plt executed a steep turn and descended in a nose low attitude to ground impact.NTSB MIA85LA194Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-201 · Vero Beach, FLThe acft was deviating around thunderstorm cells when it encountered heavy turbulence. The cabin attendants were conducting beverage service at the time. The passengers andybeen advised to gasten their seat belts and the 'fasten seat belts' lights were on.…NTSB LAX85LA278Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Van Nuys, CAAn eng failue was experienced while on final apch to rwy 16R and the plt elected to make the forced landing on a sod farm near the arpt. He stated he had plenty of alt to reach the selected touchdown point, but he made a slight left turn to avoid large trees.…NTSB LAX85LA277Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Healdsburg, CAThe plt stated his apch was normal but when reaching the rwy threshold, the descent seemed to stop. There was a reportedheadwind of 30 KTS. He then applied full flaps. Seconds lat er lift was lost and the plt applied full pwr for a go around. The acft touched…NTSB LAX85FA280Accident · No injuriesField investigationFinal reportRobinson R22 · Manhattan Beach, CAThe helicopter was to fly in formation with a banner towed by an acft 'to attract attention.' Numerous witnesses along a 20-mile stretch of Beach saw the helicopter 'flying erratically' & 'buzzing the Beach' just prior to the accident. Witnesses saw the…NTSB FTW85LA260Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe pilot stated he first saw another aircraft ahead of and below him on final to the runway. He maneuvered to establish interval, then decided to go around. He added fullthrottles but left the flaps and gear down. Unalbe to climb,he decided to land behind…NTSB FTW85LA258Accident · No injuriesLimited investigationFinal reportCessna 150 · Girard, TXThe plt stated he had just buzzed a friend's house when the eng began running rough. He was making a precautionary landing on a country road when a wing dropped and drug on the side of the adjacent ditch. The acft spun around 180 degs,sustaining substantial…NTSB CHI85LA243Accident · No injuriesLimited investigationFinal reportCessna 172 M · Decatur, INThe pilot landing rnwy 36 winds were 210 degrees, 12 knots gusts 18 knots stalled out high onthe wet on the wet sod runway the nose wheel dug in and then broke off the acft then nosed over inverted.NTSB CHI85LA239Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deckerville, MIPurpose of the flt was a 'flour bombing contest'. After dropping a 'flour bomb' the plt entered a right bank to avoid trees along the flt path. The acft then stalled and impacted the ground on the main gear after which it nosed over.NTSB CHI85LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Starbuck, MNPlt landed in crosswind conditions, veered off the edge of tha rwy onto rough, unleveled terrain. The nosewheel collapsed and the aircraft nosed over.NTSB CHI85FA234Accident · 1 fatalField investigationFinal reportRepublic RC-3 · Eveleth, MNOn takeoff from ely lake the acft turned sharp left at an altitude of 80-100 ft. at this point the acft ceased rated to climb and decended into trees and a lakeside house. The a cft was in excess of 400 lbs over gross weight. The lading gear and nose ballast…NTSB ATL85FA189Accident · 2 fatalField investigationFinal reportCessna 172H · Hendersonville, NCThe plt reported that during takeoff, the eng lost power as the acft was climbing thru about 100 to 125 ft AGL. He made a rgt turn back toward the arpt to land. However, the acft stalled, then impacted in a parking lot near the departure end of the rwy &…NTSB ANC85LAG01Accident · Minor injuriesFinal reportBrians Puffin · Eagle River, AKThe plt was conducting taxi tests on his homebuilt acft when it started to sustain a hull structure failure and control interference from separating parts. The acft pitched off the water, climbed to aprx 100 ft AGL, stalled and spun to ground impact.NTSB ANC85LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe acft dragged the left wing tip during lndg in a x-wind. The plt stated that he knew the wind was gusty before his takeoff but he felt certain that he could handle it. He stated after the accident that during the landing he had the acft in a crabbed…NTSB SEA85LA139Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Ontario, ORThe plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at…