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 LAX85LA162Accident · No injuriesLimited investigationFinal reportSevdy Pitts Special 104 · Yuma, AZWhile practicing aerobatics for an airshow, the plt entered a spin. During the spin maneuver, the eng sputtered, lost power & the prop stopped turning. The acft was not equipped with an electric starter, so the plt tried to windmill the prop by diving, but…NTSB FTW85LA135Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Big Spring, TXCFI was demonstrating a simulated eng failure with tailwind of 10 KTS, 20 KTS grnd speed. The acft yawed left and touchdown was made with 10 kt grnd speed. The right skid broke off and the acft rolled over. The maneuver was initiated at 4 ft skid height.NTSB FTW85LA132Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dequincy, LAEn route back to a private air strip, according to the plt, the engine failed. The engine re-started and ran for 2 to 3 seconds before stopping. The aerial application acft flew a forced ldg into pine trees coming to a stop suspended above the ground.…NTSB CHI85LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, INThe non-instrument rated plt made a forced landing in a muddy fld due to a low fuel state and IFR conditions. The acft nosed over upon touchdown. There was no record found of the plt having received a wx briefing.NTSB CHI85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Waynesville, OHThe engine quit at about 500 ft AGL during the initial takeoff climb. The pilot made a forced landing in a plowed field and the main gear sheared off. Water was observed dripping out of the gascolator after the accident.NTSB ATL85LA130Accident · No injuriesLimited investigationFinal reportCessna 140 · Hawesville, KYThe plt was on a flt from lordsburg, NM, to mansfield, OH, and could not find hancock county airport, Hawesville, KY. While searching for the airport the engine lost total power due to fuel exhaustion. The plt said that he planned to refuel at hancock co.…NTSB ATL85FMG03Accident · Minor injuriesFinal reportPitts S1C · Durham, NCThe plt reported he put the acft in a steep bank shortly after takeoff to view his son who was on the ground. He stated he failed to apply back pressure and the acft contacted trees off the end of the rwy. The acft then impacted the gorund.NTSB ATL85FLT04Accident · No injuriesFinal reportGrumman AG-CAT-G-114 · Madisonville, TNThe acft crashed in an open pasture after loss of power following a takeoff from an adjacent pasture. The acft had expereinced a power loss a few minutes earlier which had forced the plt to make an emergengy lndg. After grnd checking the powerplant the plt…NTSB ANC85LA051Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKWhile attempting to land, acft stalled in right downwind turn and contacted the ground. Plt was unaware of the 5 to 7 mph wind.NTSB ANC85LA050Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Moses Point, AKAprx 15 miles se of Moses Point the helicopter encountered deteriorating wx. A descent was made to 50 ft above the ice at an airspeed of about 50 KTS. At this time a white out condition was encountered and a right turn was initiated. The right skid contacted…NTSB ANC85LA049Accident · No injuriesLimited investigationFinal reportCessna 207 · Dillingham, AKThe plt was attempting a 180 deg turn to reverse direction away from lowering clouds and snow showers when the right wing dug into the snow covered terrain. The plt stated a virtual 'white out' condition existed at the time.NTSB MIA85LA110Accident · 2 fatalLimited investigationFinal reportRockwell 680E · Key West, FLA coast guard falcon acft was on scene when the acft ditched in the atlantic ocean due to fuel exhaustion. A life raft & marker were dropped by the coast guard acft. A search was conducted all day on 3/1/85 & was called off at sunset on on 3/2/85. The…NTSB MIA85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Brunswick, GAThe plt stated that his takeoff roll was normal, but just before he rotated, the nose gear collapsed. No determination could be made as to the nature of the malfunction during a post crash exam & retraction test of the landing gear.NTSB LAX85LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZThe plt was commencing his 1st solo x-country flt. At lift-off, the acft entered a left bank of about 45 degs. The student plt reduced power & the acft touched down hard on the dirt beside the rwy & was damaged. The plt believed that he may have encountered…NTSB LAX85LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CADuring an authorized local solo practice flt, the 31-hour student was performing takeoffs and landing. According to plt, second landing was 'hard' and a nose wheel shimmy was noted during the taxi-back for takeoff. Just before liftoff on the next takeoff, the…NTSB DEN85LA089Accident · No injuriesLimited investigationFinal reportBeech E33-C · Richfield, UTThe plt stated that he was returning to the arpt and was on the base leg of the traffic pattern when he experienced a partial loss of eng pwr. The plt stated that when he turned on the boost pump, pwr was restored for a short time. He continued to state that…NTSB CHI85LA127Accident · No injuriesLimited investigationFinal reportCessna 152 II · Wayne City, ILWhile en route on a night x-country flt the acft experienced fuel exhaustion. An emergency lndg was attempted to a road. The acft struck a power pole that was not visible in the darkness and then hung up in the wires. The acft was destroyed when it was…NTSB ATL85FA106Accident · 1 fatalField investigationFinal reportCessna 152 · Warsaw, NCLow time, non-instrument rated plt delayed departure because of unexpected deterioration of weather. Fss briefer advised wx would improve, better toward destination arpt. Wx conditions continued to worsen after briefing, worse than fcst. Plt departed 3 hrs…NTSB MIA85LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · W. Palm Beach, FLWhile en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did…NTSB MIA85FA106Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Horseshoe Beach, FLThe acft crashed in the gulf of Mexico while the plt was on a night x-country flt. The wx at the destination had been forcast to be IFR. However, in the area of the accident, witnesses stated the wx was good with no fog & it was a dark night. When the acft…NTSB LAX85LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Fremont, CAThe acft contacted a barbed wire fence and rough terrain during an emergency landing following a loss of pwr shortly after takeoff. The plt stated that two pwr interruptions occurred during the takeoff before the final pwr loss and he suspected fuel…NTSB LAX85FA160Accident · 2 fatalField investigationFinal reportBeech 76 · Shafter, CAThe accident occurred during a multi-enigne training flight. A witness stated he observed the acft initiated a single engine go around at about 50 feet above ground level and that it yawed to the left as full power was applied to the right engine. He further…NTSB LAX85FA159Accident · 2 fatalField investigationFinal reportMooney M-20-E · Oceanside, CAGnd witnesses reported the acft engine began to misfire shortly after departing ry 24 at Oceanside muni arpt Oceanside, CA. When the acft reached the departure end of the ry at ab out 100 ft AGL, the plt began a left turn. Prior to completing the turn, the…NTSB DEN85LA093Accident · No injuriesLimited investigationFinal reportCessna 421C · Butte, MTWhile in level flt the plt noticed a puff of smoke emit from the left engine, followed by the appearance of hydraulic fluid and the illumination of the left and right hydraulic flow lights. The plt lowered the landing gear during the apch, however, the nose…NTSB DEN85FA088Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Cornville, AZThe acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then…NTSB ATL85LA104Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Suches, GAAfter takeoff in mountainous terrain pilot used shallow climb on course. Pilot stated he failed to climb to a suitable altitude. When first ridge was cleared a downdraft was encountered. Pilot made 180 degree turn but was unable to climb above terrain.NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…NTSB NYC85LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Reading, PAThe acft overturned while awaiting takeoff from Reading,PA. Wind was reported from 310 degs at 16 KTS, gusting to 22 KTS. After engine up the tower advised N66RA tp hold for landing traffic which was a lear jet. Wind at this time was given as 310 KTS at 27…NTSB MKC85LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Lee'S Summit, MOUpon takeoff, acft lifted off the rwy and settled hard back onto the rwy. Inspection revealed acft was covered with 1/4 to 1/2 inch of snow & ice when the takeoff was attempted.NTSB LAX85LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Apple Valley, CAThe plt reported that during initial climb, the eng lost power. Unable to maintain flt, he made a forced landing 4 mi north of the aprt on rough desert terrain. During subsequent eng tests, sufficient power was developed to sustain flt.NTSB FTW85LA129Accident · No injuriesLimited investigationFinal reportRotorway Exec · Bethany, OKThe owner/builder had a single engine, multi-engine, land rating, but did not have a helicopter rating. While practicing hover flt in his experimental helicopter, he unexpectedly allowed the helicopter to reach a higher than normal alt. He attempted to…NTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…NTSB CHI85LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Traverse City, MIAccording to the plt, no icing pireps or sigmets were received during his preflt wx briefing. However, the NWS briefer stated that he told him of one PIREP & one SIGMET concerning icing that affected his proposed route of flt. En route to his destination, the…NTSB MKC85FA062Accident · 3 fatalField investigationFinal reportPiper PA-31P · Sunset Hills, MOThe acft was on a ngt instructional flt with 2 multi-eng instructor plts at the controls & a rated plt occupying a rear pax seat. The rgt fnt seat occupant was an experienced multi-eng plt with 110 hrs in this make & model; however, his 2NDCLASS med cert was…NTSB MIA85FA105Accident · 1 fatalField investigationFinal reportCessna 210 · Jacksonville, FLThe acft crashed & burned while attempting to return to the arpt after the pilot reported a power loss shortly after takeoff. A post crash exam of the engine did not reveal any evidence to suggest any failure or malfunction prior to impact.NTSB LAX85FA156Accident · 3 fatalField investigationFinal reportCessna 152 · Newport Beach, CAThe student plt took off on a dark night in marginal wx conditions with 2 passengers occupying the only passenger seat. About 17 min later, the acft was observed in a low pass over a pier at Newport Beach, CA, flying toward the open ocean. After crossing over…NTSB FTW85LA128Accident · No injuriesLimited investigationFinal reportCessna 205 · College Station, TXThe acft veered to the right on touchdown. The plt was unable to regain control before the acft departed the right side of the rwy and nosed over when it entered the soft terrain. No evidence of a nose gear failure was found.NTSB CHI85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankton, INDuring a setup for a practice stall the solo student pilot retarded the throttle, raised the nose slightly and applied carb heat. He believed he was losing airspeed too quickly so he then reapplied full power. At this point the engine rpms dropped to 5 or…NTSB LAX85LA155Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Santa Barbara, CAStudent plt stated that while flying the last leg of a solo cross country flight he was flying along the coast at 50 to 75 feet, he diverted his attention to look at the a man on the beach and when he looked back at the instruments he noticed the helicopter…NTSB LAX85LA154Accident · No injuriesLimited investigationFinal reportCessna 421 · Concord, CAThe acft sustained wing spar damage during a hard landing. Plt stated he misjudged height of the acft over the rwy and let the airspeed become too slow during the landing.NTSB LAX85LA153Accident · No injuriesLimited investigationFinal reportBarnes FF-8-24 · Scottsdale, AZOn landing the balloon touched down short of the desired landing area. The pilot heated slightly in order to proceed to smooth field. A strong gust picked up the balloon and took it into power lines which arced and the balloon caught fire. The pilot stated…NTSB FTW85LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-112 · Pearland, TXCFI put down two notches of flaps which is full down on the PA-38. CFI stated he had flown a PA-28-161 that morning and that two notches of flaps on that acft were used for short field takeoffs. The acft entered a stall-mush after takeoff and control was lost…NTSB FTW85LA126Accident · No injuriesLimited investigationFinal reportCessna 150J · Broken Bow, OKThe acft nosed over short of the rwy while the plt was making an emergency landing after a reported power loss. During the landing, the acft nosed over & was damaged. No reason for the power loss was found.NTSB DEN85LA087Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Lapoint, UTThe acft collided with a snowbank while taking off from a road near Lapoint, Utah. The acft was being used to count elk on an indian reservation. The plt landed to relieve himself. On the subsequent takeoff the acft hit a chuckhole in the road which caused it…NTSB DEN85LA086Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Bridger, WYThe acft encountered moderate turbulence and IFR conditions while en route over Fort Bridger, WY. The plt stated he attempted to climb on top but the acft had accumulated ice and the altimeter and VSI indicated a rapid descent. A forced landing was then…NTSB DEN85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Polson, MTThe plt stated a 35 kt gust of wind from the north lifted the tail of the acft to the left. The acft veered right, contacted a snow bank and nosed over. The plt was taxiing on rwy 18 after landing when the accident occurred.NTSB CHI85LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ephriam, WIThe aircraft began drifting to the right during the landing flare. As the aircraft touched down the right wheel entered an area of slush. The aircraft then slid off the runway to the right into a snowbank, damaging the landing gear and left wing tip. The…NTSB SEA85LA066Accident · No injuriesLimited investigationFinal reportCessna TU206F · Seattle, WAThe acft landed short of rwy 13R at Boeing fld following a loss of pwr due to fuel exhaustion. The acft was topped off for a ttl of 108 gals of fuel before this third leg of a x-country flt. The plt stated that the eng ceased operating en route, however, pwr…NTSB NYC85LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, NYWhile en route, the plt encountered strong, gusty winds & moderate to severe turbulence. After arriving at the destination arpt, he made 3 approaches to rwy 21. He stated that wind shear caused up & downdrafts & that the acft hit the rwy hard & ballooned.…NTSB NYC85LA070Accident · No injuriesLimited investigationFinal reportCessna 182 · Medford, NJAccording to a cap plt, who was waiting to takeoff, the plt of N1966X undershot his landing touchdown point to such a degree that N1966X nearly hit an embankment short of the rwy. N1966X touched down at or near the apch end of the rwy. The plt (of N1966X)…