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 ANC82DA064Accident · Serious injuriesFinal reportCessna 207 · Near Kenai, AKSeveral black bears were spotted in a narrow canyon and the pilot began making tight, descending turns so his sightseeing passengers could get photographs. Reportedly, the stall warning horn came on, but the pilot continued the turns. He finally rolled out of…NTSB LAX82FVM17Accident · 1 fatalFinal reportGreat Lakes 2T-1A-2 · Scotts Valley, CAWhile performing in an aerobatic show, the pilot entered a spin. According to a witness, he entered the spin at about 2000 ft AGL and made approximately 5 turns before starting a recovery at about 500 ft AGL. He stopped the spin, but there was insufficient…NTSB NYC82DNC12Accident · No injuriesFinal reportBoeing PT-17 · Hamlin, METhe pilot departed a private strip with 150 gallons of water mixed with fungicide and insecticide. After takeoff, he turned and began climbing over rising terrain. The terrain sloped upward from a river, rising about 400 ft. the pilot reported that he failed…NTSB CHI82DA286Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Brooklyn Park, MNThe pilot took off from a 900 ft sod airstrip with a reported 6 kt head wind. He stated that there was not enough power to climb and the aircraft remained about 20 to 30 ft AGL. Due to the proximity of obstacles a forced landing was made in an open field…NTSB LAX82FA282Accident · 1 fatalField investigationFinal reportCessna 177 · 11mi.Sw Of Silv, NVAt 0237 the plt contacted ARTCC & verified that he was VFR at 9,500 ft MSL enroute to reno. At 0238 he located his position as 10 mi south of lidat intersection & was advised that oakland enroute radar was out of service. Lidat is on V105 between the beatty &…NTSB CHI82DA281Accident · No injuriesFinal reportEnstrom 280C · Spring Green, WIThe aircraft was on a photographic flight for the purpose of taking pictures of a piece of farm equipment. The first pass was made at about 50 ft AGL, heading into the wind. A turn was then made downwind, back toward the farm equipment. At about that time,…NTSB ANC82DA063Accident · Minor injuriesFinal reportPiper PA-32-300 · Mckinley Nat'L., AKThe pilot was flying over one glacier at about 700 feet AGL and turned to fly to another upslope glacier. He encountereda downdraft and was unable to climb enough to avoid colliding with the glacier. The elevation of the crash site was about 6600 ft MSL.NTSB ANC82DA062Accident · 1 fatalFinal reportHughes 369D · Near Bornite, AKTwo workers were transported to a mine drilling site where the helicopter was landed on a man-made heli-pad. The heli-pad was an area about 50 ft long and 12 ft wide that had been cut into the side of a rocky hill. After off-loading the workers, the pilot…NTSB DEN82DA143Accident · No injuriesFinal reportCessna 150M · Nr. Colorado Sp, COThe acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.NTSB ATL82FA208Accident · Minor injuriesField investigationFinal reportBeech B-60 · Sylva, NCThe aircraft crashed during takeoff after the pilot reported a loss of power on the left engine. The aircraft slid to a stop about 600 feet southeast of the departure end of runway 32. The pilots statement and physical evidence do not correlate. The prop…NTSB CHI82FA267Accident · No injuriesField investigationFinal reportRobinson R22 · Milwaukee, WIAs the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…NTSB LAX82FA273Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Tonopah, NVThe acft impacted the east slope of a ridge at 6500 ft MSL.NTSB CHI82FA260Accident · 1 fatalField investigationFinal reportRotorway Scorpion TOO · Niles, OHThe plt's wife stated that the helicopter was taken across the street to an open field where the plt conducted his flt in the acft. She had never seen him fly this acft over about 3 ft AGL. The helicopter was observed to jump as if lifted by a gust of wind &…NTSB MKC82DA129Accident · No injuriesFinal reportTexas Helicopter OH-13E · 10 Sw Of Milan, MOThe plt had reduced the spray load from 90 to 50 gals to compensate for the increase in density altitude. The winds were blowing lightly during previous takeoffs but were calm during this takeoff. As the helicopter hovered forward during the takeoff it failed…NTSB LAX82FA267Accident · Serious injuriesField investigationFinal reportCessna T337H · Near Inyokern, CAApproximately 10 min after takeoff the acft impacted a ridge of a canyon at 5,500 ft MSL about 200 ft below the ridge line. The density altitude was 8,900 ft.NTSB DEN82DA151Accident · No injuriesFinal reportCessna 150F · Sheridan Lake, COThe pilot reported that he was on a flight to check his fields and crops for possible hail damage. Reportedly, he decided to see how a friend was doing with his wheat harvest and to see if he had received hail damage. The pilot stated that he spotted his…NTSB FTW82FQA22Accident · 4 fatalFinal reportCessna 172N · Santa Fe, NMThe acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857…NTSB SEA82FYP09Accident · 3 fatalFinal reportCessna 172M · Wenatchee, WAReportedly, the pilot, a geologist, was on a flight to check rock formations. Prior to the accident, the plane was observed flying up a canyon at low altitude and airspeed. About 3/4 mile from the accident site, two witnesses on a rocky cliff at about 3500 ft…NTSB LAX82FA260Accident · 5 fatalField investigationFinal reportCessna TR182 · Happy Camp, CAThe aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined.NTSB CHI82DA256Accident · No injuriesFinal reportPiper PA-32RT · Mackinac, MIAircraft landed wheels up. No malfunction of the landing gear system could be found.NTSB SEA82DA121Accident · No injuriesFinal reportLake LA-4 · Newport, ORThe pilot reported that during takeoff, he had accelerated to about 40 mph, and was on the step, when he hit a wave of sufficient size to bounce and become momentarily airborne. He was still accelerating and bounced a second time when it became apparent that…NTSB LAX82FA262Accident · 1 fatalField investigationFinal reportCessna T-210L · Reno, NVThe pilot was descending in a mountainous area and did not clear the high terrain before collision with the ground occurred. The pilot was in radio communication with Reno tower and was given landing instructions. There was no verbal indication of trouble on…NTSB ATL82DA220Accident · No injuriesFinal reportCessna 210D · St. Simons Isla, GAThe pilot was unable to extend the landing gear by using either the normal or emergency pump. Subsequently, a wheels up landing was made. An examination of the hydraulic powerpack, pn 1280510-1, revealed that the secondary pressure relief poppet valve…NTSB FTW82DA283Accident · No injuriesFinal reportBeech A36 · Port O'Connor, TXThe pilot decided to land at an airstrip that he had landed at about 3 years previously. Before landing, he made a 500 ft pass over the strip. He reported that the sun and glare were bright. He saw white spots on the strip, but thought they were filled-in…NTSB FTW82FPG18Accident · Serious injuriesFinal reportGrumman G-164A · Casa, ARThe aircraft collided with rising terrain during a procedure turn. While spraying a rice field.NTSB CHI82DA240Accident · No injuriesFinal reportPiper PA-24-250 · Lafayette, INDuring arrival, the pilot was unable to extend the gear by using the normal (electrical) system or the manual emergency handle. After repeated attempts to correct the malfunction, he elected to land with the gear up.NTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…NTSB MIA82DA150Accident · No injuriesFinal reportPiper PA-24 · Clearwater, FLDuring the approach to the airport, the pilot was distracted by other aircraft and failed to extend the gear. The propeller and lower surface of the aircraft were damaged during a gear up landing.NTSB SEA82FYK09Accident · Serious injuriesFinal reportAeronca 7AC · Near Creswell, ORThe aircraft crashed while the pilot was making a low pass over a grass field. The pilot reported that the plane struck the ground while he was proceeding westbound toward the setting sun, but he did not remember the details of the crash. An instructor pilot…NTSB DEN82DA124Accident · No injuriesFinal reportLuscombe 8F · Calhan, COThe pilot took off from an airport with a density altitude of about 9500 ft. after lift-off, the aircraft reached an altitude of about 100 ft AGL and then stopped climbing. The pilot initiated emergency procedures which included leaning the mixture and…NTSB LAX82DA239Accident · No injuriesFinal reportCessna R182 · Fresno, CAWhen the landing gear was extended to demonstrate an approach-to-landing stall, there was no safe indication. The gear was recycled but the nose gear would not extend. All attempts to extend the nose gear, including the use of the emergency extension hand…NTSB NYC82FHJ06Accident · 3 fatalFinal reportCessna 177 · Larchmont, NYThe aircraft was on a flight to take pictures of a home that was recently constructed on the shore of long island sound. While in flight, pictures were also taken of boats. A witness on a boat stated taht after the pilot made several passes over boats, the…NTSB LAX82DUJ41Accident · No injuriesFinal reportCessna 150G · Pima, AZDuring arrival, the pilot entered traffic to land on runway 36. He reported that the wind was from 97 degrees at 10 gusting 15 knots. While landing, he felt the touchdown would be too FAR from the approach end, so he initiated a go-around. The density…NTSB MKC82FCQ11Accident · Serious injuriesFinal reportCessna 188B · Scott City, KSThe aircraft crashed during an aerial application operation; however, the pilot could not remember the details of the accident. He believed that the propeller may have started to turn excessively fast, but this was not verified. After contacting the ground,…NTSB DEN82DA114Accident · No injuriesFinal reportSchweizer SGS 1-34 · Colorado Spring, CODuring the takeoff roll, the canopy of the glider came open while the glider was being towed. The pilot attempted to close the canopy, and in doing so, the glider became airborne, then contacted the runway in a nose low attitude. Subsequently, the glider…NTSB DEN82AA115Accident · 6 fatalFinal reportBeech V35B · Near Ringling, MTAlthough IMC existed over mountainous areas, the plt attempted a visual flt direct to salt lake city. The probable flt path of the acft was one which is usually flown by plts on VFR flts. The course taken by plts desiring to cross over themountain ridges west…NTSB LAX82FA230Accident · 1 fatalField investigationFinal reportCessna P210N · Jamul, CAThe plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The…NTSB FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…NTSB DEN82FA106Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dillon, MTThe pilot maneuvered the helicopter close to the ground to "spook" an antelope. After a series of turns, the aircraft touched down on both skids and continued forward 246 ft before stopping.NTSB ATL82IA170Incident · No injuriesIncident investigationFinal reportMooney M20J · Dauphin Island, ALAfter a normal flight from birmingham, AL, the pilot executed a visual full circuit approach to runway 12 at Dauphin Island, AL. The pilot stated that he stabilized on final at 72 knots with full flaps and that he had a 5-10 knot crosswind from the south. The…NTSB DEN82DA107Accident · No injuriesFinal reportPiper PA-28-151 · Jackson, MTThe pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at…NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…NTSB SEA82DA092Accident · No injuriesFinal reportBlanik L-13 · Driggs, IDThe pilot held a commercial, airline transport certificate, but had only a student glider certificate. During a towed takeoff, witnesses observed the spoilers extend after about 200 ft of ground roll. The tow pilot gave an arm signal to indicate a problem.…NTSB ATL82DA171Accident · Minor injuriesFinal reportPiper PA-25-235 · Ripley, INWhen the pilot arrived to spray the field for the first time, he saw powerlines along a road and saw poles on both sides of a creek. He assumed that all of the lines followed the road. He was unaware that a powerline crossed the narrow field that he was about…NTSB NYC82AA125Accident · 4 fatalFinal reportPiper PA-28RT-201 · Dunkirk, NYThe flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200…NTSB MKC82DA108Accident · No injuriesFinal reportCallair A-9B · Ulysses, KSThe pilot was on a spray flight over an area of sand hills. While dropping flags to help determine the wind on the surface, he encountered unfavorable wind conditions and a sudden loss of lift. He applied full power, but was unable to recover from the mushing…NTSB ATL82FKM05Accident · Serious injuriesFinal reportBeech F35 · Franklin, NCThe pilot made his initial approach to runway 07 at mason county airport. The approach seemed high to the pilot, so he executed a go-around and decided to land on runway 25. During the second approach, he extended the flaps, but not thelanding gear. When the…NTSB ATL82DA168Accident · Serious injuriesFinal reportSchweizer SGS-2-32-A · Williamson, GAOn downwind, the pilot saw another glider on the runway. He maintained altitude until the glider cleared the runway. When clear the pilot started his descent extending the spoilers fully. The pilot stated that when he reached his desired altitude and leveled…NTSB NYC82FGM11Accident · 1 fatalFinal reportBell 47G-3B-1 · Kittanning, PAThe helicopter was on a powerline patrol flight with three occupants on board. While proceeding along the powerline with a tailwind, the pilot started to climb over a hill. He stated to the passengers that he was unable to out climb the hill, then circled to…NTSB ATL82FA164Accident · Serious injuriesField investigationFinal reportCessna 172P · Asheville, NCThe flt reportedly involved mountain flying techniques. The student observed that the acft was not climbing normally & the CFI suggested they slow to 70K. The student started a turn toward a wide valley but the CFI urged him to continue toward the mtns which…