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 LAX84FVM02Accident · Minor injuriesFinal reportGrumman American AA-5B · Monterey, CAThe acft collided with hilly terrain aprx 6 miles east of the arpt during the second attempted ILS rwy 10 apch. The plt stated that communication and navigation problems were experienced during the flt. He also stated he changed fuel tanks every 1/2 hr during…NTSB ATL84FA250Accident · 1 fatalField investigationFinal reportCessna 150F · Banner Elk, NCAcft observed to depart short strip in hi dens alt conditions, 'wobbled into the air.' Acft did not circle for altitude, but headed straight ahead toward rising terrain 'wings rocking' at slow speed before right wing dropped and acft collided with terrain. No…NTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…NTSB NYC84LA265Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Plymouth, MAThe plt stated that when he released his glider at 2500 feet, soaring conditions were good. Conditions deteriorated which resulted in no lift and altitude was insufficient to safely return to the departure airport. The pilot attempted to land off the airport…NTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…NTSB SEA84LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Morton, WADuring takeoff at alt of 3 to 5 ft AGL the decision was made to abort the takeoff. Plt stated when throttle was retarded lift improved so full pwr was applied. At 15 ft AGL plt realized trees at end of rwy could not be cleared so plt attempted another aborted…NTSB ANC84LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore Creek, AKThe plt stated that during takeoff ground run the wind shifted to a right tailwind & lift off was initiated to clear the trees. He attempted to land on the runway, however the nose wheel struck the grass & the acft flipped over upside down.NTSB LAX84FA422Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Honeydew, CAFlt 101, a domestic cargo operation crashed at about 2400 MSL in a steep forested mountain valley. The acft & its cargo,consisting of bank documents & photographs, were destroyed. The plt sustained fatal injuries & no suitable specimens were available for…NTSB CHI84FEI01Accident · 1 fatalFinal reportBell-Olympic Helicopters 47G2 · Toledo, OHThe helicopter was being used to photograph an office building. The photographer stated that after each flt of about 10 min, the plt flew the helicopter to the left & center of the landing pad, a few feet above the ground, then moved the acft sideways to the…NTSB ANC84LA125Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · North Pole, AKDuring an approach for landing the acft collided with the ground and rolled over. The plt stated that he flared too low to the ground and struck 1 skid first, lost directional control and rolled over.NTSB FTW84LA330Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · San Marcos, TXWhile the plt was on a x-country flt, the acft crashed & came to rest on the shoreline of a large pond. Initial impact was believed to have occurred with the water. No preimpact part failure or malfunction was found during the investigation. There was…NTSB ANC84FA124Accident · No injuriesField investigationFinal reportCessna 140 · Talkeetna, AKPlt was conducting a search and rescue mission when his attention was diverted to an object on the ground. When plt redirected his attention to the flt path, rapidly rising terrain was viewed directly in front of the acft with insufficient room to turn. The…NTSB LAX84FA447Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Garberville, CAThe acft collided with trees & ground during climb after takeoff on a dark night in mountainous terrain. The wx is not considered to be a factor since the wx was VMC at the time & place of the accident. It was a moonless night and the areaof the crash…NTSB SEA84LA186Accident · No injuriesLimited investigationFinal reportCessna A188B · Pasco, WAThe acft was loaded with 1500 lbs of dry chemical (fertilizer). The air temp at the time of the accident was 95 deg f, resulting in a high density alt. Rising terrain existed at the point where the plt attempted a turnaround. In an attempt to turn away from…NTSB MIA84LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Espanola, FLThe acft without flt plan and no flt history was found abandoned in a field with 14 bales of marijuana located in and around the wreckage. No owner or plt has been located. Customs agents tracking the acft lost contact in a thunderstorm between daytona and…NTSB ANC84LA122Accident · No injuriesLimited investigationFinal reportBell 206B · Healy, AKThe plt was attempting to land the helicopter on terrain which had a slight slope. Before the aircraft was completely on the ground the plt decided to move the acft & the right skid caught in the tundra causing the acft to roll over to the right.NTSB SEA84FA185Accident · 2 fatalField investigationFinal reportde Havilland Beaver DHC-2 · Ketchikan, AKThe plt flew into a canyon with a climb-out gradient in excess of the acft capability and collided with the upsloping terrain. The plt said he had hit a downdraft and turned away from the rising terrain just as collision occurred. Surviving passengers do not…NTSB FTW84LA324Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Abernathy, TXThe acft collided with the bank of a drainage ditch in a field during a spray operation at which time the left main gearwas knocked off the acft. A precautionary landing was made during which the acft ground looped and the right main gear collapsed.NTSB MKC84FCA01Accident · Serious injuriesFinal reportGrumman-Schweizer G-164A · Neelyville, MOThe plt stated that after takeoff & two miles from the destination airport, the plt started a 180 deg turn to the rt to return to the takeoff strip. Approx halfway through the turn at 45 deg of bank, the rt wing pitched downward & he was unable to correct by…NTSB FTW84LA315Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · El Paso, TXThe helicopter crashed into a field during an aerial application flight. There were no eyewitnesses to the crash. The pilot was pulled from the wreckage by a farm worker who heard the crash. The pilot would not state to investigators what occurred.NTSB ATL84LA228Accident · No injuriesLimited investigationFinal reportCessna 175 · Enterprise, ALA witness observed the airplane slipping on final apch. The aircraft lost too much altitude and hit the terrain short of the runway. The airplane damage indicated that the pilot failed to correct the slip condition in time to arrest the descent.NTSB ATL84LA226Accident · No injuriesLimited investigationFinal reportBell 204 UH 1B · Tams, WVAn over gross takeoff was attempted from a 500 ft long zone. Translational lift was not achieved and rotor RPM deteriorated. The helicopter collided with trees, crashed & burned. The plt stated that the wind may have shifted during his takeoff.NTSB ATL84LA224Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · No.Myrtle Beach, SCWhen the plt extended the gear, the landing gear motor circuit breaker (c/b) popped. He reset the c/b & after a cool down period attempted to extend the gear again, but with the same results. The plt was not able to extend the gear fully down & locked with…NTSB ATL84LA223Accident · No injuriesLimited investigationFinal reportBeech 58 E · Sumter, SCAfter a long work day the pilot forgot to extend his landing gear at his destination airport and landed gear up. The pilot reported he has not slept well on the night before the accident and that his attention was diverted by another acft landing ahead of him.NTSB DCA84IA030Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Marietta, GAEastern airlines flt 92, a Boeing 727, N8840E, and an air force-KC-135, reg #60-0330, call sign fowl 24, were involved in a near collision while both acft were maintaining FL350. The captain of flt 92 reported that during the occurrence, the KC-135 passed…NTSB DEN84FA222Accident · 2 fatalField investigationFinal reportNorth American P-51D · Carbondale, COThe plt was performing aerobatic maneuvers in a P-51D that had been modified for racing & exhibition. Witnesses near the accident site stated that the acft had just completed several aerobatic maneuvers before it began a vertical climb. The climb was…NTSB MKC84LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brule, NEAccording to the pilot, during the swath run the left wing dropped and the acft flew into the corn field. Density altitude was aprx 5,200 ft.NTSB DEN84LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Dickinson, NDThe pilot stated that he received landing information for the Dickinson muni airport. He continued to state, 'set plane up for landing, checked plane over everything was set up, started to land, prop hit rwy, the next thing I was sliding down rwy.' The…NTSB DEN84LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Empire, COPlt stated, 'departed arapahoe, planning on selecting best mountain pass versus altitude achieved. At 10,500, decided pass I was entering would be too difficult & began maneuvering for 180 turn. Severe downdraft occurred & altitude & airspeed lost precluded a…NTSB NYC84FA234Accident · 2 fatalField investigationFinal reportBeech 95 · Shelter Island, NYAcft level abt 3000 ft. engines sputtered. Acft descended in uncontrolled attitude. Tach 6.9 hrs since last fueling. Acft did not have shoulder harness or metal to metal seat belt buckle for pilot and copilot seats. Pilot biennial and medical not currentNTSB NYC84FA233Accident · 1 fatalField investigationFinal reportGrumman AA-5 · Woodstock, NYAcft was on a VFR personal flight. Witness on mountain slope heard sounds of approaching acft, observed brief glimpse of acft wheel and wing through cloud and fog about 100 ft away, at tree-top level. A few seconds later. Witness heard eng sound cease.…NTSB MKC84LA200Accident · Minor injuriesLimited investigationFinal reportGrumman G164A · Bernie, MODescending out of the procedure turn into a swath run the plt was unable to level the acft in time to avoid flying into the bean field. The acft nosed over on impact and caught fire. Density altitude was about 2,800 ft. acft gross weight was aprx 5,500…NTSB CHI84LA274Accident · No injuriesLimited investigationFinal reportHughes 269B · Eden Prairie, MNThe CFI stated that while practicing a pedal turn the student pilot suddenly applied back cylic causing the tail rotor to contact the ground. The main rotor then contacted the ground and the helicopter rolled over.NTSB SEA84LA151Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Shelley, IDThe acft collided with the ground during an ag flt. The plt reported the winds were 3 to 5 KTS with no gusts when the accident occurred but that the winds are unpredictable at the base of the mountains and a gust of wind caught the acft. The plt also stated…NTSB NYC84FA227Accident · 1 fatalField investigationFinal reportCessna 402C · Boston, MADuring arrival, the flt was cleared for an ils/dme apch to rwy 27. While on the apch, the acft crashed in the ocean about 2.7 mi east of the rwy threshold. The plt reported that he was making the apch, using instruments, & landed short for unknown reasons. He…NTSB MIA84FA197Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Marathon, FLThe plt reported that he was flying low & in level flt over the ocean when the acft hit the wake from a large boat & flipped over. According to witnesses, the acft began a right turn while flying low, then the right wing hit the water & the acft cartwheeled &…NTSB ANC84LA108Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Knik Glacier, AKThe acft was climbing as the plt 'flew up' a Glacier. He stated that before the accident, he had made a check of the instruments & outside references & had determined that his rate of climb was adequate to easily clear the ridge. He stated, 'the next thing I…NTSB FTW84FA291Accident · 2 fatalField investigationFinal reportCessna 152 · Minco, OKThe student plt had rented the acft. Records showed that he had flown this acft on previous occasions. The plt acting as instructor did not possess a current instructor certificate. There were no witnesses to the crash, but the acft was observed maneuvering…NTSB DEN84LA279Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stanley, NDThe plt reported that he was spraying a field with 2 power lines at the north edge. He had been making passes under the wires, but where 2 poles were too close together, he decided to fly over the wires. After making a procedure turn back toward the field, he…NTSB DEN84FA196Accident · 3 fatalField investigationFinal reportCessna 172RG · Red Feather Lak, COAcft departed downwind into rising terrain with density altitude calculated to be 10,935 ft. acft was observed to mush into rising terrain 300 ft higher than and 3 mi west of the rwy.NTSB DEN84FA194Accident · Minor injuriesField investigationFinal reportPiper PA-28-140 · Cedar City, UTThe acft collided with rising terrain in a box canyon. The plt said he found himself trapped with the terrain coming up 'to meet the plane' and decided to try and land on a nearby road. The acft stalled into trees prior to reaching the road. The plt also said…NTSB CHI84LA259Accident · No injuriesLimited investigationFinal reportBeech S35 · Ottawa, ILThe plt said he 'left word' for the Ottawa arpt lights to be left on until 0200 hrs on 6/24. When the flt arrived at Ottawa, the lights were not on. The plt said he 'attempted to make an approach, it failed.' The acft was landed in a nearby field. The arpt…NTSB SEA84LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fall City, WAThe plt was approaching a strange arpt with a rwy elevation of 140 ft and surrounding terrain of 1000 to 3000 ft. the plt said as he approached the threshold he felt the acft was too high so he executed a go-around. With the flaps at 20 degrees he said his…NTSB MKC84LA177Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7GC · Columbia, MOThe student plt was practicing emergency procedures during a solo flt. During a simulated forced landing apch to a field of tall fescue grass, he descended too low & the wheels encountered the grass which was 3 to 4 ft tall. The grass slowed the acft, it…NTSB MIA84FA188Accident · 1 fatalField investigationFinal reportCessna C-188 · Elkton, FLThe aircraft departed the farm grass strip for a spray mission estimated to take about 20 minutes. When the aircraft failed to return the pilots business partner started looking for the aircraft and pilot. The aircraft was found about one and one half mile…NTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.NTSB SEA84FA135Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Hammond, ORThe acft was seen first to make a turn to the north followed by a turn to the south. It then went into a nose down attitude and descended until it disappeared from view. The acft collided with the terrain. An investigation revealed no apparent malfunction…NTSB CHI84FA239Accident · 2 fatalField investigationFinal reportMooney M20C · Middlefield, OHThe acft props touched the rwy during a wheels-up approach and the plt initiated a go-around with bent props. The acft climbed to about 100 ft AGL with less than full power. The wings began to rock,the left wing dropped and the acft fell straight down to the…NTSB MKC84LA165Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Harrisburg, ARThe acft's landing gear collided with a levee during a swath run. The acft then slowed & hit other levees. The plt dumped his load, but the plane crash landed & nosed over.NTSB DEN84LA176Accident · No injuriesLimited investigationFinal reportCessna 150M · Afton, WYThe plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt…