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 SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.NTSB BFO86FID04Accident · No injuriesFinal reportCessna 210N · Blacksburg, VAWhile landing at Blacksburg airport in Blacksburg, Virginia, the landing gear failed to extend. The aircraft collided with a runway light and served off the runway onto a grass area causing substantial damage to the left stabilizer and elevator. The pilot…NTSB MIA86LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Captiva, FLThe plt stated that she was making a low final approach to the 2200 ft grass strip & lost lift as the acft passed below & behind the treeline. The plt's husband, also a plt, occupying the right front seat, stated that his wife may have been somewhat…NTSB LAX86FA131Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Newport Beach, CAThe acft was rprted to be on a dual, night recurrent, training flt. The student plt's wife rprtd that the flt instructor(CFI) & her husband had been drinking beer before they & the passenger (another student plt) departed on the flt. Ground witnesses observed…NTSB NYC86FNE02Accident · No injuriesFinal reportFolsom Sonerai II · Middlebury, CTThe plt reported that the acft was slow to climb after takeoff and had reached an alt of only 100' AGL at the end of the 5000' lond rwy. The plt continued to state the acft was unable to clear rising terrain aprx 1/2 mile from the arpt. The acft contacted the…NTSB SEA86FA066Accident · 2 fatalField investigationFinal reportPiper PA34-200T · Antelope, ORPlt was operating VFR on top at 11000 feet, commenced descent to destination 34 miles out. Plt rpted field in sight 16 miles out, passing 6500 ft, cancelled flight plan. Acft impacted ridge at 4100 feet MSL 7 miles from destination. Dark night conds existed,…NTSB CHI86FA092Accident · Serious injuriesField investigationFinal reportBeech G18S · Janesville, WIThe aircraft impacted the ground about 1,000 ft to the left of the runway. The pilot stated that he did not have visual contact with the ground & remembers attempting to make a missed approach. Conditions were IMC.NTSB MIA86FA082Accident · Minor injuriesField investigationFinal reportPiper PA-44 · Panama City, FLThe air taxi flight had begun the instrument ILS approach and the pilot stated he obtained visual contact with the runway lighting system. He was starting to land when he lost all visual contact and initiated a missed approach. The aircraft then veered left…NTSB ATL86FA077Accident · 1 fatalField investigationFinal reportCessna 182P · Elyria, OHThe plt was cleared for and executed a rwy 17 ILS apch at night. Prior to beginning the apch he was informed that vis was 1/8 mile. Minimum for the apch was 1/2 mile. At the middle marker the plt rated pax in the right seat told the PIC that the rwy was not…NTSB LAX86FA120Accident · 1 fatalField investigationFinal reportCessna 172M · Carlsbad, CAAfter failing to see the runway on his first ILS approach in weather reported at IFR minimums for landing, the pilot was radar vectored for a second approach. According to controllers the approach appeared to be normal until the aircraft's radar target…NTSB MIA86LA079Accident · No injuriesLimited investigationFinal reportBeech 55 · Ft. Myers, FLThe plt stated that he had experienced an electrical failure & because it was getting dark, he could not see the mechanical landing gear position indicator. He said that he performed a 'gump' check & verified that the gear handle was in the down position, but…NTSB ANC86LA028Accident · Serious injuriesLimited investigationFinal reportCessna 182-A · Merrill Pass, AKThe pilot stated that he could see the whiteout condition ahead. During the 180 deg turn the aircraft struck the 3000 foot level of the mountian Pass. At the time of the accident the weather was a complete IFR whiteout condition.NTSB ANC86LA026Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Mcgrath, AKThe pilot had been drinking for an unknown period before undertaking the night flight. After takeoff, the acft was observed flying in the local area in an erratic manner. Subsequently, the acft crashed about .6 mi short of rwy 16. Impact occurred at the base…NTSB BFO86FA015Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Lynchburg, VAThe aircraft had departed elberton, Georgia at about 2043 hours on an IFR flight plan to Lynchburg, Virginia. After failing to descend out of 4000 feet during the first approach, N9477C was vectored around for a second ILS approach to runway 3. Since the…NTSB DEN86LA074Accident · No injuriesLimited investigationFinal reportCessna T210M · Truth Or Conseq, NMAccording to the pilot, during the landing roll he is accustomed to keeping the nose gear off the runway until the ground speed has slowed. The pilot stated he did not check the landing gear condition lights. Upon lowering the nose, the acft propeller and…NTSB DEN86FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Berthoud, COStudent plt rented acft from flying club, acft was observed by witnesses to approach the lake from the south end at a low alt. Acft struck water with right main lnd gear and rt wing tip, and nosed over. The water was described as being 'glassy' and the sun…NTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.NTSB NYC86LA064Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Farmingdale, NYThe acft collided with trees in the bethpage state park during a rwy 14 ILS apch at republic airport, Farmingdale, NY. The plt had instructed his passenger, a private plt, to report when he had the apch lights in sight. The plt stated the apch was continued…NTSB ATL86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Rural Retreat, VAPilot said first adf approach terminated by missed approach due to oscillating directional needle. On second approach acft broke out of clouds with trees in front of acft. It impacted a cloud obscured ridge 3.5 miles southeast of airport on a southerly…NTSB SEA86LA043Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Sloan, NVAcft was observed performing low-level aerobatics, failed to complete pull-out from second consecutive overhead maneuver, striking ground in 20-30 degree nose-low attitude. No evidence of pre-impact mechanical failure or malfunction found in acft structure,…NTSB ATL86FA062Accident · 5 fatalField investigationFinal reportCessna 337G · Blairsville, GAAcft was flown VFR from ravenna, Ohio en route to atlanta, GA. It departed ravenna about 0930 01/17 & failed to arrive at its destination. Family reported acft missing. Air force rescue center notified at 2020 01/19. Cap commenced air search 01/20, hampered…NTSB FTW86LRA04Accident · Minor injuriesFinal reportEagle DW-1 · Bremond, TXAccording to the pilot, the aircraft was being operated by thompson flyers of garwood, inc., rt 1, box 214, marlin, TX. In agricultural aircraft operations under FAA ag operation certificate no. SW-HOU-97-AG. The aircraft had completed its last swath run…NTSB MKC86LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150B · Gove, KSAfter takeoff fm the private airstrip near Gove, Kansas, the aircraft was witnessed to descend towards the ground until impact. The witness to the accident, who is a plt and the owner of the airstrip, stated that after the acft clrd the airstrip environment…NTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…NTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…NTSB NYC86FA057Accident · 2 fatalField investigationFinal reportCessna 182L · So.Glastonbury, CTThe acft was on a VOR instrument apch when it collided with 250 ft high terrain approx 6 miles south of the arpt and approx 2 miles north of the vor/faf. Shortly before the accident the pilot notified ATC that he was in turbulence; then reported he was clear…NTSB ANC86FA020Accident · 2 fatalField investigationFinal reportCessna 182 · Lake Clark Pass, AKThe acft collided with rising terrain while maneuvering in a mountain Pass. Low ceilings, 40 to 50 kt winds and rain showers were reported in the area at the time of the accident.NTSB DEN86LTM01Accident · Serious injuriesFinal reportCessna 172 · Brigham City, UTThe acft contacted mountainous terrain during a descent through fog. The plt stated that on the return flt from malad, ID, he began following a mountain range which he believed would take him back to ogden. However, the range guided him southwest of the…NTSB LAX86LA070Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Moss, CAAfter starting a left climbing turn at the end of a spray run the plt said he felt a 'shudder in the airframe' as the engine 'went to full RPM.' The plt stated that he thought 'the clutch had slipped' and added collective to compensate. The helicopter began…NTSB ATL86FA040Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Springfield, TNThe acft collided with the ground inverted. Witnesses stated that the acft was performing loops prior to the accident. Reportedly, the plt was giving a female companion a 'joy ride'. The plt had recently received his commercial cert. Instrument rating & CFI…NTSB LAX86FVA01Accident · 1 fatalFinal reportRobert D. Campbell KR-1 · Oakdale, CAThe acft crashed in a cow pasture in VMC wx. The acft left wing struck the ground in a steep angle of bank and the acft nosed in throwing the eng 450 ft farther across the field. The canopy & canopy latch were found prior to the impact point of the left wing.…NTSB ATL86FA039Accident · 1 fatalField investigationFinal reportPiper PA-30 · Corning, NYDuring ILS runway 6 approach acft hit high terrain short of the outer marker. When on downwind for approach pilot said he was not receiving the localizer and asked for a surveillance approach. Controller said he could not provide. When cleared for the ILS…NTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…NTSB CHI86LA040Accident · No injuriesLimited investigationFinal reportCessna 177 · Crookston, MNWhile doing a 270 degree turn on base leg for runway realignment the pilot permitted the acft to fly into the ground.NTSB DEN86FA034Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Englewood, COThe plt had been flying aprx 7 hrs and was completing the flt at night when the accident occurred. He was using visual cues (the arpt enviroment) to position the acft at a proper alt for a visual apch and landing. The terrain south of the arpt rises several…NTSB DEN86LA035Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Beulah, NDDuring a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around.NTSB NYC86LA044Accident · Minor injuriesLimited investigationFinal reportPiper Aztec · North Adams, MAThe flight departed albany new york under VFR conditions and picked up IFR clearance to pittsfield, MA. The pilot flew the approach until reaching VFR under a cloud layer at about 2500 ft. continuing VFR toward no. Adams at an altitude of 2000 ft, the pilot…NTSB LAX86LA045Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Sunizona, AZWhile performing 'low level surveillance for deer' a pax pointed outside the acft to a familiar camp site. The plt stated this action distracted him & thereafter he flew up a narrow canyon. Unable to reverse course because of rising terrain, the plt stated he…NTSB ANC86FA009Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Quinhagak, AKThe aircraft crashed on the frozen level tundra at night while on a part 135 air taxi flight from bethel to quinhagaki Alaska. The investigation revealled the commericial rated air taxi pilot did not have a 135 air taxi check ride or competency check. The…NTSB NYC86LA035Accident · Serious injuriesLimited investigationFinal reportLake LA4-200 · Millbrook, NYDuring a go-around the aircraft stalled and crashed on the airport.NTSB CHI86MA025Accident · 5 fatalMajor investigationFinal reportCessna 441 · Derry, PADrg arrival, the plt was advised the destn wx was: estd 500' overcast, vis 1 mi with fog, arpt blo mins. The plt electedto make an NDB rwy 23 apch, but said he would divert if a missed apch was made. He was provided radar vectors & was clrdfor the apch. At…NTSB FTW86FPA05Accident · Minor injuriesFinal reportMooney MK20J · Gladewater, TXDuring takeoff the headset wiring became tangled in the emergency gear extension handle which had been accidently activated. Then the normal gear handle was put in the up position, the emergency gear crank rotated pulling on the headset and the emergency gear…NTSB MKC86FCJ01Accident · Serious injuriesFinal reportCarothers Monoplane · Lincoln, NEThe plt was performing aerobatics while being photographed for a promotional video. On the last pass over the arpt the acft lost airspeed and began a side slip with the left wing down. At a very low alt AGL the acft appeared to stall and assume a higher sink…NTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…NTSB FTW86FPA02Accident · Minor injuriesFinal reportHomebuilt Fokker DR-1 Replica · Denton, TXThe pilot stated he was making his fourth fly-by at 400 feet AGL when the aircraft developed a high sink rate. He then lowered the nose and gained airspeed for recovery. While leveling off he had to turn left to avoid impact with a small tree. At this time…NTSB SEA86FA020Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · N.Battle Moun., NVThe aircraft impacted the ground after attempting an aerobattic maneuver at about 300 feet AGL. Several witnesses observed the aircraft enter a loop or climbing roll and diveinto the ground. No evidence of failure or malfunction of the aircraft was found…NTSB LAX86FA024Accident · 1 fatalField investigationFinal reportChampion 7ECA · Seal Beach, CABased upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…NTSB FTW86LPJ01Accident · No injuriesFinal reportCessna 172 · Kremlin, OKThe acft landed in a wheat field adjacent to the sod rwy. The acft nosed over in a small ditch during rollout. The plt said he mistook the green winter wheat for the sod rwy which was now brown dormant grass from a frost and not green as it was when the plt…NTSB SEA86MA018Accident · 4 fatalMajor investigationFinal reportGates Learjet 24D · Juneau, AKDrg arrival to pick up a med-evac patient, the flt was clrd for an LDA-1 rwy 8 apch via the asort transition. Thus, the plt should have contd se on J-541 twd the ssr VORTAC & intercepted the localizer (LOC) at asort; then track inbnd on theloc (062 deg),…NTSB LAX86LA022Accident · No injuriesLimited investigationFinal reportCessna 210M · Oakdale, CAThe plt said that he made a 'fairly rapid descent' from a 10,500 ft MSL cruise alt to the airport pattern and experienced a 'painful pressure' in his ears. The plt said he was also wearing a headset. On entry into the pattern, theplt said he 'forgot to lower…