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 LAX86FA289Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Santa Paula, CAAfter working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…NTSB MIA86LA205Accident · No injuriesLimited investigationFinal reportCessna R182 · Jacksonville, FLAfter the plt applied carb heat during the approach sequence, he became concerned about roughness in the eng. At about that same time, the tower cleared him to land behind another acft; however, at 1st, he did not have the other acft in sight & spent several…NTSB CHI86LA168Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Indianapolis, INThe aircraft landed gear up at Indianapolis international airport. Pilot and witness report that gear was down. However, FAA inspectors and mechanics who inspected the aircraft state that the left main and nose gear were found in the wheels wells and the…NTSB CHI86FER13Accident · 1 fatalFinal reportBell 47G-5 · Elrosa, MNThe helicopter was seen flying at a low altitude by witnesses and appeared to be flying straight and level and sounded normal. The helicopter impacted the ground in a northeasterly direction, 180 degrees from it's observed flight path. There were no witnesses…NTSB DEN86LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Cimarron, NMThe plt received a checkout in the acft prior to the accident and then flew to the philmont scout ranch located at approximately 9,000 foot MSL elevation. Ground witnesses stated that the acft was 'buzzing the area' and flew into an area of high terrain. The…NTSB ATL86LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Pandora, OHFollowing a early morning Balloon flight, the pilot attempted a landing in a cleared area with winds at about 14 knots. The pilot realized that the first attempt he would encounter powerlines and trees. The pilot climbed out and attempted another approach to…NTSB MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.NTSB DEN86LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Richfield, UTPlt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1) ... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…NTSB MIA86LA232Accident · No injuriesLimited investigationFinal reportMooney M20C · Ocala, FLThe plt stated that he put the gear handle down, continued his apch and landed without realizing the gear was still up. Post crash examination of the landing gear retract system revealed that the fuse for the landing gear motor had blown during the extension…NTSB LAX86LA271Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Upland, CAThe plt stated that he was practicing single engine procedures and he forgot to lower the landing gear. Another plt alerted him on the radio and he attempted to lower the gear but landed with the gear only partially extended. The plt stated that he chose to…NTSB NYC86FNC04Accident · 1 fatalFinal reportRolladen-Schneider LS-4A · Rochester, VTThe pilot was participating in a x-country soaring race. Aprox 15 miles from destination and for unknown reasons, the pilot experienced in flight collision with terrain. There was no evidence of pre-impact malfunction or failure. The pilot was certificated…NTSB FTW86FA115Accident · 1 fatalField investigationFinal reportCessna P206C · Grand Chenier, LAThe aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.…NTSB DEN86FA163Accident · 1 fatalField investigationFinal reportBeech C90A · Jackson, WYThe plt departed olathe, KS, en route to Jackson, WY. The plt radioed the denver efas and reported his position as 56 miles northwest of casper, WY. There was no further radio communication with N114CM. The plt's wife stated after the accident that the plt…NTSB CHI86LA154Accident · No injuriesLimited investigationFinal reportGlasflugel Club Libelle 205 · St. Elmo, ILThere was a loss of thermal activity while the glider plt was on a x-country flt. During an off arpt lndg, the wingtip of the sailplane struck weeds. Subsequently, the acft ground looped & was damaged.NTSB LAX86LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cucamonga, CADuring a pleasure x-country flight in the student plt's own acft, he elected to fly over a ridge of hills rather than via a longer route which circumnavigated the hills. While climbing enroute the plt entered a box canyon, experienced a downdraft and collided…NTSB FTW86LA108Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Odessa, TXAccording to the pax, the plt had been drinking prior to the flt. After takeoff, the plt decided that perhaps he was not in any condition to fly, so he elected to return to the arpt & land. Rprtdly, his seat belt had gotten caught in the door, & on final…NTSB LAX86LA250Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Colusa, CAThe plt was practicing takeoffs and landings when the acft's landing gear caught a berm on short final and the acft nosed over. The plt stated that there was no mechanical failure or malfunction of the acft.NTSB MIA86LA175Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Graceville, FLA witness stated that the acft had just completed a swath run & was pulling up to the left when the left wing tip struck the ground & cartwheeled the acft. The plt stated that the acft went into a 'high-speed' stall & cartwheeled approx four times & that he…NTSB ANC86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nulato, AKA witness on the ground watched the airplane fly the landing pattern for landing and at no time did he see the landing gear extend. He watched the airplane until it passed below the tree line. Testing of the hydro-mechanical and electrical systems did not…NTSB DEN86LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Williston, NDPlt stated that he was unfamiliar with the geographical area on this flt. He also stated, 'I was paying attention to the pwr lines and road and did not realize the hill out front was as high as it was...I attempted to turn back out, but with downwind it blew…NTSB LAX86LA242Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Thermal, CAThe helicopter collided with terrain during a maneuvering turn while applying a pesticide to a cultivated field. The acft was seen on the pass just prior to the accident and the acft appeared to be lower than usual. The acft was destroyed by post-impact fire.NTSB DEN86FA149Accident · Serious injuriesField investigationFinal reportAmerican AA-1 Yankee · Cheyenne, WYDuring takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…NTSB SEA86LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G21A · Hobart Bay, AKThe pilot neglected to raise the landing gear after departing the airport. While landing onto water with the gear still down, the aircraft's nose broke off and the aircraft nosed over inverted and then sank.NTSB FTW86FA096Accident · 1 fatalField investigationFinal reportMeyers 200B · Krum, TXThe retired airline captain was returning to a retirement party for another airline captain. He began a barrel roll from a relatively low pass over the party, but collided with the ground on pull out. Alcohol was not a factor.NTSB NYC86LA139Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Johnstown, PAThe flight departed Johnstown-cambria airport at about 1600 hours and returned at about 1700 hours. On landing, the pilot forgot to lower the landing gear and landed gear up. The aircraft slid to a stop and about five minutes later fire erupted.NTSB MKC86FCD01Accident · 1 fatalFinal reportPiper PA-25-235 · Lenox, IAThe acft collided with a fence during a takeoff with a full load of chemical pesticide. Collision with the ground resulted in a fire. The plt, who was seriously burned and later died, stated on his way to the hospital that he attempted to dump the acft load…NTSB SEA86LA132Accident · Minor injuriesLimited investigationFinal reportMorris B. Stephens Variviggen · Reno, NVAn excessively long takeoff run was made due to high density altitude. During intital climb the pilot over rotated causing a low airspeed. The pilot noticed this, lowered the nose and then flew into the ground. The pilot also failed to retract the landing…NTSB LAX86FA233Accident · 4 fatalField investigationFinal reportPiper PA 28-236 · Chino, CAThe private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…NTSB MIA86LA169Accident · No injuriesLimited investigationFinal reportCessna 172RG · Jackson, MSThe plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell…NTSB CHI86FER08Accident · No injuriesFinal reportCessna A188B · Montevideo, MNDuring takeoff roll from a roadway the wind shifted from a headwind to a tailwind. The pilot of this crop duster turned to avoid a stop sign on the roadway and allowed his landing gear to touch down on a crossing roadway. The aircraft then flipped over onto…NTSB ATL86LA131Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceburg, TNThe student plt had asked a pvt plt to ride with him while he (the student) took his son in law up for a ride. When approaching the rwy for landing, the student plt allowed the acft to collide with the berm short of the rwy. The acft came to a stop on the…NTSB DEN86LA135Accident · No injuriesLimited investigationFinal reportCessna T210M · Erie, COThe plt reports that he remembers going through the checklist on downwind following a short flight from a nearby airport. He does not remember doing a final 'down and green' check and the aircraft was landed gear up.NTSB MKC86FPG03Accident · Serious injuriesFinal reportSchweizer Grumman G-164B · Harrisburg, ARThe plt reported that while spraying a fld with propanil and penoxalin the wind shifted from the southeast to the northeast allowing the chemicals to cover the windshield thus reducing the plt's forward vision. This in combination with sun glare, resulted in…NTSB NYC86LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Marshfield, MAThe student pilot was making touch and go's on runway 24 in a Piper tomahawk. The wind was from the north west at 12 knots. The pilots reported the wing rose and the aircraft drifted left with a gust. He stated he applied power for a go-around, however the…NTSB ATL86FA120Accident · 4 fatalField investigationFinal reportPiper PA-28-160 · Winton, NCBefore the flt, the student plt & passengers had been socializing & drinking beer. At aprx 0200 EDT, while at a friend'shome near murfreesboro, NC, they decided to go flying. At about 0300, an acft was observed to fly over the friend's home at low alt, then…NTSB LAX86LA212Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Lower Lake, CAWhen the acft departed lampson arpt the left ldg gear did not retract. Gnd witnesses reported the airplane landed with only the left gear extended. The plt reported he observed all three ldg gear down green lights illuminated while in the traffic pattern. The…NTSB LAX86LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe plt misjudged the flare during landing and the acft touched down in a nose low attitude shearing the nose gear from the acft. The density altitude was calculated to be 3,500 ft when the accident occurred.NTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…NTSB MIA86LA131Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Orlando, FLPlt extended landing gear while in the landing flare. The aircraft settled onto the landing gear doors as the landing gear was extending which prevented the landing gear from extending. The aircraft then settled onto its belly and skidded off the runway.NTSB MIA86LA128Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Alachua, FLThe plt stated the he decided to land because the wind had picked up during the flt. Upon landing the gondola tipped over resulting in himself and one passenger falling on top of the other passenger, who received a fractured leg.NTSB ATL86LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lake City, TNWhile filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft…NTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.NTSB ATL86LA110Accident · Serious injuriesLimited investigationFinal reportAeronca L-3B · Harrison, OHDuring a demonstration flight to a resident who lived near the airport, the acft crashed in a plowed field in a departure stall. The flight was intended to demonstrate the safe maneuverability of the acft and deception of altitude clearances from the…NTSB ANC86LA043Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Fairbanks, AKThe pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing.NTSB NYC86LA099Accident · No injuriesLimited investigationFinal reportSikorsky S-76 · Safe Harbor, PAThe helicopter was maneuvering at low altitude, low airspeed, while on a search and rescue mission at night, looking for a capsized boat, when it impacted the water.NTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…NTSB SEA86LA085Accident · No injuriesLimited investigationFinal reportCessna 188-A · Warden, WAWhile at cruise, the pilot was distracted and had his head turned when he inadvertently flew into the ground.NTSB FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…NTSB CHI86FEX05Accident · 1 fatalFinal reportChristen Industries Eagle II · Aurora, INThe aircraft impacted the ground when an unsuccessful aerobatic loop maneuver was attempted on takeoff. The pilot of the aircraft was issued a statement of acrobatic compentency which allowed all maneuvers within the limitations of the aircraft and with a…NTSB CHI86FER01Accident · Serious injuriesFinal reportCessna 172H · Williams, MNThe plt made a low pass over a frozen, snow covered lake, then intended to make a climbing left turn. He rprtd the wx & light conds as 'slight haze, poor horizon visibility, very white out.' As the plt contd with what he thought was a climbing turn, the acft…