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 LAX83LA431Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Marysville, CABoth aircrew members were multiengine rated. One was a multiengine instructor pilot (CFI) & was providing instruction for the other to be upgraded as a multiengine instructor. During a landing, the acft touched down with the gear retracted. Neither pilot…NTSB CHI83FA419Accident · 1 fatalField investigationFinal reportWarren Moneri S · Lapeer, MIThe glider collided with the ground after an unscheduled tow release at about 150 ft AGL.this was the plts first flt in this acft after having the engine removed and the acft recertified as a glider. Ground personnel observed the glider and tow pilot release…NTSB ATL83LA349Accident · Serious injuriesLimited investigationFinal reportJohnston Long E-Z · Pell City, ALThe acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff…NTSB ANC83FA161Accident · 3 fatalField investigationFinal reportBellanca 7GCBC · Kasilof, AKThe acft crashed in a vertical nose down attitude a short distance from the plt's private airstrip. According to relatives the plt was taking his girl friend's 2 children for a short flt. Investigation revealed the plt's last known medical certificate was…NTSB MKC83LA210Accident · No injuriesLimited investigationFinal reportCessna 188A · Klemme, IAThe acft inadvertently descended into the tops of a corn crop while dispensing smoke in preparation for spraying. The induced drag slowed the acft and it landed hard. The plt stated he diverted his his attn to the spray nozzles.NTSB CHI83FA407Accident · 2 fatalField investigationFinal reportCessna 152 · Anoka, MNThe plt rented the acft & reported that he & his friend would be going on a local flt. A witness stated that he saw the acft fly over at an estimated 1000 to 1500 ft AGL. Reportedly, the acft was in level flt when the plt 'cut' the power, the acft 'nosed up a…NTSB SEA83LA192Accident · No injuriesLimited investigationFinal reportCessna P210N · Wenatchee, WAThe plt was practicing touch & go landings. After completing 2 touch & go's, he elected to practice a smiulated forced landing. He reported that he lowered the landing gear when the acft was on a downwind leg. However, the plt did not report whether or not…NTSB DEN83FTE12Accident · Serious injuriesFinal reportPiper PA-25-260 · Lamar, COThe acft collided with the ground during an aerial application maneuver. The pilot stated that he finished the second spray run and while in a turn the acft hit the ground on flat terrain. The pilot stated that he did not remember anymoreabout the flt. A fuel…NTSB NYC83FGM05Accident · 1 fatalFinal reportCessna 152 · Butler, PAThe acft crashed on approach to the final destination arpt after completion of a multi-legged x-ctry flt in foggy weather. The flt had 5 enroute stops which entailed 6 takeoffs and climbs during 3.6 hours. According to the FAA the acft contained 5 or 6…NTSB MKC83LA202Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Wayne, NEThe acft collided with the ground during an aerial application maneuver. The pilots attention was diverted when he was looking for 3 wheel vehicles so he 'wouldn't spray them'. He did not realize that a hill was in his path and could not pull-up soon enough.NTSB FTW83LA400Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXAt 1500 ft AGL the instructor plt pulled the mixture ctl to the off position to give the stu plt a practice fcd lndg. When near the gd the instructor pushed the mixture ctl to full rich but was unable to get the eng restarted prior to gd contact. There was no…NTSB SEA83LA194Accident · No injuriesLimited investigationFinal reportEnstrom 280C · N. Hailey, IDThe plt reported that during takeoff from a county road (elevation 5500 ft), he allowed the RPM to drop 'below green.' Reportedly, he had a choice of either setting the helicopter down on the road or flying down a slope to gain airspeed. He elected to land on…NTSB MIA83LA211Accident · No injuriesLimited investigationFinal reportCessna 188 · Jay, FLThe plt reported that he tried to take off on a hot day with a heavy lord, but the acft would not perform sufficiently to climb over a drainage terrace at the departure end of the rwy. The acft bumped the drainage terrace & continued flying, but would not…NTSB LAX83LA425Accident · No injuriesLimited investigationFinal reportBoeing E75 · Tracy, CAWhile on a flt to dispense orthene, a fill line began leaking into the cockpit. After dispensing the load & while returning to the landing area at about 30 ft AGL, the plt reached below the seat to check the leak. While he was bending over to locate the leak,…NTSB CHI83FA387Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2A · Waukegan, ILWhile on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…NTSB ATL83FIG06Accident · Serious injuriesFinal reportCessna 150 · Petersburg, WVThe acft was unable to maintain altitude while crossing mountain ridges & stalled about 50 ft above a tree line. The pilots had been using automotive fuel during prefueling stopNTSB MIA83FA207Accident · No injuriesField investigationFinal reportBeech A100 · Vieques, PRThe acft crash landed during a touch and go landing. The plt said that the acft was caught in a windshear or violent downdraft and would not climb. He did not say why he was doing a touch and go landing with 9 passengers on board. The plts account of the…NTSB LAX83FA388Accident · 2 fatalField investigationFinal reportCessna P206B · Kernville, CAThe acft was conducting an aerial search in a box canyon. According to the surviving pax they ran out of room to turn the acft around in the canyon. The acft crashed at the 3,850 ft level. Surrounding mountain peaks are 9,470 ft MSL.NTSB SEA83FYA02Accident · 1 fatalFinal reportPiper PA-22-108 · Nr Jackpot, NVPrior to the accident, the acft was observed maneuvering in the vicinity. Subsequently, the acft collided with the ground while it was being flown under a 40 ft power line. Both of the occupants had student plt certificates that had expired. One of the…NTSB LAX83FA397Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Kernville, CAThe acft crashed in rising terrain 6 mi west of the departure arpt at 5,000 ft MSL. The alta sierra pass is 6,500 ft mslwith mountain tops at 8,320 ft MSL. The plt was issued a student certificate on 8/22/80 which was not renewed.NTSB DEN83LA190Accident · No injuriesLimited investigationFinal reportCessna T188L · Wahpeton, NDThe acft collided with the ground during aerial application turn around. The pilot stated that he looked inside the cockpit during the maneuver to see how much chemical was left. He saw the ground out of the corner of his eye and tried to avoid the collision…NTSB MKC83LA188Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Agency, IAThe plt was engaged in aerial application over a small 9 acre bean field that was surrounded on 3 sides by hedge rows. He reported that as he descended on the leeward side of a hedge row to begin a swath run, the acft encountered turbulence & mushed into the…NTSB NYC83FNC10Accident · Serious injuriesFinal reportPiper PA 28 181 · Baxter State Pk, METhe pilot does not recall any details of the flight after departing montreal. The wreckage was not recovered nor examined.NTSB NYC83FA203Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fishers Island, NYThe plt had called his home base & was told that fog was beginning to move shoreward & that the intended destination, (waterford, CT) would not remain VFR for long. The plts of N6877J & another acft chose to depart immediately. Before arriving, fog had moved…NTSB LAX83FA377Accident · 4 fatalField investigationFinal reportCessna 172 · San Simeon, CAThe acft collided with the terrain while on a pleasure flight for the purpose of sightseeing. The wreckage was found in a box canyon at 3500 ft MSL. Examination of the accident site revealed that the acft impacted on a heading of approx 085 degrees. The…NTSB CHI83FA371Accident · 1 fatalField investigationFinal reportSiai-Marchetti F.260C · Oshkosh, WIThe foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin…NTSB CHI83FA365Accident · 1 fatalField investigationFinal reportCessna 182 · Marseilles, ILThe acft was on a parachute jumping mission. After climbing to 9000 ft MSL, 4 sky divers jumped out & the plt began a descent back to the arpt. The acft was seen level at aprx 500 ft AGL & in the aprx position for a downwind leg for a left pattern for runway…NTSB MIA83LA196Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe student was a rated single eng, multiengine, land plt, but did not have a helicopter rating. During a dual instructional flt, he had just completed the final phase of an autorotation & the skids were on the ground, when he abruptly pulled the collective…NTSB DEN84LA185Accident · No injuriesLimited investigationFinal reportPiper 601P · Billings, MTBefore starting the flt, the acft was loaded with full fuel, 5 adult passengers & aprx 45 lbs of baggage. The elevation & temp at the arpt were 3606 ft & 93 deg. The plt said he did not calculate the weight & balance or density altitude limits for this flt…NTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…NTSB LAX83FUJ15Accident · 1 fatalFinal reportGrau VARI-EZE · Tucson, AZWitnesses observed the acft make 4 low passes, 200-300 ft AGL. On the last pass the acft pulled up ino about a 30 deg nose high attitude & start a right roll. The nose began to drop, & as the roll was completed the acft was in about a 80 deg nose low, wings…NTSB CHI83FA347Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Muskegon, MIThe acft collided with trees after performing an aerobatic maneuver at low altitude. Witnesses near the scene said the acft was flying low; most heard the engine running. Some said that at the top of a loop the engine sounded like it stopped. On the descent…NTSB MKC83LA170Accident · No injuriesLimited investigationFinal reportMonke Rotec Rally 3 · Nickerson, NEThe acft was a registered, home built, 2 place, ultralight vehicle. The passenger was the plt's friend who was building his own ultralight & wanted to ride along to get a general feeling of how to land this type of acft. The plt reported that the temp was 86…NTSB LAX83FA371Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasanton, CAThe acft crashed in a steep nose down attitude in hilly terrain. Debris was scattered for about 100 ft but the acft did not travel after initial impact. The fuel tanks were ruptured and no fuel remained. The sheriff's deputies said no odor of fuel was noted…NTSB ANC83FA137Accident · 1 fatalField investigationFinal reportGrumman G-44A · Big Lake, AKThe acft crashed in a level, wooded area. The initial impact with trees occurred aprx 40 ft AGL. Both wing tips & a portion of the left stabilizer & elevator were found at the bases of the trees that were first impacted. From the first impact point, the…NTSB LAX83LA369Accident · No injuriesLimited investigationFinal reportCessna T210N · Glennville, CADuring a landing, the acft touched down with the gear retracted. It came to rest with the gear handle in the down position, the amber warning light illuminated, and the gear motor circuit breaker disengaged.NTSB ATL83LA304Accident · No injuriesLimited investigationFinal reportCessna 150J · Monroe, GAAfter turning final approach the pilot realized he was high so he lowered full flaps. Shortly thereafter he saw that the indicated airspeed was low and made an aircraft attitude adjustment. After he corrected for the low air speed he failed to rotate to a…NTSB ANC83FA133Accident · No injuriesField investigationFinal reportCessna 177RG · Anchorage, AKDuring arrival, the acft was landed with the gear retracted. After touchdown, it slid appx 980 ft before coming to rest. The pilot stated that after he was cleared to land, he was looking for other VFR traffic & forgot to extend the gear. Reportedly, he did…NTSB DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…NTSB FTW83LA348Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marshall, TXThe aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…NTSB ATL83LA288Accident · No injuriesLimited investigationFinal reportCessna 310Q · Fredricksburg, VAThe acft crashed and burned during a go-around after touching down on the rwy at about the 1500 ft point on a 3000 ft rwy. The right propeller was feathered. The pilot was attempting a single engine practice landing and believed he could not stop on the rwy…NTSB SEA83LA158Accident · Serious injuriesLimited investigationFinal reportBensen B8M · Wenatchee, WAReportedly, the plt had received 7 hrs of dual instruction in the benson gyrocopter. He had been observed taxiing the acft on an unused portion of the arpt during the winter months of 1982 & 1983. However, no flts were observed & the student plt had no…NTSB DEN83LA174Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Salida, COThe acft crashed into a mountain in a controlled crash situation with full flaps and full power at the 11,312 ft level the density alt was computed to be 12,370 ft MSL. The plt was aware that the weather was questionable in some areas of his route and the…NTSB DEN83LA173Accident · No injuriesLimited investigationFinal reportMooney M20J · Aurora, COThe arpt had one asphalt rwy that was closed & another dirt rwy that was muddy. Therefore, the plt elected to takeoff on the parking ramp which was oriented in a north/south direction & was 1700 ft long. The plt did not consult the takeoff charts in his…NTSB LAX83IA345Incident · No injuriesIncident investigationFinal reportCessna 411 · Huntington Bch., CAPilot inadvertantly landed with gear up due to the distraction of making a short field landing.NTSB DEN83LA166Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Thompson, NDThe acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left…NTSB LAX83FA333Accident · 1 fatalField investigationFinal reportRolladen-Schneider LS3-A · Bishop, CAThe glider plt was participating in a soaring contest which involved a quadrangle course. While enroute to the 1st turn point with 2 other sailplanes, the plt was observed to depart from the general flt path of the other 2 gliders & fly on the leeward side of…NTSB CHI83LA315Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-36 · Ionia, MIThe glider struck the ground on the nose during the appraoac. The plt stated that nose pitch oscillations were due to his overcontrolling the glider because of his lack of experience in the glider's pitch sensitivity.NTSB LAX83LA327Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Roosevelt, AZThe acft collided with rising terrain during climb to cruise. According to the pilot the flt departed from an arpt wherethe elevation is 2361 ft. the flt proceeded toward nearby mountains whose elevation is about 5000 ft MSL. The acft rate of climb was about…NTSB MIA83FA175Accident · 2 fatalField investigationFinal reportLong EZE · Near Captiva, FLA witness observed the aircraft flying in a northerly direction about 1/2 mile away at an altitude of about 100 feet. It appeared to be travelling in excess of 80 KTS and the engine sounded normal. Another witness observed the aircraft strike the water in a…