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 MKC85LA090Accident · Minor injuriesLimited investigationFinal reportLester F.W. West VP-1 · Taylor, MOThe pilot used only half of the available 2900 feet of runway on his first flight in this homebuilt airplane. He lost flying speed climbing over wires at the end of the runway, went around trees and landed hard on a highway median.NTSB FTW85LA198Accident · Serious injuriesLimited investigationFinal reportPartenavia P68C · Tilden, TXAfter aprx 1.5 hrs of pipeline patrol flight at a planned altitude of 500 AGL the acft flew into the flat terrain in a landing attitude. The acft went through a wire fence, heavy brush and small trees before coming to rest 437 ft from initial ground contact…NTSB SEA85LA095Accident · 2 fatalLimited investigationFinal reportBeech 36 · Elko, NVElko DME (located at the arpt, used for the lda/dme apch, 108.5 mhz) was inop. Drg arrival, the plt expressed mistrust of his DME. Aprx 24 mi sse of bullion (bqu) VOR, ARTCC controller (ctlr) clrd N7514N for 'the apch to the Elko arpt.' Seconds later, the plt…NTSB DEN85FA120Accident · 1 fatalField investigationFinal reportCessna P210N · Laporte, COThe plt was a business man, involved in building/construction work. On the morning of the acdnt, he had breakfast with friends who said he was in good spirits & was going to fly before going to work. Witnesses near the acdnt site saw the acft flying in the…NTSB LAX85FA213Accident · 1 fatalField investigationFinal reportBeech F33A · Goleta, CAWhen the plt was advised the destn arpt (santa ynez) was directly ahead at 12 mi, he requested a freq change & radar svc was terminated. About 9 min later, he reestablished radio contact (with ARTCC) & reported he was not sure of his psn. The controller told…NTSB MIA85LA151Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Miami, FLThe plt stated that he permitted a non-plt pax to close the cabin door & he, the plt did not check it. Shortly after liftoff the landing gear was retracted & the door popped open. The pax turned in his seat to close the door & bumped the yoke forcing the acft…NTSB LAX85FA216Accident · 1 fatalField investigationFinal reportPiper PA25-235 · Walnut Grove, CAThe acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's…NTSB LAX85FA210Accident · 6 fatalField investigationFinal reportCessna U206G · Tuba City, AZThis was a medical transportation flight during the early morning hours in marginal weather conditions. The flight was not completed and was returning to the departure airport when it descended into desert terrain 10 miles short of its destination.NTSB DEN85FA118Accident · 2 fatalField investigationFinal reportCessna 172 P · Santa Fe, NMTwo persons, neither rated as plts, took the acft without the knowledge or consent of the operator or arpt officials. They took off at night, & after a short time, returned to the arpt to land. During an attempted landing, the acft touched down hard, bounced…NTSB CHI85LA161Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Stevens Point, WIDuring a low level flt over a river, the plt initiated a turn to reverse direction at 300 ft AGL. The acft contacted the water during the descending turn and nosed over.NTSB NYC85LA105Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Utica, NYThe accident occurred during a training flt for empire airlines. A left eng failure was simulated past the faf when aprx 300 ft above mda. The student completed the emerg checklist which included retracting the landing gear. The flt then continued visually to…NTSB NYC85FA104Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · East Haddam, CTDuring approach to runway 14 pilot decided to go around. Aircraft turned left about 90 degrees and collided with rising terrain .2 NM east of the runway. The rising terrain parallels runway 14.NTSB ATL85LA131Accident · No injuriesLimited investigationFinal reportMooney M20E · Gunthersville, ALThe plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing.NTSB DEN85FA113Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · Williston, NDThe flt crew stated after the accident that the flt was uneventful from rap to ins. The first officer was flying the acft when the accident occurred. According to the flt crew all checklist items had been performed prior to the landing. The acft made gnd…NTSB FTW85LA174Accident · No injuriesLimited investigationFinal reportCessna T337G · Big Spring, TXAcft landed gear up. Plt stated he simply forgot to lower the landing gear.NTSB SEA85FA082Accident · 3 fatalField investigationFinal reportCessna 172B · Smith, NVAccording to witnesses, the plt made multiple passes over his residence at low alt. The witnesses observed the acft in various maneuvers at low alt. One maneuver was described as a pull-up from about 100 ft to aprx 600 ft, where the acft went into a wingover…NTSB LAX85FVG01Accident · No injuriesFinal reportCessna 152 · Lower Lake, CAThe acft contacted trees while attempting to land at hoberg airstrip.NTSB MIA85FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Rockledge, FLOn March 31, 1985 the rental acft departed merritt island flon April 1, 1985 the acft was found crashed near Rockledge FL. No evidence of pre-existing airframe or powerplant failure was found. The acft impactd the ground in a high velocity 40 degree nose down…NTSB SEA85LA081Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Trinidad, WAThe pilot was operating the aircraft by flying at low altitude down the columbia river so as to avoid turbulence. During the flight a downdraft was encountered in which insufficient altitude was available to prevent the water and an unintentional ditching…NTSB NYC85LA093Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Orange, MAThe plt reported he was flying at about 25 ft above water. As the acft crossed over a grass covered sand bar, the gear encountered 'swail grass' & the acft was 'dragged in.' The plt also reported that the acft had encountered turbulence; however, a witness…NTSB LAX85LVD01Accident · No injuriesFinal reportPiper PA-24-250 · Navato, CAThe acft was landed gear up. The plt stated that as he retarded the throttle to land the lndg gear warning sounded. He applied power but the acft touched down with a scraping noise. He does not remember seeing a green lite for gear dwn indication.…NTSB LAX85FA185Accident · Serious injuriesField investigationFinal reportSwearingen SA 226TC · Los Angeles, CAOn this leg of the flt, the 1st officer (fo) was flying the acft while the captain (capt) was monitoring & conducting ATC communications. Reportedly, the aircrew had followed the checklist during arrival; however, the acft was landed withthe gear retracted.…NTSB ATL85FMG04Accident · 1 fatalFinal reportGross Taylor Titch · Liberty, NCAccording to witnesses interviewed, pilot made a takeoff on runway 2, holding the plane just a few feet off the runway with a steep pull up at the end of the runway. It was then observed doing a steep bank, low altitude 180 degree turn and proceeded…NTSB CHI85LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Brighton, MIWhile attempting to execute a go-around with a 90 degree crosswind, velocity 16 kmph, gusting to 28 kmph, the acft apparently stalled just after becoming airborne. It impacted the ground about 300 feet west of the rwy. Witnesses stated that the acft appeared…NTSB LAX85FA180Accident · 1 fatalField investigationFinal reportBeech B-19 · Flagstaff, AZAfter receiving numerous weather briefings, that reported instrument meteorological conditions and marginal visual meteorological conditions, the pilot tookoff into the dark night, for his return flight, over mountainous terrain. The aircraft impacted a…NTSB FTW85LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Wheeler, TXAccording to the plt, en route deteriorating wx was experienced and he elected to land at Wheeler instead of his original dest, grandfield, OK. The acft was landed slightly fast and downwind. Winds were from 210 degrees at 15 gusting to 20. At the acft neared…NTSB BFO85LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Leesburg, VAThe plt enplaned 3 adult paxs and taxied to rwy 17 for tkof. Rptd wnd was 310 at 8KTS. Tkof roll was iniated and continued until near midfld at which time it became apparent to the plt that the acft would not rotate. The plt then abtd the tkof but as the acft…NTSB ANC85LA055Accident · No injuriesLimited investigationFinal reportCessna 170B · Circle, AKThe plt took off at night from a snow covered rwy with no rwy lights. He reported that after the acft lifted off, he lost visual references due to the darkness. Shortly after that, the acft settled into alders, willow brush & deep snow & was substantially…NTSB ANC85FA054Accident · Serious injuriesField investigationFinal reportde Havilland DHC-6-300 · Barter Island, AKAcft crashed during missed apch to temporary winter landing strip. Acft hit in steep nose down attitude. Marginal wx conditions prevailed, with icing reported.NTSB CHI85LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Center Village, OHWhile the student plt practiced hovering 8 to 12 inches AGL the heel of the right skid contacted the ground. The CFI stated he did not notice the helicopter drifting or descending but when the ground contact was felt he took over the controls. Up collective…NTSB ATL86FA028Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Robbinsville, NCMsg acft found after 9 mos. Remains found on east side of coline ridge in graham co NC. Path of broken limbs/trees about level into mountainside. Both occupants fatal.NTSB ATL85LA115Incident · No injuriesLimited investigationFinal reportEnstrom F-28A · Jacksonville, NCThe plt lost directional control of the acft while attempting to air taxi the helicopter to another position on the ramp.NTSB CHI85LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Champaign, ILDuring a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…NTSB LAX85FA163Accident · 2 fatalField investigationFinal reportCessna 152 · Modesto, CAAccording to witnesses, the plt completed a short checkout and then boarded a female companion in the rented acft, took off and flew to a point 2.9 NM from the airport. The acft was observed by numerous ground witnesses to perform a 'series of wingovers, at…NTSB FTW85FA130Accident · Serious injuriesField investigationFinal reportHughes 269C · San Antonio, TXThe accident occurred during a zero ground speed practice autorotation. A high sink developed after an attempt to correct for decreasing rotor RPM, the helicopter contacted the ground tail first and rolled over after the main rotor severed the tail boom. An…NTSB SEA85FA067Accident · 1 fatalField investigationFinal reportCessna 175 · Bancroft, IDThe acft impacted level terrain aprx 500 yards east of the Bancroft arpt. N9386B was one of a flt of two acft returning to Bancroft from preston, ID. The wx had deteriorated during the flt with snow showers and blowing snow. While the other acft was landing…NTSB ANC85LA049Accident · No injuriesLimited investigationFinal reportCessna 207 · Dillingham, AKThe plt was attempting a 180 deg turn to reverse direction away from lowering clouds and snow showers when the right wing dug into the snow covered terrain. The plt stated a virtual 'white out' condition existed at the time.NTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…NTSB MKC85FA062Accident · 3 fatalField investigationFinal reportPiper PA-31P · Sunset Hills, MOThe acft was on a ngt instructional flt with 2 multi-eng instructor plts at the controls & a rated plt occupying a rear pax seat. The rgt fnt seat occupant was an experienced multi-eng plt with 110 hrs in this make & model; however, his 2NDCLASS med cert was…NTSB LAX85FA156Accident · 3 fatalField investigationFinal reportCessna 152 · Newport Beach, CAThe student plt took off on a dark night in marginal wx conditions with 2 passengers occupying the only passenger seat. About 17 min later, the acft was observed in a low pass over a pier at Newport Beach, CA, flying toward the open ocean. After crossing over…NTSB CHI85LA119Accident · No injuriesLimited investigationFinal reportBeech N35 · Athens, OHFollowing one hour of airwork the instructor and student returned to the airport for a short field landing. The instructor stated that the student lowered the gear on downwind. He stated further that they both checked the gear position indicator on base leg…NTSB MKC85FA060Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Mena, ARThe pilot had been cleared for an instrument approach to themena, Arkansas intermountain regional airport. The airplane impacted a mountain side 8 1/2 miles off course.NTSB FTW85LA120Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Comanche, TXThe non-instrument rated plt flew the acft into rising terrain in a wings level attitude during a period of low ceilingson a dark night. The plt stated he was descending to stay clear of the overcast and never saw the ground. Plt had a total of 80 hrs flt…NTSB NYC85FA064Accident · 2 fatalField investigationFinal reportBeech G90 · St. Mary'S, PAThe acft crashed during a log DME approach. According to ATC the acft crashed after making a procedure turn at the faf. The winds in the area were being called 250 degrees at 10 KTS gusting to 28 knts. A caution on the apch plate has a remark,-'precipitious…NTSB LAX85FJA04Accident · Minor injuriesFinal reportCessna 152 · Laupahoehoe, HIThe acft collided with rising terrain while on a training alt. The student plt was scheduled to proceed to the practice area near puna for this first extended solo flt. At aprx 1200 HST, he returned to general lyman flt, hilo, ha, for touch-&-go landing…NTSB ANC85FA047Accident · 1 fatalField investigationFinal reportPiper PA-31 · Port Heiden, AKThis flt originated near becharof lake and was destined for cold bay. Acft crashed into the side of a mountain at the 7500 ft level, 23 miles left of course. Marginal weather conditions existed including a 35 kt right x-wind. Plt had flown the same route…NTSB NYC85FGT01Accident · Serious injuriesFinal reportCessna 335 · Barrville, PAThe Cessna 335 was making a contact approach when it flew into the ground. The aircraft received substantial damage and the pilot received serious injuries. Winds in the area were reported at 25 knots with gusts to 35 knots. Visual meteorological conditions…NTSB CHI85IA118Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Champaign, ILOzark flt #814 momentarily touched down with the left main landing gear 16 ft off the left side of rwy 31. When 50 ft above minimums during the ILS rwy 31 apch the f/o called rwy in sight. Captain asked for landing lights which the f/o turned on. Captain…NTSB MIA85LA095Accident · No injuriesLimited investigationFinal reportCessna 411A · Merritt Island, FLAccording to the CFI on board, rotation was accomplished at 110 KTS. Shortly after takeoff the nose of the acft began drifting to the right and the acft began settling to the rwy. The CFI called for gear up and the acft settled to the rwy on its belly in the…NTSB MKC85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Bentonville, ARDuring the landing approach, the plt stated, he probably forgot to extend the landing gear. Inspection of the acft revealed no mechanical problem with the landing gear extension or retraction mechanism. A test of the landing gear system showed it to work…