NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 LAX84LA412Accident · No injuriesLimited investigationFinal reportMolino PIK 20E · Fremont, CAThe plt stated that during takeoff, the motorized glider had just lifted off when the right wing dropped & hit tall weeds next to the 20 ft wide paved rwy. The weeds were about 2 1/2 ft tall. Subsequently, the glider 'ground looped' to the right & the…NTSB LAX84LA333Accident · No injuriesLimited investigationFinal reportJakel Barracuda · Lakeport, CAThe plt was unable to extend the gear using normal procedures. He subsequently used the emergency release hydraulic system to free fall the gear into the down position. Three 'clunks' were heard & three sreen lights indicated the gear were down & locked.…NTSB LAX84LA336Accident · No injuriesLimited investigationFinal reportStarduster II · Half Moon Bay, CAThe plt said he encountered wind shear at 700 ft AGL, lost control & landed in a field. The plt subsequently walked to a friend's house next to the field to report the occurrence.NTSB LAX84FA328Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Baker, CAThe acft was found where it had crashed & burned on a rough lava bed. The crash site was about 1 mi northeast of a road where drug smuggling acft had been known to land in the past. There was evidence that cocaine had been removed from the accident site. The…NTSB DEN84FA166Accident · 1 fatalField investigationFinal reportBeech BB-55 · Duchesne, UTAcft collided with a mountain at an elevation of 12,000 ft MSL. Wx at roosevelt, UT, 42 NM se of the accident site at 2030 MDT was estimated 7,000 ft bkn, 25,000 ft bkn, 40 miles visibility, 70 deg f, with cumulus nimbus clouds NE and se. Radar summary charts…NTSB MKC84LA154Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWhile the plt was spraying rice, the left main gear of the acft struck a levee of a rice field & separated. The plt then proceeded to a nearby field for a landing. After a slight landing roll on soft terrain, the acft nosed over.NTSB FTW84LA255Accident · No injuriesLimited investigationFinal reportAmerican Aerolights Eagle 2 · Goldsby, OKThe plt of the 2 place ultralight, N951AA, & the plt of another ultralight were en route from tuttle to goldspy, OK. While flying low over a wheat filfed, the plt of the other ultralight inadvertently flew into the crop. The plt of N951AA witnessed the…NTSB MKC84LA153Accident · Minor injuriesLimited investigationFinal reportHiller 12E · Bedford, IAThe plt had made two swath runs & was descending to begin the third. He stated that the turn was downwind & as he approached the level-off altitude he encountered a downdraft. The acft impacted the ground & rolled over. The plt also stated that the downdraft…NTSB ATL84LA186Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · New Bern, NCThe plt was performing a low level fly-by simulating an inexperienced flyers erratic maneuvers when the acft fell vertically to the ground and bounced into a fence before it came to rest in a field. The plt said he hit a down draft at a tree line. The fly-by…NTSB SEA84LA117Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Ketchikan, AKThe plt was making a low turn at slow airspeed to land on a gravel road. His left gear dug into the gravel and broke offand the acft ground looped.NTSB MKC84LA144Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Louisville, NEAccording to the plt, the helicopter was involved in a ground search with a non-trained pax in the right seat. With the pax flying the acft in a hover the right skid contacted the muddy terrain causing the acft to roll over.NTSB MKC84LA143Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Silver Creek, NEThe plt stated he was making an end pass while spraying a pasture & collided with a hilltop on the opposite side of a draw. This occurred while the sun was obstructing his vision.NTSB ANC84FA074Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKAccording to witnesses, the plt made 3 low passes at some boats in Sleetmute slough. They estimated the passes were at 5 to 10 ft above the water, then the plt would pull up in a steep climb attitude, execute a 180 deg turn and make another pass. After the…NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…NTSB SEA84FA110Accident · 1 fatalField investigationFinal reportRockwell S-2R · American Falls, IDThe load/ground crew reported that the plt planned to make 1 more spray run before flying back to the home base. When the acft did not return to the loading area, they assumed he had returned to the base. They drove 20 mi back to the base, but found neither…NTSB LAX84LA309Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lakeside, AZThe plt was unable to clear rising terrain after a low pass for a photo. The density alt was about 8700 ft.NTSB DEN84LA151Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Grand Junction, COThe plt-in-command (PIC) was checking out another plt on a pipeline route. The copilot was occupying the left seat & was flying the acft. While surveying the pipeline, they proceeded north up a canyon toward Douglas pass. No turbulence & little effect from…NTSB CHI84LA188Accident · No injuriesLimited investigationFinal reportAyres S2R · Vincennes, INThe plt had flown 12 similar loads from the 2600 ft rwy that same day. He stated that although there was nothing mechanically wrong with the acft, it would not accelerate properly during the last takeoff roll. After aprx 2000 ft of ground roll, he dumped a…NTSB FTW84LA225Accident · No injuriesLimited investigationFinal reportGrumman G164A · Fenton, LAThe acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…NTSB FTW84FA220Accident · 1 fatalField investigationFinal reportPitts Special S-1 · La Marque, TXThe plt was scheduled to perform aerobatics in an air show. While maneuvering at about 300 ft AGL, the acft entered a nose high, steep left turn, stalled, then entered a 2 turn spin to the left. The plt recovered in a nose low, wings level attitude, but the…NTSB LAX84FA277Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Ukiah, CADuring arrival, the plt was cleared for a loc/dme rwy 15 apch to the Ukiah arpt. At 1307 PDT, he began the apch at the tucci intersection, 15.5 mi north of the rwy. At 1311:04 the last radar contact showed that the acft was about 5 mi north of the arpt. At…NTSB LAX84LA273Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Salinas, CAWhile spraying a field of artichokes, the plt had made 1 pass southbound & started another northbound. He began the swath run by descending over power lines, then tried to climb & clear rising terrain beyond the lines. However, the helicopter continued…NTSB SEA84LA097Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hermiston, ORDuring a beginning swath run, the plt was making a left skidding turn to follow the edge of a circular field. He stated that the acft encountered a downdraft which raised the right wing. Subsequently, the left wing contacted the ground & the acft crashed.NTSB MIA84LA152Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valdosta, GAThe instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not…NTSB FTW84LA210Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Rocksprings, TXThe plt stated that the cabin door opened in-flight. While making a landing at Rocksprings in order to shut the door, the plt failed to use the checklist and landed the acft with the gear up. The acft was equipped with an auto gear extender, but because of…NTSB SEA84LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Heppner, ORThe plt reported that he was making a turn below the lee side of a ridge line at an alt of about 30 ft AGL. The acft reportedly encountered a downdraft & settled into the ground. During this occurrence, the landing gear collapsed, but no other major damage…NTSB ATL84FA147Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Athens, GABefore starting an apch, the plt was advised the wx was: 300 ft obscured, visibility 3/4 mi with light rain & fog. The minimums for a straight-in VOR apch to rwy 2 were 400 ft mda & 1 mi visibility; for a circling apch, the minimums were 433 ft & 1 mi. The…NTSB FTW84LA202Accident · No injuriesLimited investigationFinal reportCessna 500 · Oklahoma City, OKDuring a proficiency flt check, the aircrew was making a N0-flap landing. After completing the landing checklist down to the landing gear, power was reduced causing the landing gear audible warning to sound. The horn silence switch was depressed & the apch…NTSB NYC84FA138Accident · Serious injuriesField investigationFinal reportBeech 35-C33 · Toms River, NJPlt stated that when using his bifocal corrective lenses, he had to tilt his head back to include the altimeter in his instrument scan. In the final phase of the approach, he failed to note the altimeter and collided with the terrain.NTSB MIA84LA137Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5A · Clearwater, FLShortly after takeoff, the acft crashed into the ocean. VMC existed at the arpt but dense low ocean fog was reported at the crash site. Some acft debris was recovered.NTSB LAX84LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Scaggs Island, CADuring a local flt, the acft crashed on the side of a levee while maneuvering. Both plts were seriously injured & neither of them could recall details of the flt. An exam of the crash site revealed the plane was traveling nearly parallel with the levee when…NTSB DEN84LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Monticello, UTThe pilot departed uphill with a tailwind at near gross weight with a high density altitude. The flight was late gettingstarted & an excessive magneto drop was attributed to a fouled plug. The pilot also stated that he was under mental stress. The acft lifted…NTSB LAX84LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Mathews, CAThe acft was making a go-around from about 100 AGL and collided with rising terrain. According to the plt the engine failed to respond properly. According to the passenger the engine response was normal. The investigation revealed that the acft was overweight…NTSB NYC84FA135Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, PAThe acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light…NTSB MKC84FA116Accident · 2 fatalField investigationFinal reportCessna 310I · Fayetteville, ARWhen the plt received a wx briefing at 1012 CST, he was advised that the wx at his destination (Fayetteville, AR) was an estimated 600' overcast, vis 4 mi with light drizzle & fog, but the wx was forcast to begin to improve in about 1 hr. He took off & during…NTSB DEN84FA121Accident · Serious injuriesField investigationFinal reportAero Commander 500-B · Miles City, MTThe plt said that when he called on the radio prior to the approach for an altimeter setting the reply was '30.11 or 30.12, something like that.' The acft altimeter was found after the accident set at 30.22 inches of mercury. The visibility was described as 1…NTSB DEN84LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Alpine, WYThe plt stated on takeoff at an alt of 10 ft AGL a loss of power occurred. During the forced landing the left skid contacted either the pad or an object on the pad and the acft rolled over to the left. The plt stated that white out condition occurred during…NTSB NYC84FA118Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · E. Hanover, NJThe acft was observed as it made a low pass over the end of the rwy, then pull up in a roll and/or vertical maneuver. One witness said that on the downward side of the maneuver, the acft appeared to stall or shudder. Before recovering, the acft impacted in a…NTSB MKC84LA111Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Oelwein, IAThe acft landed gear up. The pilot said he was distracted by the call of another acft on unicum & began looking for thatacft in or near the traffic pattern.NTSB CHI84LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake.NTSB MIA84FA116Accident · 2 fatalField investigationFinal reportAlleva Starduster SA300 · Lakeland, FLThe owner/builder of the acft & his wife were flying at aprx 800 ft AGL when the plane rolled to a near inverted attitude & entered a dive. Before entering the maneuver, the plt was observed waving to friends & acquaintances who resided in the area. Before…NTSB NYC84LA112Accident · No injuriesLimited investigationFinal reportBeech 76 · Pittsburgh, PADuring the takeoff portion of a touch-&-go, the student plt forgot to raise the flaps. The instructor (CFI) yelled at the student '...the flaps', & at the same time, reached for the flaps with his right hand under the control wheel. Subsequently, the left…NTSB DEN84LA109Accident · No injuriesLimited investigationFinal reportMooney M20E · Las Vegas, NMWhile enroute, the plt elected to land at Las Vegas, NM & check on his destination wx. He called the fss when the acft was about 30 mi south of Las Vegas & was advised that the wind at Las Vegas was from 230 deg at 20 KTS. He said he experienced severe…NTSB ATL84LA120Accident · No injuriesLimited investigationFinal reportBeech 99 · Myrtle Beach, SCThe acft was landed with the landing gear up. The plt said that the sun was shining on the instrument panel and he thought he saw 3 green lights. After the acft stopped on the rwy the red light in the gear handle was on and the warninghorn was sounding. He…NTSB MIA84LA108Accident · No injuriesLimited investigationFinal reportCessna 310N · Tampa, FLThe plt reported that after arrival, he was cleared to land & made a landing check, but 'apparently made gear-up landing.' During an investigation, the gear operated normally. A witness stated that he saw the acft with the gear retracted.NTSB FTW84LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kingsville, TXWhile flying over a water basin the plt and pax both stated they felt an updraft. They said that they next remember climbing out of the acft which was inverted and under water.NTSB LAX84LA216Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Marana, AZThe plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted…NTSB NYC84FA189Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · South Paris, MEBefore the accident, the plt was last seen on 3/9/84 at 1530 EST & had not expressed any intentions of flying. At 1730, his car was located at the arpt & his acft, which had been kept there, was gone. The acft was found on 5/24/84 where it had crashed on…NTSB DEN84FA108Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Saratoga, WYDuring a night x-country after a 16 hour day the airline captain flying his own acft home collided with a mountain at the 10000 ft level. The weather was VMC but the winds aloft were strong and would have blown the acft towardthe mountain had no wind…NTSB ANC84LA041Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Mcgrath, AKThe pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground.