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 LAX83FA188Accident · 2 fatalField investigationFinal reportCessna 182RII · Casa Grande, AZThe acft collided with a lone mountain while in straight & level flight.NTSB LAX83LA189Accident · Serious injuriesLimited investigationFinal reportRockwell A-9B · Marana, AZThe plt was on a flt from quanah, TX to chandler, AZ to deliver the acft for a sale. He had been on the ferry flt for 6 hrs when he landed at Marana, AZ. After refueling, raising the eng cowl, inspecting the eng & wiping off an accumulation of oil, he took…NTSB FTW83LA181Accident · No injuriesLimited investigationFinal reportCessna 320D · Carlisle, ARA private pilot was receiving multi-engine training from a CFI when the accident occurred. The CFI pulled the right throttle back for engine out training and the acft proceeded around the traffic pattern. The pilot thinks he moved the gear selector from up to…NTSB NYC83FA091Accident · Serious injuriesField investigationFinal reportCessna 172H · Liberty Corner, NJInvestigation revealed that the plt and passenger arrived at the airport at approximately 1820 EST, requested a special VFR clearance and when that clearance could not be approved requested an IFR flight plan. Attempts to activate the IFR flight plan were…NTSB LAX83FJA06Accident · 1 fatalFinal reportGrumman American AA-5B · Waimanalo, Oahu, HIThe acft was observed maneuvering over the water at low altitude prior to impact with the water. A surviving pax stated that he & the plt had a big party the day before the flt & they both had hangovers the following morning. He further stated that they had a…NTSB DEN83FA090Accident · 2 fatalField investigationFinal reportCessna 150M · Kanab, UTThe acft departed page at about 1150. At about 1238 the acft struck the south slope of a 6,280-FT canyon wall at about 6,000 ft MSL. The canyon is one of a series of about five 'finger' canyons forming the vermilion cliffs group. Sigment lima 15 in effect…NTSB MIA83FA106Accident · Serious injuriesField investigationFinal reportBell 47G2 · Homestead, FLAccording to the pilot he made a normal crosswind approach for landing, nearing ground at about 4 or 5 feet AGL. In extremely gusty weather, the aircraft struck the ground first, went vertical about 10 or 15 feet then lost lift and dropped to ground hard,…NTSB MIA83LA105Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ocala, FLThe acft collided with the terrain while on a localizer 36 approach at Ocala, FL the weather was IMC and the flight was on an IFR clearance. The acft was damaged but the occupants were not injured. The pilot stated that while on the final segment of the…NTSB SEA83LA086Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Waverly, WAThe pilot was on an aerial application mission spraying dry fertilizer on an upslope when he encountered a downdraft. Heturned downslope as the acft settled but was unable to prevent ground contact. The acft contacted the soft terrain and nosed over to an…NTSB DCA83AA021Accident · Serious injuriesFinal reportBoeing 737-2H4 · Casper, WYAcft touched down with all landing gear retracted. The gear handle was found in the neutral position. The first officer was distracted by an inop aps and both the captain and the first officer were distracted by a GPWS aural warning on final apch.NTSB ATL83FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Crossville, TNThe aircraft crashed into hinch mt at the 2700 foot level during cruise flt in IMC weather. The pilot was informed during the initial and subsequent briefings that VFR flt was not recommended for his route. The first leg of the flight from new orleans to…NTSB LAX83FA396Accident · 1 fatalField investigationFinal reportCessna 182 · Littlefield, AZThe passenger stated the flt was behind schedule, and an airport thought to be tuweep was spotted. They descended to 150-200 ft to read a sign and when the plt tried to climb in a left turn he collided with rising terrain. The accident location is about 8…NTSB MIA83LA087Accident · No injuriesLimited investigationFinal reportHughes 269A · St. Petersburg, FLThe helicopter contacted the ground with a skid during a hover and ended up in a dynamic roll over. This was a dual instructional flt and the student was at the controls in a hover at the runways end awaiting twr instructions when the right skid became stuck…NTSB MIA83LKA02Accident · Serious injuriesFinal reportCessna T210 · Lajas, PRThe acft crashed on landing on an off-airport field. 700 lbs of marijuana were found on board.NTSB CHI83FA139Accident · No injuriesField investigationFinal reportBeech 58 · Miwaulkee, WIThe plt reported that he noted a fairly loud sound as the landing gear locked in the up position. Later, he was unable to extend the gear with either the normal or emergency systems. The circuit breaker would pop each time he tried the normal system. The…NTSB CHI83FA138Accident · No injuriesField investigationFinal reportPiper PA-601P · Wheeling, ILAfter making an ILS approach to rwy 16, the plt was cleared to circle and land on rwy 34. As he turned final, he was to the west side of the runway and was too high to land, so he made a left turn-around back to rwy 34. Tower personnel turned the rwy lights…NTSB ATL83FKJ03Accident · 1 fatalFinal reportEaa Biplane P-2 · Southside, ALThe pilot was performing aerobatics over the airport at 400-500 feet AGL. On the last pass, he had completed one roll and was inverted in what appeared to be a second roll when the aircraft dove at the ground in a near vertical position. The aircraft engine…NTSB LAX83LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Daggett, CAThe plt & her copilot/navigator were participating in a x-country air derby. After making a required fly-by at the barstow-dagget arpt, they turned southeast to continue on course. A short time later, about 6 mi southeast of the arpt, the plt determined that…NTSB LAX83FA141Accident · 2 fatalField investigationFinal reportRyan Navion A · Fiddletown, CAThe acft crashed into hilly terrain while descending to enter the traffic pattern at the rancho murieta airport. The pilot had called sacramento fss to get assistance in locating this arpt which is about 11 NM from sacramento VOR on a bearing of about 65…NTSB LAX83FA144Accident · 2 fatalField investigationFinal reportCessna U2061 · Pt Reyes, CAThe Cessna U2061, purchased that day by the occupants, collided with trees on a hillside 10 miles from pt. Reyes, CA. An eyewitness observed the aircraft flying into worsening weather at 500 AGL or lower under a thin cloud layer in the olema valley. During…NTSB FTW83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Canton, TXThe plt reported that during arrival, he started to land with a right crosswind at 15 gusting 22 KTS. He stated that the acft was very low over the runway when a gust of wind blew it over a plowed area adjacent to the runway. He applied full power, raised the…NTSB ATL83FA127Accident · 1 fatalField investigationFinal reportDouglas B-26C · Hubbards Fork, KYThe plt & acft had been fighting forest fires earlier in the day. A late developing fire necessitated another dispatch. The acft arrived on scene & checked in with the lead acft circling overhead coordinating the fire fighting efforts. The tanker made 2 runs…NTSB SEA83LA059Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Near Oakridge, ORAccording to the pilot, a 250 lb load on a 30 ft external line had been set down at a site at an elevation of about 3500 ft MSL. After the load was released, the pilot attempted to transition from a hover to a climb, but the helicopter began to settle.…NTSB LAX83FA350Accident · 5 fatalField investigationFinal reportBeech N35 · Mount Shasta, CAThe acft flew into mt reddy at about 9000 ft level. The clouds were as low as 5000 and the mountain tops were obscured. The plts in flt wx briefing contained the advice that VFR flt along his route was not recommended because the mt tops were obscured in…NTSB NYC83LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PAThe pilot reported that he initiated his takeoff from the 1300 ft/blacktop portion of a 2500 ft runway. The remainder of the runway was sod. He stated that he rotated for takeoff about 50 ft from the end of the blacktop portion at 56 to 58 KTS. Also, he…NTSB NYC83LA064Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Pittstown, NJThere were 2-3 ft snowbanks on the sides of the rwy. At the end of the landing roll the left wheel caught the edge of a snowbank causing the acft to swing into the snowbank & tip over.NTSB FTW83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Chandeleur Isl., LAThe plt elected to takeoff on a sandy beach aprx 1800 to 2000 ft long. There was a gradual curve in the beach for most of the takeoff distance. The plt reported that there was debris on the beach that was too heavy to move, which he had to dodge with less…NTSB DEN83LA065Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Madison, SDThe aircraft collided with a snowbank 10 feet beyond the threshold during landing. After the accident the pilot reportedthat during the final approach to a landing on runway 32, the left main landing gear contacted a 2 foot high snowbank just beyond the…NTSB ANC83IA045Incident · No injuriesIncident investigationFinal reportCessna 177RG · Anchorage, AKThe acft was intentionally landed gear up due to a failure of the main landing gear actuator bearing. The bearing failed due to fatigue.NTSB DEN83FA062Accident · 2 fatalField investigationFinal reportPiper PA-23F-250 · Moab, UTThe acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An…NTSB DEN83LA061Accident · No injuriesLimited investigationFinal reportCessna 172K · Dove Creek, COThe acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…NTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…NTSB CHI83LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mauston, WIThe acft collided with a frozen lake during a low pass while sight seeing. The pilot stated that he dropped down to 250 feet AGL to see if anyone was fishing and hit a downdraft. The acft descended and made contact with the snow and ice covered lake. The…NTSB LAX83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Davis, CAWhile practicing a simulated single eng condition, the student turned toward the arpt. The instructor (CFI) stated that the student treated the simulated emergency like he would for loss of power in a single eng acft; I.e., he turned to the nearest rwy which…NTSB DCA83IA016Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-50 · Greer, SCAcft drifted to the right before a missed apch was initiated during which it made an inadvertent touchdown & struck a rwy light. The plt erroneously used RVR as his landing minimum. Actual RVR was below the published minimum. The sequenceflasher lights were…NTSB ANC83FA042Accident · 3 fatalField investigationFinal reportBellanca 8GCBC · Melozi Hot Spgs, AKAcft deptd a private airstrip with no flt plan and was later reported overdue. Acft wreckage was found on sept. 27, 1984. Debris was scattered near the bottom of a 1000 ft box canyon cliff. The main fuselage was found in a lake at the bottom of the canyon.…NTSB ATL83LA092Accident · Minor injuriesLimited investigationFinal reportBeech 65-80 · Brodnax, VAThe acft was damaged during a landing in a field at night near the intersection of route 623 & route 53 north. After the accident, 2 individuals were observed leaving the acft & running into the woods with duffel bags. The acft contained aprx 1000 lbs of…NTSB LAX83LA079Accident · No injuriesLimited investigationFinal reportCessna 140 · Mt. Baldy, CAThe pilot reported that while he was flying toward the crest of mt Baldy, he was blinded by the sun reflecting off of the freshly covered snow peak. As he reached for his sun glasses, the aircraft struck the mountain about 10 ft below the crest.NTSB SEA83FA044Accident · 1 fatalField investigationFinal reportCessna P210N · Burns, ORThe plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it…NTSB FTW83LA093Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · Bay City, TXThe guatemalan registered acft collided with the ground while airdropping bales of marijuana on a beach. According to a witness, while the acft was making low passes over the beach the propeller struck the beach tearing it off the acft. The acft then…NTSB ANC83IA034Incident · No injuriesIncident investigationFinal reportCessna 185 · Near Cordova, AKThe acft encountered deteriorating wx conditions and received minor damage during a precautionary landing in whiteout conditions. A SIGMET was in effect.NTSB SEA83FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Portland, ORThe acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…NTSB DEN83FA045Accident · 1 fatalField investigationFinal reportBell 206B III · Sula, MTThe helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…NTSB DEN83LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Vernal, UTThe aircraft made an emergency off-airport wheels-up landing shortly after takeoff. The pilot said all of the pre-flight, before takeoff and takeoff checks were normal. Shortly after takeoff, the aircraft started to lose airspeed. All controls were checked as…NTSB CHI83LA074Accident · No injuriesLimited investigationFinal reportCessna 140 · Springbrook, WIThe acft collided with a four ft snowbank at the rwy threshold during landing. This was a dual instructional flt with the student in the right seat. The CFI had made no landings in this make and model of acft in the previous 90 days. The pilot stated that due…NTSB MIA83FA055Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201T · St. Augustine, FLApproach control advised the flt at the time of the initiation of the approach that weather for the general area was 300 ft overcast, 2 mi in fog. The flt was cleared for the VOR rwy 13 approach. The acft struck trees about 65 ft AGL in an area about 4 mi nw…NTSB MIA83FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Ft. Lauderdale, FLThe aircraft crashed while the pilot was apparently attempting to return to land after takeoff. No radio calls were made, but landing gear had been lowered. High speed and excessive rate of descent are not consistant with a normal or even emergency attempt to…NTSB DEN83FA041Accident · 1 fatalField investigationFinal reportCessna T210M · Robertson, WYThe acft collided with gently rolling snow covered terrain. A small empty plastic medicine bottle labeled nadalol was found at the wreckage. Nadalol is used to control dizziness, fatigue & mental depression, & is basically a beta blocker. According to the…NTSB MKC83FA045Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Dubuque, IAAt 2015 the flt contacted ARTCC & requested Dubuque wx. They were advised that Dubuque was 500 ft indefinite ceiling, sky obscured, visibility 1/2 mi fog & they would be vectored for a back course rwy 13 apch. The flt then requested the front course apch to…NTSB ATL83FLG03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Cleveland, SCThe plt stated he was VFR on top of a broken cloud layer & decided to descend through an opening. After descending clear of the clouds he was in a pass with hills on each side & not enough room to turn around. He continued north along the highway hoping the…