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 MKC82DA072Accident · No injuriesFinal reportPiper PA-18 · North Loup, NEThe pilot stated that the aircraft broke ground about 1000 feet down the runway but would not climb. The pilot attempted to jettison the load but did not have time. The aircraft was landed in rough terrain. Investigation revealed that the aircraft was below…NTSB DEN82DA079Accident · No injuriesFinal reportCessna 402A · Bismarck, NDThe pilot discovered that the gear would not extend electrically. Manual extension was attempted, but the crank would not turn in either direction. While applying pressure to the cranks, the chain drive failed. The plane was landed with the gear retracted.…NTSB NYC82DA084Accident · No injuriesFinal reportBeech 35-33 · Altoona, PAThe pilot stated that before landing, he performed his cockpit duties and put the gear in the down position. However, he lost sight of another aircraft in the traffic pattern and became preoccupied with trying to locate the aircraft. He was also preoccupied…NTSB FTW82FRG28Accident · Serious injuriesFinal reportMooney M20A · San Antonio, TXDuring arrival, the pilot entered the traffic pattern for a landing on runway 30 with a 7 knot tailwind. On final approach, he was not satisfied with his pattern and elected to go-around. During the go-around and climb, a map and checklist fell into the…NTSB ATL82FKG13Accident · 2 fatalFinal reportGreat Lakes 2T-1A-2 · Thomson, GAPrior to the accident, witnesses observed the aircraft while aerobatics were being performed. One witness estimated that the maneuvers were being flown between 100 and 300 yards AGL. Reportedly, the aircraft had been performing rolls, loops and spins for…NTSB ATL82DA120Accident · No injuriesFinal reportCessna 150 · Paducah, KYWhile performing a practice emergency landing the pilot stated that he applied full power when the aircraft had descended to about 10 feet above a plowed field. After power was applied the flaps were raised from full down to 20 degrees. The second pilot…NTSB FTW82FPD11Accident · 1 fatalFinal reportCessna 152 · Carswell, TXAn instructor pilot and a passenger (a student pilot) departed north richland hills, TX at about 1700 hrs. The instructor flew to a recreational area and landed in an open nearby field. He gave airplane rides to various persons for about 1 1/2 hrs then parked…NTSB NYC82FHD10Accident · No injuriesFinal reportCessna 210B · Toms River, NJThe plt reported the acft was laboring after takeoff from atlantic city. He decided to circle the field (badger) prior to continuing on to northampton, MA. Upon reaching 3,000 ft he stated the acft again started losing airspeed although the power indicated…NTSB NYC82DA079Accident · No injuriesFinal reportPiper 601P · New Castle, PAA witness who observed the accident stated that he saw N31EH on a very close right base at 150-200 ft above the ground. The aircraft was moving at a rapid rate of speed and was in a very steep right turn. As the aircraft got closer to the runway it became…NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…NTSB MIA82DA112Accident · No injuriesFinal reportBeech 95-B55 · Gainesville, FLThe purpose of the flight was to give dual instruction to the owner/student whose multi-engine rating was limited to centerline thrust models. The student was flying the aircraft on the takeoff roll when the cockpit door became ajar. The aircraft was near…NTSB LAX82DA146Accident · 1 fatalFinal reportPiper PA-38-112 · Apple Valley, CAWitnesses observed the aircraft to be gliding on final approach with the engine at idle when it abruptly pitched nose down and struck the ground. The engine and both leading edges of the wings contacted the ground at the same time with no turning movement.…NTSB CHI82DA129Accident · Minor injuriesFinal reportHughes 269A · Lowell, MIDuring the first solo flight in a helicopter the pilot was instructed to make three normal takeoffs and landings. On the second landing, when the aircraft came to a hover, the back of the skid struck the ground during a drift-back. The helicopter rolled and…NTSB ATL82FA110Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Lafayette, GADrg the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & poor visibility. The plt responded he had to go to ft. payne VFR because they have no instrument approach. A jeppesen us (lo)29 low alt enroute chart was found at…NTSB SEA82DA055Accident · No injuriesFinal reportHughes 500C · Darrington, WADuring an approach to a 9100 foot high snow covered landing site the wind shifted to a tailwind condition. The pilot elected to continue and attempted a skid on landing. While skidding through the snow the left skid impacted rising terrain underneath a 12…NTSB LAX82FVG20Accident · 1 fatalFinal reportSmith Miniplane DSA-1 · Chicago Park, CAThe aircraft crashed while the pilot was performing aerobatic maneuvers at low altitude. The impact occurred just below the top of a ridge at the edge of a valley as the pilot was completing a loop. He was performing the loop perpendicular to the ridge, and…NTSB SEA82FYP07Accident · Serious injuriesFinal reportBeech 77 · Richland, WAWhile flying over a government reservation at night, the aircraft struck the side of a mountain about 1000 ft below the mountain top. A seat belt "d-ring" failed and the pilot went through the windshield when the aircraft struck a slope of about 60 degrees.…NTSB LAX82DA138Accident · No injuriesFinal reportRobinson R-22 · Perris, CAAfter refueling with 12.9 gallons of fuel, the pilot took off with one passenger on board. The pilot stated that after lifting off with 104% prm, he began a normal shallow takeoff with 25 inches of manifold pressure. He reported reaching about 75 ft AGL and…NTSB ATL82FA104Accident · 4 fatalField investigationFinal reportCessna 210-5 · Hendersonville, NCThe aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound…NTSB MIA82DA094Accident · No injuriesFinal reportPiper PA-23-250 · Jacksonville, FLImmediately after raising the gear handle during takeoff, the pilot heard a loud noise that he thought was an explosion. He aborted the takeoff and landed on the remaining runway without extending the gear. The loud noise occurred when the cabin door popped…NTSB LAX82FA134Accident · 3 fatalField investigationFinal reportCessna 182M · Lake Hughes, CAThe pilot requested the en route weather conditions at 1545, 1625, 1732 and 2150 PST from the bakersfield fss. The pilot was informed, on each occasion, that VFR flight was not recommended; however, at 2213 the pilot departed bakersfield. No flight plan was…NTSB ANC82DA034Accident · No injuriesFinal reportPiper PA-32 · Montague Island, AKDuring a takeoff from Montague Island, Alaska, the aircraft collided with snow and willows beyond the departure end of a small strip at mccleod harbor. The pilot reported that just as he started to rotate the aircraft for takeoff, the right gear encountered a…NTSB SEA82DA050Accident · No injuriesFinal reportBell 47G-2A · Lyle, WADuring takeoff with a load of fertilizer, insufficient power was available to maintain engine and rotor RPM and sustain flight. The pilot dumped the load, but was unable to avoid ground contact. The tail rotor struck first and separated from the aircraft. The…NTSB LAX82FUG09Accident · Serious injuriesFinal reportFournier RF4D · Rialto, CAThe pilot reported that when the accident occurred, he was soaring his "motor-glider" in updrafts of "thermal, slope-wind, and wave" origin. He reported that thermals and a weak southwest wind were producing lift along ridges with walls that were facing west,…NTSB ANC82DA028Accident · No injuriesFinal reportCessna 310D · Anchorage, AKJust prior to the mishap, maintenance on the aircraft had been performed. This included work on the cabin heater in the nose wheel well area. After takeoff to ferry the plane to a nearby airport, the nose wheel became jammed as the gear was retracted. The…NTSB LAX82DA122Accident · No injuriesFinal reportCessna 310Q · Yuba City, CAThe pilot reported that he forgot to put the gear down before landing.NTSB MIA82DA086Accident · No injuriesFinal reportCessna 177RG · Jacksonville, FLThe pilot stated that he became distracted by radio communications with the control tower and forgot to lower the landing gear prior to landing.NTSB CHI82FA098Accident · No injuriesField investigationFinal reportBeech 65-A90 · Kalamazoo, MIThe plt heard a grinding noise when he attempted to lower the landing gear. The gear would not extend with either the normal or emergency systems. The acft landed with the gear in the partially extended position. Subsequent to examinationof the nose landing…NTSB MKC82DA049Accident · No injuriesFinal reportCessna 172 · Jetmore, KSThe aircraft was flown out to an oil well site to air drop a valve. The pilot stated that after dropping the valve he turned around in his seat to see where the valve hit and he ran the aircraft into the ground.NTSB NYC82FA059Accident · 5 fatalField investigationFinal reportCessna T210M · Williamsport, PAThe acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading…NTSB NYC82DA061Accident · No injuriesFinal reportLuscombe 8E · Poestenkill, NYThe pilot stated that during landing flare while holding full aft on the control stick the right wing came up and the aircraft drifted left. Full right rudder and aileron were applied but the main gear struck a snowbank along the left side of the runway and…NTSB CHI82FA091Accident · 1 fatalField investigationFinal reportCessna 421 · Richmond, INDuring a VOR approach to runway 05 when 3 miles away from the airport at minimums ground contact was not made. The pilot stated that she elected to perform a missed approach but before power was applied the copilot raised the flaps. She further stated that…NTSB LAX82FUJ32Accident · 1 fatalFinal reportBeech 58 · Tucson, AZThe plt departed phoenix at 0045 for the third leg of a six leg bank run between phoenix & Tucson intl arpt. He was in contact with the phoenix TRACON during departure & was released at the toltec intersection (V16) at 5,500 ft. there was no further radio…NTSB ANC82DA027Accident · Minor injuriesFinal reportBell 206 L-1 · Delta Junction, AKWhile flying at approximately 300 feet AGL in windy turbulent conditions over snow covered terrain,the helicopter impacted the frozen river. At the time of the accident the pilot was changing radio frequencies when impact occurred.NTSB LAX82FXQ06Accident · 2 fatalFinal reportCessna 182 · Lake Tahoe, CAA pilot who landed prior to the departure of N5298N stated that his aircraft had accumulated 1/4 inch of airframe ice while over the lta VOR. An employee of Lake Tahoe aviation fueling service informed the pilot of N5298N of these weather conditions and ice…NTSB LAX82FUG08Accident · 2 fatalFinal reportCessna 210G · Etiwanda, CAThe aircraft struck a ridge at an elevation of about 2000 ft MSL. At the impact point, the terrain sloped upward at an angle of about 35 degrees. The aircraft impacted in a near level flight attitude. The weather at the crash site was not determined. However,…NTSB NYC82FA050Accident · 1 fatalField investigationFinal reportCessna T337C · Bloomfield, CTAt 0630 & 0800 the plt received wx briefing for an IFR flt to bridgeport, CT & was advised of flt precautions for icing, low ceilings & visibilities. The flt departed at 0907. At 1118 the plt diverted to windsor locks for landing at bradley intl arpt because…NTSB MIA82DA067Accident · No injuriesFinal reportBeech 95-B55 · Tallahassee, FLThe pilot failed to extend the landing gear during practice full stop, taxi back, takeoff and landings.NTSB NYC82FNA11Accident · Minor injuriesFinal reportVarga 2150A · Marlboro, MASnow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading…NTSB FTW82FPM11Accident · 2 fatalFinal reportCessna 172 · Heavener, OKThe aircraft crashed at night on rising terrain about 300 ft below the crest of a hill. The nearest weather reporting station was at mcalester, OK. The weather at mcalester was 1200 ft overcast, visibility 7 miles, ceiling ragged. The mcalester field…NTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…NTSB ANC82DA025Accident · No injuriesFinal reportCessna 180 · Mcgrath, AKThe pilot reported there was no wind on the ground. However,immediately after takeoff he encountered a downdraft which would not allow him to clear trees at the end of the airstrip. Takeoff was on runway 5.wind reported by farewell,AK,located 19MI nw of the…NTSB LAX82FUQ10Accident · Serious injuriesFinal reportPiper PA-28R-180 · Captinteria, CAThe pilot reported that he had some head congestion and had experienced ear discomfort on the first leg of the flight. He elected to fly the second leg of the flight in a canyon that he thought would allow passage through the mountains at low altitude.…NTSB FTW82DA086Accident · No injuriesFinal reportSchreder RS-15 · Hempstead, TXThe pilot reported that he lost directional control on his first flight in this high performance glider. He stated that the right wing began to drag when the runner released it early. He attempted to lift the wing with left aileron and rudder. The glider…NTSB DEN82FTI11Accident · 1 fatalFinal reportCessna TR182 · Livingstone, MTThe plane crashed about six miles west of livingston, Montana. It was found to have struck about 50 ft below a 5300 ft ridge, while in a 20 degree climb attitude. The weather at livingston was: 900 ft broken, 2500 ft overcast, visibility 10 miles, wind…NTSB NYC82DA045Accident · No injuriesFinal reportMooney M20K · White Plains, NYDuring a practice ILS approach ATC requested the flight reduce its airspeed for traffic spacing. The pilot complied and continued the approach with the stall warning horn sounding intermittently. The aircraft landed gear up and came to rest on the centerline…NTSB MIA82DA063Accident · No injuriesFinal reportCessna 310K · Key West, FLThe aircraft was landed with the gear retracted. The pilot reported that he was distracted by another aircraft in the pattern and failed to extend the gear. Also, he stated that pilot fatigue and a head cold contributed to the distraction.NTSB FTW82DA083Accident · No injuriesFinal reportBeech B58 · Hot Springs, ARWhile on final approach to memorial airport the pilot stated that he heard another pilot announce that he was turning right base for landing on the active runway. The pilot on final became distracted while looking for the other aircraft and forgot to lower…NTSB FTW82FQG15Accident · 1 fatalFinal reportPiper PA-36 · Floydada, TXThe aircraft crashed about 500 ft north of the field that was being sprayed. After impact, it traveled about 90 ft on a heading of 060 degrees. Green glass fragments were found at the initial impact point as well as propeller slash marks that were nearby. No…NTSB NYC82DA042Accident · No injuriesFinal reportCessna 172RG · Palmer, MAThe pilot initiated a takeoff on runway 04. He reported the wind was from 300 to 330 degrees at 10 gusting 25 KTS. During the takeoff roll, a bump in the runway was encountered and the aircraft became airborne. The pilot reported that a gust of wind from the…