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 MKC84LA023Accident · No injuriesLimited investigationFinal reportBeech A-36 · Satanta, KSThe pilot said he was approaching to land and was low on approach. As the aircraft crossed the end of the runway, the left main gear touched down, striking what was described as a curb about 1 foot from the edge of the runway, substantially damaging the left…NTSB ANC84FA017Accident · Serious injuriesField investigationFinal reportBell 212 · Nuiqsut, AKThe search & rescue flt had been dispatched from barrow to an acft accident site adjacent to the Nuiqsut arpt. Accordingto the plt, upon arriving at Nuiqsut at 300 ft AGL the visibility was 2-3 mi. They lined up with snow machines for a visual apch to the…NTSB ANC84FA016Accident · 1 fatalField investigationFinal reportMaule M-4-210C · Nuiqsut, AKThe acft crashed during the approach to land at a fogged in arpt at night. Sometime between 2045 and 2100 yst an acft was heard overflying the arpt at Nuiqsut. The villager who heard the acft stated the noise decreased as though the acft was landing. He then…NTSB LAX84LA059Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Casa Grande, AZDuring a local flt, the acft collide with terrain while the aircrew were performing low alt maneuvers. One of the occupants was an instructor plt (CFI) & the other was a private plt. Neither claimed to be the plt in command, but the private plt was the…NTSB FTW84FA045Accident · 2 fatalField investigationFinal reportCessna 310L · Bartlesville, OKThe acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly…NTSB ATL84FIG01Accident · 1 fatalFinal reportLake LA-4-200 · St. Michaels, MDDuring the afternoon, the plt flew to the miles river in Maryland where he made a water landing to pick up a passenger. When he landed, the water surface had ripples which had been produced by a light breeze. At that time, the plt had no trouble seeing the…NTSB LAX84LA051Accident · No injuriesLimited investigationFinal reportCessna 188 · Needles, CAThe plt reported that he took off aprx 10 to 15 min after sunset on an aerial application flt. During a turn to begin a swath run, he noticed an unexpected change in drift. As he was descending below the level of nearby power lines, there was a loss of…NTSB CHI84LA043Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gatzke, MNThe acft collided with the ground when the pilot attempted a low level turn.NTSB FTW84LA042Accident · 1 fatalLimited investigationFinal reportCessna A185F · Freemason Is., LAThe acft was on the return leg of a fishing trip at night. According to the plt, the float plane lifted off after a fairly long run on smooth water. He stated that at 200 ft AGL & 90 KTS, he initiated a 10 to 15 deg right turn & rolled out on a heading of 350…NTSB CHI84FU001Accident · 1 fatalFinal reportQuicksilver MX · Elwin, ILThe plt possessed a student plt & 3rd class medical certificate. After takeoff, he circled over the airfield, then climbed to about 200 ft AGL. A high school classmate stated that the ultralight then entered a nose high attitude & appeared to enter a practice…NTSB LAX84FA047Accident · 2 fatalField investigationFinal reportCessna 172N · Elko, NVThe acft crashed in mountainous terrain while on a deer spotting flt. There were no witnesses to the accident. About 8 hours after departure the acft was declared missing. The acft was found the following day at about 0730 hours by air search acft. Ground…NTSB CHI84FA035Accident · 1 fatalField investigationFinal reportCessna 150F · Portland, INThe plt had just purchased the acft & flew a previous co-owner to montpelier, IN, where he landed at about dusk. The previous co-owner deplaned. He said that after the acft took off, he saw it turn to the west & depart toward marion. A short time later, the…NTSB NYC84LA019Accident · No injuriesLimited investigationFinal reportWichawk 1 · Northampton, MAAccording to the pilot the approach was too low and too slow and the aircraft landed short of the runway.NTSB FTW84FA035Accident · 2 fatalField investigationFinal reportCessna 310 · Fairview, OKThe acft was observed to take off at about 1830. Witnesses near the crash site reported seeing & hearing a low flying acft at about 2000 & stated the engs were running smoothly. There was fog in the low areas with visibility of less than 1/4 mi in those…NTSB FTW84LA037Accident · No injuriesLimited investigationFinal reportGlobe GC-1A · Houston, TXThe plt was on a local flt from the weiser airpark arpt to the lakeside arpt. There was construction at the destination & the plt was unsure which rwy was in use. He made a go-around from his 1st apch. After UNICOM had clarified where the landing area was at,…NTSB ATL84FKJ02Accident · 1 fatalFinal reportCessna A188B · Hazel Green, ALThe acft collided with the ground while the plt was flying near his rural home. No preimpact, mechanical malfunction or failure was found. According to the medical examiner, the plt had severe & extensive coronary arterioscleroses; however, the relationship…NTSB SEA84FA011Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Brewster, WAThe plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…NTSB LAX84LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · San Diego, CAAfter departing north island nas (naval air station), the plt attempted to change frequencies, but the megahertz (mhz) tuning knob came off at a setting of 122.1 mhz. He could still use the knob for tuning tenths of a mhz, so he contacted San Diego fss on…NTSB LAX84LA021Accident · No injuriesLimited investigationFinal reportCessna 210B · Bakersfield, CAThe plt was unable to lower all three gear using normal & emergency proceduces. The acft landed with only the nose & left main gear extended. The right main landing gear actuator assembly was found cracked & ruputred, resulting in a lossof hydraulic pressure.NTSB DEN84FA008Accident · No injuriesField investigationFinal reportConvair 340/440 · Pierre, SDAfter landing at Pierre, SD, 2070 lbs of cargo was off-loaded from the aft section of the aft & a new wt & balance was calculated. The aircrew then prepared to takeoff in conditions of low ceiling & fog. The plt-in-command (PIC) initiated the takeoff roll,…NTSB FTW84LA026Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355E · Corpus Christi, TXThe plt was conducting anti-torque failure training during a run-on landing at 30-35 mph. When forward cyclic was applied to correct the nose up attitude, the rear skid touched down causing the nose to go low. Aft cyclic was applied, allowing the tail boom to…NTSB FTW84LA017Accident · No injuriesLimited investigationFinal reportCessna 310B · Santa Fe, NMWhile practicing landings, the left eng power was reduced to simulate an eng failure while the acft was on downwind. The student retracted the gear & continued the apch, but forgot to reextend the gear. The instructor also forgot & the acft was landed with…NTSB ATL84LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Middlesboro, KYDuring arrival, the acft was landed with the landing gear retracted. An exam of the acft revealed no evidence of a preimpact malfunction or failure of the landing gear system.NTSB MIA84FA006Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Cornwell, FLThe acft was found with a large amount of burned marijuna onboard & the cargo door open.NTSB ANC84LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Kodiak, AKAccording to the plt, the wind was gusting to 30 KTS or more and changing directions on the lake very rapidly. He further stated that 'you could see swirls of water on the lake's surface.' He departed the lake towards the east and when about 350 AGL…NTSB SEA84FA007Accident · 1 fatalField investigationFinal reportCessna 182Q · Near Challis, IDThe acft collided with trees at an elevation of 8560 ft MSL. The crash site was on the east side of a ridge & aprx 30 to 40 ft below the ridgeline. The ridge ran northeast-southwest & formed the west side of dry canyon. The plt stated that the eng lost power…NTSB CHI84LA018Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Dorr, MIDuring landing the basket hit a hill resulting in the basket stopping suddenly & ejecting the plt & passengers from the basket. The plt thought a passenger was still in the basket so she grabbed the valve line & hung on as the Balloon rose approximately 100…NTSB CHI84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Aurora, ILApproaching the destination arpt the plt was advised by Aurora local control that the only available landing area was anunlighted taxiway, designated temporary rwy 9/27, used as a day VFR rwy. Use of the temporary rwy after sunset was not authorized, & the…NTSB LAX84LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Virginia City, NVThe acft collided with rising terrain while on a photographic flt for nat'l geographic of mountainous terrain around Virginia City. A witness said the acft flew too low and slow and hit the up-slope terrain with the left landing gear while circling. The acft…NTSB DEN84LA003Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Bridger, WYThe acft was enroute from a powder magazine to a staging area about 2 mi away during a seismic exploration operation. The plt stated that while 100-200 ft AGL he initiated a right turn of 60 deg of bank towards a bowl formed by low lying hills to observe a…NTSB FTW83LA446Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Napoleonville, LAThe acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…NTSB SEA83LA207Accident · No injuriesLimited investigationFinal reportHughes 500C · Pelican, AKThe acft collided with glassy water during an approach to land in marginal weather on a dark night. The acft was damagedand sank but the occupants escaped with no injuries. The acft sank in water that is over 60 ft deep. The pilot stated that he should not…NTSB MIA83IA239Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Orlando, FLAcft made an intentional gear up landing after both normal & emergency procedures failed to lower the gear. It was determined that the hydraulic pump motor had failed. Normal & emergency systems were interdependent. The emergency gear diaphragm was blocked by…NTSB DEN83FTE13Accident · Minor injuriesFinal reportEipper Quicksilver MX 11 · Erie, COThe plt of the 2 place, ultralight vehicle stated that he was demonstrating a power off glide when a severe sink developed. He applied full power; however, he was unable to arrest the descent prior to ground impact. The plt reported that the wind was variable…NTSB ATL83LA379Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Wise, VAThe plt held a commercial certificate, but was a student in helicopter flying. He had over 15,000 hrs total time in airplanes, but only aprx 13 hrs of experience in helicopters. On his 1st solo flt in a helicopter, he was making approaches to a grassy area…NTSB SEA83FA204Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Eastsound, WAThe acft collided with the glassy water during a low alt maneuver. The acft was observed by witnesses to descend from about 100 ft in a flat attitude,touch down,skim along the water then the nose pitched down and the acft nosed over. The occupants were…NTSB ANC83LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKReportedly, the plt was looking at an area in mountainous terrain near an off arpt landing area when he encountered windshear & a downdraft while turning. He stated that the alft dropped 400 ft & he applied full power; however, the left wing struck the ground…NTSB ANC83FA180Accident · 2 fatalField investigationFinal reportCessna 185 · Valdez, AKThe plt had tried to fly to silver lake, earlier that morning, but had to abort the mission due to low ceiling & visibility. When he had returned at 1110 adt, the ceiling had improved, but there was still layers of stratus & fog below the main cloud base.…NTSB LAX83FUG22Accident · No injuriesFinal reportCessna T210F · Mecca, CAThe stolen acft, operated by persons unknown, landed on a road and turned over on its back.NTSB FTW83LA432Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Bay City, TXDuring a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly…NTSB MIA83FA231Accident · 2 fatalField investigationFinal reportPitts S-2A · Green Cove Spr., FLThe acft collided with the ground and was destroyed during a pleasure flt. Examination of the wreckage and the accident site revealed evidence to suggest that the acft collided with the ground while in a steep left bank, nose low attitude and a high rate of…NTSB LAX83LA467Accident · 1 fatalLimited investigationFinal reportde Havilland B-206 · Davenport, CAThe acft collided or ditched in the water while attempting to evade customs officials. Custom officials had been watching this acft and followed it from Mexico. After a touch and go landing at compton the acft left the los angeles area at 200 ft MSL trying to…NTSB LAX83FVG17Accident · 1 fatalFinal reportHiller UH12L · Tulelake, CAThe helicopter was on an agricultural spraying operation. While performing a turn-around, a spray boom struck a raised dirt bank beside a ditch at the edge of the field. Subsequently, the helicopter was pitched down & to the right, then impacted an upright…NTSB ATL83LA369Accident · No injuriesLimited investigationFinal reportBeech D45(T-34) · Louisville, KYAbout 5 mi out, tower approved a straight-in for rwy 1. After the plt extended the landing gear, the tower then suggested rwy 6. The plt retracted the gear & began to set up for rwy 6. However, since another acft was beginning to set up for rwy 19, the plt…NTSB NYC83FA254Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Provincetown, MAThe acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of…NTSB FTW83LA428Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Stake IslandThe plt stated, that while flying over gulf waters he forgot to set his altimeter and thought he was at 200 ft when the acft contacted the water. The float were ripped off and the acft sank in about 10 ft of water. The plt and passenger held onto the float…NTSB ANC83LA169Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Eagle River, AKThe acft collided with rising terrain while maneuvering during a training flt at an alt of 3000 ft MSL. The acft was destroyed and the 2 occupants seriously injured. The CFI stated that there were no mechanical malfunctions which contributed to the accident…NTSB LAX83LA430Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Huron, CAThe plt was spraying lettuce fields on a dark night. According to him, the wind was blowing from the north northwest & gusting to 12 KTS. He reported that during a turn-around over a plowed field, the wind was blowing dust which affected his visibility &…NTSB ANC83LA166Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Port Alsworth, AKThe acft collided with a mud bank and crashed. The weather was VMC and a VFR flt plan was filed. The float acft was damaged in the accident but the seven occupants escaped injury. The pilot stated that shortly after takeoff he struck anembankment lost…NTSB ANC83LA165Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe plt stated that the acft was loaded with 3 hunters & their gear for a flt from caribou pass to the barter island dew station arpt. Reportedly, he had operated in & out of the area on previous occasions with similar loads & conditions. He stated that he…