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 NYC82DA229Accident · No injuriesFinal reportPiper PA-30F · Dubois, PAThe pilot stated that shortly after takeoff the radio master circuit breaker tripped. He repositioned the switch but it tripped again. As the flight returned to the airport the landing gear and flap trim failed to respond. The pilot confirmed a complete loss…NTSB LAX82DA348Accident · No injuriesFinal reportPiper PA-28R-200 · Prescott, AZAccording to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred…NTSB FTW82DA383Accident · No injuriesFinal reportBeechcraft K35 · Houston, TXPilot stated that he lifted the nose off the runway too soon and the aircraft became airborne but would not climb or accelerate. The aircraft drifted to the left and collided with a canal dirt bank.NTSB ANC82DAA19Accident · No injuriesFinal reportCessna A185F · Kotzebue, AKThe pilot reported that the wind was from 010 deg at 13, gusting 16 to 17 KTS. He stated that if runway 35 had been used for departure, there would have been a delay due to other aircraft. Therefore, he decided to expedite his departure by using runway 08.…NTSB ATL82DA270Accident · No injuriesFinal reportCessna 150 · Goldsboro, NCThe aircraft was flown by an unauthorized person after it had been secured for the night and the flight operation had been closed. On the next morning, the plane was found about 200 yards from the departure end of runway 04, where it had crashed. An…NTSB LAX82DXQ13Accident · 2 fatalFinal reportNorth American F-51D · Elko, NVThe plt flew down the length of rwy 06 about 100 ft AGL, pulled up & did an 8-point roll while climbing. He then flew down rwy 12 & pulled up. After a brief climb the plt began a slow roll to the left. Just as the acft became inverted the roll stopped & the…NTSB ANC82DA087Accident · No injuriesFinal reportCessna 185F · Naknek, AKThe pilot made a takeoff downwind in gusty conditions on a lake with marginal capabilities. Surrounding terrain makes wind swirling eddies. The aircraft lost lift and impacted on the bank of the lake in alder brush.NTSB SEA82DA157Accident · No injuriesFinal reportErcoupe 415C · Kingston, WAPilot thought he could not clear power lines and trees after takeoff so he aborted takeoff & slid 250 ft off the runway, nosing over. The pilot mentioned that it was hot & there was a slight tailwind. This was the first time the pilot has used the airstrip.NTSB LAX82FUG16Accident · 2 fatalFinal reportCessna 210A · Lake Havasu, CAThe pilot and passenger departed Lake Havasu airport. Following takeoff, the aircraft turned west and crossed the lake and shortly thereafter impacted the ground. There were no witnesses to the accident. The weather at the time of the accident was clear sky,…NTSB DEN82DA187Accident · No injuriesFinal reportCessna 150 · Faith, SDThe pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a…NTSB ATL82DA265Accident · No injuriesFinal reportCessna 188B · Gibson, GAThe pilot began a swath run by approaching the field over tall trees. Just beyond the trees was a 7 ft rise in the terrain. The pilot stated that he did not flare soon enough. Reportedly, the plane struck the crop, the gear sheared off and the plane slid to a…NTSB MIA82DA186Accident · No injuriesFinal reportSchweizer SGS 1-26B · High Springs, FLThe pilot was on a round robin cross-country flight. On the last leg of the flight, he was unable to locate sufficient lift to reach the destination. A large, unobstructed field was selected for a landing. However, the field contained a stand of waist High…NTSB LAX82DA332Accident · 2 fatalFinal reportVarieze Hamlin · Susanville, CADuring a 2nd pass down the runway at about 50 feet AGL, the aircraft pulled up to about 200 feet and completed over halfof a roll, then spiraled into a lake and was destroyed. According to witnesses, the engine was running at all times until impact.NTSB ANC82DA082Accident · No injuriesFinal reportPiper PA-18 · Anchorage, AKThe pilot departed in an easterly direction from an unimproved strip 700 feet in length. He stated that the aircraft waslifted off the ground at an airspeed of 35 to 40 knots and would not climb. He also stated that a 5 to 7 knot wind down the runway caused a…NTSB LAX82DUJ45Accident · No injuriesFinal reportAyres S2R · Goodyear, AZThe aircraft had just been loaded with spray material. The pilot stated that after taking off, he leveled off over cotton at the end of the strip and made a power reduction. At about that time, the aircraft settled into the cotton and hit an embankment. The…NTSB LAX82DA327Accident · Minor injuriesFinal reportCessna 172H · Daggett, CAThe acft flew into rising terrain at night. The plt was issued a student pilot certificate 3 yrs before the accident. The acft was registered to the plt's father . No further information was made available.NTSB ATL82DA260Accident · Minor injuriesFinal reportCessna A188 · Hillsboro, ALThe pilot reported that while making a swath run to the west over uneven terrain, his right wing contacted the cotton crop that he was spraying. The aircraft crashed and began to burn after coming to rest inverted. The pilot escaped with minor injuries before…NTSB MKC82DA162Accident · No injuriesFinal reportCessna T188C · Mechanicsville, IAThe pilot began his takeoff from a 2200 ft strip with a load of about 40 gallons of fuel and 1500 to 1600 lbs of seed. He reported that the wind was from the southeast at 2 mph, the temperature was 74 deg, and the elevation was 800 ft. the aircraft became…NTSB MKC82FA160Accident · 2 fatalField investigationFinal reportCessna T310R · Council Bluffs, IAThe omaha weather was reported (in part) to be 3500 ft scattered, estimated 6000 ft broken, 18000 ft broken, visibility 4 mi with fog and haze, wind 200 deg at 5 KTS. However, the aircrew of a preceeding flight that arrived about 8 min earlier said they…NTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.NTSB ATL82DA249Accident · No injuriesFinal reportBeech V35B · Clemson, SCDuring arrival, the wind was reported to be from 070 degrees at 15 gusting 20 KTS. On final approach with full flaps, the speed was bled off for an intended full-stall landing. The pilot reported that just prior to touchdown, the wind shifted about 90 degrees…NTSB LAX82DVG32Accident · Serious injuriesFinal reportBlanik L-13 · Chico, CAThe glider pilot reported that after he disengaged from the aerial tow, he was unable to find any of the expected conditions of lift. As altitude was lost, he elected to land in a vineyard. During the landing, the glider was damaged and the pilot received a…NTSB FTW82DA356Accident · No injuriesFinal reportCessna T188C · Black, TXWhile making a swath run the aircraft collided with an irrigation pipe which extended about 15 feet AGL. The pipe was near farm equipment and blended with the background. After the collision the aircraft made a forced landing in a cotton field.NTSB DEN82FTE24Accident · Serious injuriesFinal reportCessna 172M · Monarch Pass, COThe acft crashed in mountainous terrain at approximately 10,950 ft MSL 22 minutes after takeoff. The temperature at the accident site was about 50 deg f. rate of climb at 10,000 ft MSL & 50 deg f is about 251 fpm at 76 mph.NTSB NYC82DA213Accident · No injuriesFinal reportMooney M20J · Matawan, NJThe pilot stated that he had never been at this airport before. During arrival, he landed on runway 27 toward the setting sun with a crosswind from the left. He stated that he touched down firmly on the first 1/3 of the runway, then the aircraft floated…NTSB LAX82FUM10Accident · No injuriesFinal reportHughes 269B · San Diego, CAThe instructor (CFI) reported that during a practice autorotation, the helicopter contacted brush. Subsequently the aircrew lost control of the helicopter and it turned and rolled over. Reportedly, the CFI simulated an engine failure at about 150 ft AGL.NTSB LAX82FXQ12Accident · 2 fatalFinal reportCessna 182R · Dayton, NVAt about 0130 the plt & 4 companions were evicted from the cocktail lounge at carson city arpt for being drunk & disorderly. After the lounge closed they continued their drinking on the acft ramp where the plt & one companion attempted to steal a twin-eng…NTSB DEN82FTI17Accident · No injuriesFinal reportBellanca 17-30A · Browning, MTAcft landed with the gear up.NTSB ANC82DAG60Accident · 3 fatalFinal reportPiper PA-28R · Dillingham, AKPilot collided with mountainous terrain at the 1400 foot level. He proposed flight on V-452 which does not exist in that area. V-462 would have been appropriate but his position did not coincide with that route. He was on a VFR flight plan. Twilight ended…NTSB FTW82FPA16Accident · 2 fatalFinal reportBellanca 7ECA · Plano, TXDuring the 1818 departure from addison the plt advised addison tower that he was going to airpark-dallas for touch & go landings. The acft was observed to make at least one touch & go. At 1902 a witness called and reported hearing a noise, seeing a cloud of…NTSB ANC82DAG42Accident · Serious injuriesFinal reportCessna 185 · Near Tyonek, AKThe float equipped plane was being used to transport cargo. A passenger was put on the flight at the last minute, but the pilot believed the aircraft was within its maximum weight limit. After takeoff, the pilot remained at a low altitude for a time while the…NTSB LAX82FUM11Accident · 2 fatalFinal reportCessna 172N · San Clemente, CAAircraft declared missing by wife of passenger. Parts of the aircraft were found by boater and beach walkers from 8/18 to 8/25. Injury index presumed.NTSB LAX82DA307Accident · No injuriesFinal reportCessna 172N · Buckeye, AZThe pilot was on a flight to a private dirt strip. While on final approach to land, the sun was in his eyes and he did not see a 3 ft high mound of dirt near the threshold. The left main gear hit the dirt and sheared from the aircraft. After touchdown, the…NTSB NYC82FA203Accident · 2 fatalField investigationFinal reportChampion 7ECA · Lewes, DEAbout 15 min after takeoff, the aircraft was observed to enter a maneuver from low altitude over a beach area. During the maneuver, the plane pulled up, entered a steep climb and then banked or rolled left and entered a nose down attitude. Before recovering,…NTSB FTW82DA332Accident · No injuriesFinal reportCessna 150M · Balmorhea, TXThe pilot stated that while he was making a full flap landing, a crosswind drifted the aircraft off the narrow gravel landing strip. As he started to go around, the main gear hit a rock pile. The aircraft then bounced and hit the ground, nose first.NTSB FTW82FQD12Accident · Serious injuriesFinal reportLuscombe 8E · Timberon, NMPlt stated he could not gain sufficient altitude to clear terrain. A witness observed the acft at approximately 150-200 ft AGL, well below the top of the canyon.NTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…NTSB ANC82DA072Accident · Serious injuriesFinal reportPiper PA-22 · Icy Bay, AKWhile on a cross country flight, the pilot landed on a small lake to add fuel to the aircraft from cans carried in the aircraft. After departing the lake he encountered weather and attempted to transition to instrument flight when a hole he was using to climb…NTSB NYC82FGT17Accident · Serious injuriesFinal reportPiper PA-38 · Lancaster, PAThe student was making takeoffs & landings on his first solo flt. During final approach the tower instructed the plt to go around due to spacing behind another acft. The plt stated he applied full power, retracted flaps, climbed out to 800 ft & turned…NTSB FTW82DA324Accident · No injuriesFinal reportPiper PA-25-260C · Des Arc, ARAfter pulling up from a swath run, the aircraft began to settle, then collided with the ground. This occurred after the pilot had dispensed all or nearly all of his load.NTSB NYC82FA188Accident · 1 fatalField investigationFinal reportCessna 310R · Danbury, CTApproaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the…NTSB LAX82FA294Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Corcoran, CAThe acft crashed approximately 25 minutes after takeoff. There were no witnesses to the accident. The crash site was a plowed & cultivated seed alfalfa farm land. Ground scars reveal that the acft struck the ground in a level flight attitude, all wheels…NTSB DEN82DA158Accident · No injuriesFinal reportCessna 152 · Avondale, COThe student pilot was on a private pilot check flight with a designated flight examiner. While demonstrating balked landings, the go-around procedure was improper. Therefore, the examiner asked the student to repeat the procedure on the next approach (a short…NTSB DEN82DA156Accident · No injuriesFinal reportCessna 172M · Fairburn, SDThe aircraft tookoff with 4 occupants, baggage and 50 gallons of fuel. The density altitude was 4,963 feet. After takeoff, the pilot could not maintain altitude and stalled the aircraft into a field of high grass. The flaps were not used.NTSB SEA82FYA09Accident · 2 fatalFinal reportCessna R172K · Ketchum, IDThe acft was observed flying low over a road in mountainous terrain prior to impact. All pilot and aircraft records were destroyed by fire.NTSB SEA82DA136Accident · No injuriesFinal reportCessna T207 · Dixie, IDThe pilot took off with 4 passengers after waiting 4 hours for the air temperature to cool. The takeoff seemed normal, but over the river at about 50 feet AGL, the aircraft began to sink. It impacted rough terrain on the FAR side of the river. The airport…NTSB FTW82FQA24Accident · Serious injuriesFinal reportPiper PA-22 · Lake Arthur, NMThe pilot and one passenger were on a flight to pick up spare parts. The passenger recalled that while en route, the pilot remarked, "oh, I can't resist" and started to descend, then made a pass at about 50 ft over a field hand. The field hand, a mexican…NTSB FTW82DA318Accident · No injuriesFinal reportBeech 95-A55 · Conway, ARThe pilot report that he started to land on runway 18, but the wind shifted. At about 300 ft AGL, he aborted the landing and made a go-around to the right to land on runway 07. On the second approach, he forgot to extend the gear and landed with the wheels…NTSB FTW82DA316Accident · Minor injuriesFinal reportCessna 152 · Rockwall, TXThe pilot stated that he encountered wind shear, dust devil or other instantaneous failure, while flying at about 100 ft AGL. He stated the aircraft dropped, fell out of control, impacted and tumbled to a stop. Reportedly, a witness observed the aircraft…NTSB ANC82DAG39Accident · Minor injuriesFinal reportCessna 180 · Rush Lake, AKThe float-equipped acft failed to clear rising terrain after taking off from Rush Lake. The pilot stated that the enginewas developing full power.