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 CHI84FA369Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Muncie, INWitnesses reported that when the acft was taking off, the eng sounded 'rough & was backfiring.' They observed the acft cross the departure end of the rwy at a lower alt & slower speed than what they considered as normal. They saw the acft's wings rock, then…NTSB NYC84FFA05Accident · Serious injuriesFinal reportRussell ST. Arnold RLU-1 · Oneonta, NYThe acft was observed making taxi runs up & down rwy 13. On the last run the acft became airborne, climbed to aprx 75 ft, made a steep left bank & impacted the ground. The plt stated he has no recollection of making the takeoff.NTSB MKC84LA286Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Beatrice, NEDuring the flare an uncontrolled rate of descent developed resulting in a touchdown short of the rwy threshold. The mainldg gear struck the 5 inch exposed rwy lip. Density alt was aprx 4,200 ft.NTSB MKC84FCA02Accident · Serious injuriesFinal reportMooney M20E · Chesterfield, MOThe acft crashed short of the rwy after making a 180 deg turn after takeoff following a loss of power. The plt stated that after takeoff & at an indicated airspeed of 100 to 110 mph, at an altitude of 50 ft, the acft eng started to lose power. He decided to…NTSB ANC84LA149Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Egegik, AKThe acft landed short of the intended landing area. The landing gear caught on brush and the acft nosed over. The plt stated there were no mechanical irregularities. The intended landing area was a dried lake bed.NTSB ANC84LA148Accident · 2 fatalLimited investigationFinal reportCessna 180 · Iliamna Bay, AKThe acft struck a gravel bar while taxiing. The acft was not freed from the gravel bar until the next morning due to a receding tide on the previous night. Approx 3 hours later as the pilot taxied around awaiting daylight for takeoff, the acft rolled over in…NTSB ANC84LA147Accident · No injuriesLimited investigationFinal reportCessna 207A · Sleetmute, AKWhile cruising at 1100 ft AGL the eng failed without warning. Efforts to restart were unsuccessful. A forced landing was made into wooded terrain and the acft nosed over during the roll. Eng exam revealed that the crankshaft was broken through the crank cheek…NTSB LAX84LUJ02Accident · No injuriesFinal reportCessna 188A · Salome, AZThe plt said his prop stirred up a cloud of dust during takeoff and in a state of reduced visibility he collided with a mound of dirt. The collision separated the left main landing gear from the acft. Subtantial damage was done to the acft.NTSB LAX84LUJ01Accident · No injuriesFinal reportCessna 188B · Salome, AZThe acft collided with the terrain following a loss of power due to fuel exhaustion while spraying a cotton field. The plt stated he was aware of the low fuel supply but was pushing to complete the job before dark.NTSB LAX84FA459Accident · 5 fatalField investigationFinal reportPiper PA-28-140 · Yucaipa, CAThe acft was observed with its' wing dipping as it flew low over a valley. The acft then touched down in a fld, collidedwith a boulder and a tractor trailer. Examination of the acft disclosed no evidence of a malfunction. The accident site is 6 miles east of…NTSB FTW84LA369Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Austin, TXAfter lndg the plt exited the acft to assist deplaning of the pax. The engine was still running. The plt heard a surge of engine power followed by the acft rotating and colliding with a parked car. Examination of the acft disclosed that the collective balance…NTSB DEN84LA270Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Grand Forks, NDDuring initial takeoff climb at an alt of aprx 100 ft AGL, engine began missing. Unable to maintain alt, forced landing was made in a plowed field during which landing gear was torn from the acft. Inspection revealed #5 cylinder head separated from the…NTSB DEN84LA269Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Price, UTThe pilot was following a mountain road through a pass when aircraft performance became insufficient to out climb risingterrain and continued until there was insufficient manuvering room to reverse course. A forced landing was effected on the road and the…NTSB DEN84LA268Accident · No injuriesLimited investigationFinal reportCessna 182Q · Billings, MTThe pilot was landing with a 30 degree left crosswind of 15 knots, gusting to 27 knots. On touchdown, the acft veered off the runway and nosed over. The pilot cited more crosswind training and practice as preventative actions.NTSB CHI84LA367Accident · No injuriesLimited investigationFinal reportCessna 182G · Crawfordsville, INPlt stated that while en route the generator circuit breaker popped and attempts to reset it proved futile. A loss of pwr occurred later in the flt and a forced landig was made in a field during which the acft was damaged. No fuel was found in the acft after…NTSB CHI84LA366Accident · No injuriesLimited investigationFinal reportCessna A188B · Delavan, MNThe plt stated the acft would not climb rapidly enough on takeoff to clear powerlines. Plt elected to fly under the wires instead of climbing over them and risking stalling the acft. The prop, windshield, and vert stabilizer contacted the lowest wire. Plt…NTSB CHI84LA365Accident · No injuriesLimited investigationFinal reportMeyers OTW · New Athens, OHThe acft nosed over in an open field during a forced landing after the engine quit. 2 witnesses, one an A&P mechanic, reported that there was no evidence of fuel on board the acft after the accident. The plt stated to the highway patrol trooper at the scene…NTSB ANC84LA171Accident · No injuriesLimited investigationFinal reportHelio H-395A · Shellerbager Ps, AKThe plt landed on a rwy that was covered with 18 to 30 inches of snow. Shortly after touchdown the acft nosed over. The plt recommended that when in doubt about landing-don't land.NTSB NYC84FA293Accident · No injuriesField investigationFinal reportCessna 150M · Meriden, CTA cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries.NTSB MKC84FA263Accident · 2 fatalField investigationFinal reportRockwell S-2R · Palestine, ARAfter an aerial spray operation, the plt took a passenger aboard the single place acft for a 'ride around the field.' Witnesses said the pax sat to the rgt of the plt in the cockpit. After takeoff to the east, the plt returned for a low pass down the rwy in…NTSB MIA84FA240Accident · 1 fatalField investigationFinal reportCessna 152 · Pembroke Pines, FLOne min and 20 seconds after being cleared for takeoff, the plt transmitted on tower freq that he was 'coming in for a landing.' The acft was observed to bank to the left, enter a steep descent from 200 to 300 ft AGL & crash. An intense post-crash fire…NTSB LAX84LA457Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Truckee, CAThe plt stated that she rotated the acft at 65 KTS and the acft lifted off at 70 KTS. Shortly after liftoff the acft veered to the left and the stall warning horn activated. The plt lowered the pitch attitude, the acft began to settle and the right main…NTSB LAX84LA456Accident · No injuriesLimited investigationFinal reportCessna 150G · Apple Valley, CAThe student was receiving instruction in soft field landings & rudder control during the landing roll-out. A downwind approach was made to rwy 18 which had a downward gradient of 1.5%. Flaps were used for the approach & the acft touched down about 1/3 of the…NTSB CHI84LA363Accident · No injuriesLimited investigationFinal reportCessna 150 · Brookville, OHThe CFI made a successful forced landing on a highway median strip while on a dual night x-country flt after a pwr loss occurred. CFI drained the fuel sumps and was able to restart the engine. He then decided to takeoff from the median and fly the acft back…NTSB CHI84LA362Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Michigan City, INThe engine quit as a result of fuel exhaustion. Twenty ounces of fuel remained in the tank. The pilot stated he was flying on the aircraft's fuel gage which indicated three eights of a tank remained. An autorotation was initiated, but the landing skid caught…NTSB CHI84FA364Accident · 4 fatalField investigationFinal reportCessna A185F · Lake Delton, WIThe float plane crashed shortly after taking off from Lake Delton while of a sight-seeing flt. The acft was used daily during the tourist season on flts of aprx 15 min long. This was the 8th or 9th flt of the day & was the 4th or 5th flt since refueling. A…NTSB ANC84LA145Accident · No injuriesLimited investigationFinal reportCessna 188 · Fairbanks, AKThe acft landed short of the rwy at a mining strip. The plt said he encountered a downdraft and in spite of the additionof full power the acft descended to the ground. The acft was loaded with 150 gallons of diesel fuel in the hopper and the plt attempted to…NTSB SEA84LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Shoshone, IDThe plt attempted takeoff from a wet alfalfa field. High vegetation and soft terrain prevented proper acceleration to lift off speed. The nosewheel struck an embankment and the aircraft nosed over.NTSB NYC84FNC09Accident · 1 fatalFinal reportCessna 172 · Pownal, MEPrior to the accident, witnesses observed the acft making several low passes & maneuvering. During the last maneuver, the acft entered a dive & collided with trees before the plt recovered. Trees were broken or damaged over an area of about 200 ft. no…NTSB NYC84FIA03Accident · Minor injuriesFinal reportBeech 35 · Park Hall, MDThe plt noted that the engine ran rough at low RPM but smoothed out at higher pwr settings. Despite that finding the pltelected to takeoff but aborted as he realized that he would not be able to get airborne before reaching the end of the rwy. After taxiing…NTSB NYC84FFJ04Accident · 1 fatalFinal reportSchweizer SGS 1-36 · Elmira, NYVery shortly after takeoff at 150 to 200 ft the tow rope failed. The glider initiated a steep left turn back to the arpt. During the turn witnesses observed the acft to stall and enter an uncontrolled near vertical descent to ground impact.NTSB MKC84FA262Accident · Serious injuriesField investigationFinal reportShindler-Smiley THE Blue MAX · Lawrence, KSWhile in cruise flt, plt noted rising oil temp and decreasing oil press, and elected to make a precuationary landing in open alfalfa field. During landing flare, acft stalled, right wing dropped then left wing dropped to ground contact. Engine exam disclosed…NTSB MIA84LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gainesville, FLThe nose gear tire blew out on landing. Directional control was lost and the acft traveled off the left side of the rwy.NTSB MIA84IA242Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Orlando, FLJust prior to V1 and rotation both left main landing gear tires failed. Takeoff was aborted and acft was stopped on rwy. Pax & crew deplaned without injury. Cause of tire failure could not be determined.NTSB MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…NTSB LAX84LA455Accident · No injuriesLimited investigationFinal reportHughes 269B · Goleta, CAThe student plt was practicing during solo flt and collided with the ground during an aerial taxi. The student explainedthat after a normal landing he pulled enough collective to make the acft light on the skids and proceeded to taxi along the ground by…NTSB LAX84FU032Accident · 1 fatalFinal reportUltralight UFM East Riser · Cloverdale, CAThe Ultralight was observed by witnesses on the downwind leg of the traffic pattern for landing. The acft was flying level at about 300 ft AGL when it started a series of roller-coaster maneuvers which increased into a steep ascent and nose over followed by a…NTSB FTW84LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKPlt lost control after a hard, right-wind-down landing. Acft porpoised, collapsing the nose gear and came to rest nose down.NTSB FTW84LA368Accident · Serious injuriesLimited investigationFinal reportRaven Rally RX7 · The Colony, TXThe plt reported that after takeoff, the wind picked up to about 12 to 15 KTS. She stated she made a normal high wind landing, but due to the angle of landing & position of the passenger's foot, her ankle broke during touchdown.NTSB DEN84MA266Accident · 4 fatalMajor investigationFinal reportAero Commander 690 · Little America, WYAbout 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…NTSB DEN84LA267Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Aurora, COPlt stated that following a hard landing, directional control was lost. Acft departed runway and collided with dirt berm.NTSB CHI84LA375Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INPlt stated the acft was 1/2 way down the rwy and had not touched down so back pressure on the yoke was released. The acft then bounced three times on the rwy. On the third bounce the nose gear collapsed and the acft nosed over. Plt stated airspeed was…NTSB CHI84LA368Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Naperville, ILPlt stated eng had been 'running rough' since 100 hr inspection. Eng had 130 hrs total time. On run-up, eng was misfiring until plt leaned mixture and allowed full warm up. Eng then performed normally. Takeoff and climb to cruise uneventful. After about 45…NTSB CHI84LA360Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Independence, WIThe acft collided with trees near the departure end of the field during an attempted go-around. A passenger reported that the go-around was initiated at about 100 ft AGL, 1/2 way down the fld. The plt said the fld was in a valley, it wasa hot (reported temp…NTSB ATL84LA300Accident · No injuriesLimited investigationFinal reportLet L-13 · Warrenton, VAThe plt inadvertantly deployed the flaps on final apch instead of the spoilers. The glider overshot the airstrip touching down in rough terrain off the departure end.NTSB ATL84LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Fair Hope, ALThe plt excessively flared the acft on landing at which time the acft ballooned. Recovery from the balloon was made but upon touchdown, the acft was not aligned with the rwy. The acft traveled off the left side of the rwy and contacted several small trees.NTSB ATL84LA270Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Reidsville, SCThe accident occurred on a low approach to a sloping airstrip with power lines at the uphill end. A go-around was commenced from a low pass, but insufficient climb performance was available, and a pull-up to clear the obstruction resulted in a stall/mush into…NTSB ATL84LA269Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Virginia Beach, VAOn landing roll plt diverted aircraft to right to avoid a truck which had pulled onto the runway. This placed the aircraft in line with banner towing equipment. The plt applied the brakes while the tail wheel was still off the ground in attempts to stop prior…NTSB NYC84FHJ02Accident · No injuriesFinal reportCessna 305A · East Moriches, NYAt the completion of a banner tow flt the banner was released and a climbing right turn to downwind was initiated. A loss of power was experienced on downwind. Unable to return to the arpt to land, a forced landing was made in a wooded area. Investigators…NTSB NYC84FA294Accident · 2 fatalField investigationFinal reportCessna 414 · Wallingford, VTThe plt was executing second attempt for a instrument apch, lda rwy 19, following a missed apch on the first attempt. The plt last reported over the iaf, 9 mis north of the arpt. The acft collided with a mountain at a elevation of 1700 ftand 5 mis south of…