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 SEA83FA139Accident · Serious injuriesField investigationFinal reportCessna 182Q II · Near Peak, ORThe acft collided with rising terrain as the pilot tried unsuccessfully to avoid the trees and ridges. The two rear seatpassengers reported that they flew up a canyon at about 6500 ft MSL. The ridges on either side were as high as the acft. The pilot was seen…NTSB CHI83LA284Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Crane Lake, MNThe plt reported that while he was taking off on an easterly heading, the float plane was on the step & became airborne sooner than he expected. While he was correcting the stituation by lowering the nose, the left float dug into the water. Subsequently,…NTSB ATL83FAMS1Accident · 2 fatalMissing aircraftFinal reportPiper PA-24 · Fleeton, VAOn July 2, a main landing gear, identified by the FAA as part of N7284P, was found floating in the chesapeake bay. The body of the deseased passenger was located on July 9, 1983 in the bay. Investigation revealed no record of communicationbetween the acft and…NTSB MIA83FA168Accident · Serious injuriesField investigationFinal reportBeech V35A · Lehigh Acres, FLAccording to the pilot he started to make a go around after he realized that he would not be able to stop the aircraft on the wet runway. He failed to gain sufficient altitude to clear the trees just beyond the airport boundary. He said he landed at the…NTSB ATL83LA241Accident · Minor injuriesLimited investigationFinal reportCessna 152II · Kilmarnock, VAThe pilot decided to make a practice landing enroute. The arpt had a wet grass rwy and when the acft skidded during landing the pilot initiated a go-around. He had forgotten the proper positioning of the flaps during the landing approach until reminded by the…NTSB CHI83LA274Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled.NTSB LAX83LA291Accident · 1 fatalLimited investigationFinal reportBellanca 17-31A · Ducor, CAThe acft crashed into the side of a hill at 1900 feet MSL while on a photographic mission. The top of the mountain that was struck is 2412 feet MSL. The pilot was fatally injured in the crash and ground fire following impact. According to his secretary he was…NTSB FTW83FA280Accident · 3 fatalField investigationFinal reportBell 206B III · Eugene Isl.BlkThe helicopter was used to shuttle pax & supplies between various oil drilling platforms & was en route between two islands when the accident occurred. Wreckage was spotted 6 miles west of the destination island. Only the pilot's body was retrieved & 2 pax…NTSB CHI83LA260Accident · No injuriesLimited investigationFinal reportCessna 210 · Bryan, OHThe acft main landing gear collapsed during landing. The nose gear never came down. The pilot stated the approach was long and flat. The 'stall warning beeped a couple times. On flare horn came on.' The landing gear was tested for extension/retraction with no…NTSB LAX83FA287Accident · Minor injuriesField investigationFinal reportBell 206B · Temecula, CAThe plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…NTSB CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…NTSB ATL83LA223Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Ashburn, GAThe plt was participating in a soaring contest & was on a round robin course from cordele, GA to perry, dawson, sylvester & back to cordele. On the return leg, there was insufficient lift to complete the trip, so an alternate landing site (wheat field) was…NTSB ATL83LA217Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Shinnston, WVThe instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a…NTSB SEA83FYK04Accident · 1 fatalFinal reportHomebuilt Christen Eagle II · Bend, ORUpon completion of his routine during an airshow, the plt stated to the show announcer that he would do a low pass down the rwy followed by a vertical climb to a hammerhead stall & then into a lomcevak aerobatic maneuver. This maneuver is aclimbing outside…NTSB LAX83LA286Accident · No injuriesLimited investigationFinal reportJohnson VARI-EZE · Palo Alto, CAThe pilot stated that in an attempt to improve his landings and reduce the landing roll, the airspeed on final was 10 mph less than normally used. He was also attempting to touchdown on the numbers at the threshold. The acft's landing gear struck a small dike…NTSB LAX83FUM06Accident · Serious injuriesFinal reportCessna 172RG · San Clemente, CAThe acft crashed on San Clemente island during a fish spotting flt on a dark night. These flts are usually flown at an alt of 1000-2000 ft AGL. A navy witness on the accident island said the ceiling was zero and the visibility about 200 yards at the accident…NTSB LAX83LA272Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Temecula, CAThe student & instructor (CFI) were on a dual instructional flt in preparation for the student's 1st solo flt. After returning from flt in the local area, they entered the traffic pattern to land on rwy 12. During a final apch to land, the student flew the…NTSB LAX83FVG12Accident · 1 fatalFinal reportYarnell Grass Hopper · Redding, CAThe acft crashed into steep mountainous terrain under unknown circumstances. The wreckage was 50 feet below a ridge line in deep brush. The engine and nose section were buried to the firewall. Eight inches of one prop blade showed aboveground and revealed no…NTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…NTSB DEN83FTE09Accident · 1 fatalFinal reportLink-Johnson-Chessman HP-16 · Eldorado Sprgs., COThe glider crashed into a mountain while maneuvering during VMC weather. The pilot was fatally injured. The glider impacted the face of bear peak mountain near the 7900 ft. level. The fuselage was crushed the wings separated and the pilot, who had undone his…NTSB NYC83FA130Accident · 1 fatalField investigationFinal reportNorth American AT-6C · Westfield, MAThe airline transport rated plt was on a low level, aerobatic waiver, competency check flt. He was scheduled to demonstrate a loop, an aileron roll, a split-s, an immelmann, a barrel roll & a 4-point hesitation roll. The minimum alt for these maneuvers was to…NTSB FTW83LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kaplan, LAWhile departing from a private strip, the plt took off to the north in calm winds. When he returned to land, the wind had begun blowing from the southwest at 20 KTS; thus, he elected to land toward the south. A truck was parked at the apch end of the strip,…NTSB NYC83FNC04Accident · Serious injuriesFinal reportMcdonald Steen Skybolt · Milan, NHThe purpose of the flt was preparation of an act for some planned air shows. The pilot maneuvered the acft into an inverted spin at an alt of 2000 AGL. After 3 revolutions of the spin he was unable to recover and the acft impacted the ground inverted.NTSB FTW83IA258Incident · No injuriesIncident investigationFinal reportBeech 200 · Eagle Nest, NMAcft inadvertently landed with gear up due to multiple distractions.NTSB CHI83LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Delphi, INDuring a local flt, the plt noticed clouds that looked like smoke approaching the arpt from the west. He stated that he decided to land to keep from losing visibility. The plt stated that while approaching rwy 18 with a x-wind from 270 deg, he had to crab to…NTSB FTW83FA250Accident · Serious injuriesField investigationFinal reportEvans VP-1 · Friendswood, TXThe acft collided with the ground during a tight steep turn at low (100 ft) alt. Witnesses reported that the eng was running well and that after flying the length of the rwy at low alt the plt made a steep left turn and crashed. Witnesses said the plt had…NTSB ANC83LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Glennallen, AKReportedly, the plt & passenger had worked a long day before going to their respective homes to attend household chores. Later, they met, and reportedly, they consumed food & beer. Eventually, they arrived at the location of where the plt's plane was parked.…NTSB LAX83LA252Accident · No injuriesLimited investigationFinal reportCessna 170B · Yreka, CAThe plt landed at the montague arpt for fuel, but fuel was not available, so he proceeded to rohrer field where 18 gal was onloaded. During takeoff with a density alt of aprx 4200 ft, he lifted off after using aprx 2/3 of the 3360 ft rwy. He reported that at…NTSB CHI83LA226Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Lansing, MIThe plt was participating in the national 15 meter championship meet. During a triangular course, he ran out of thermal activity & selected a field for a landing. From the air, he thought he had selected an alfalfa field with a 5 to 6 inch growth. However, he…NTSB ATL83LA191Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Wise, VAThe plt reported that he had stayed in the local area & had been practicing slow hover over the grass beside the rwy. There was a paved ramp that he had to cross, each time he went from one end of the rwy to the other. He said when he came to this area, he…NTSB FTW83LA241Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Edna, TXThe acft collided with a dirt bank while spraying due to reduced visibility from spray on the windshield. After the collision the plt regained control of the acft and flew back to jackson county arpt. There he made a dead stick landing on a flat area adjacent…NTSB SEA83FA095Accident · 1 fatalField investigationFinal reportMooney M20 · Edmonds, WAThe plt had earlier visited his fiancee. She stated that he was intoxicated & she gave back her engagement ring to him. He was later observed departing the arpt. Shortly thereafter police began receiving complaints of a low flying acft overthe beach area. The…NTSB MIA83LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Ocean Way, FLThe acft collided with the muddy bank of the intercoastal waterway during the 2nd of two low passes and nosed over when the nose gear dug in. Witnesses report seeing the acft pass at a low altitude. The pilot stated that while flying at lowalt he heard a loud…NTSB CHI83LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · East Liverpool, OHDuring the approach, the plt neglected to extend the gear, aand subsequently, made a wheels up landing.NTSB CHI83LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Mora, MNThe acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…NTSB CHI83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Minonk, ILThe plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from…NTSB FTW83FA222Accident · 1 fatalField investigationFinal reportCessna 170B · Iraan, TXAccording to a truck driver, he was proceeding northbound on a highway, when he saw the aircraft enter what he described as a loop from aprx 100 ft AGL. The witness then lost sight of the acft, but shortly after that, he saw a large explosion on the ground…NTSB LAX83LA209Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Chula Vista, CAThe plt reported that he was soaring along the west slope of a small mountain when he inadvertently entered an area where the wind was obstructed by terrain features. His airspeed deteriorated & he tried to turn toward an area where he could obtain lift.…NTSB FTW83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Krum, TXThe acft collided with the ground during a simulated forced landing and go-around. The acft's left main landing gear wassheared and the left wing dragged during ground contact. The CFI had given the student a simulated forced landing during the approach and…NTSB SEA83LA092Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Lakeview, ORThe acft had landed earlier at redmond in what was described as a hard landing. The plt stated the only problem noted was a 'loud squeeking brake' during the rollout. The next leg of the flight was to terminate at reno, but the plt landedat Lakeview to wait…NTSB MKC83LA096Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Minatare, NEThe plt reported that he was making a low pass to look over a possible landing area, when he allowed the acft to inadvertently touch down on soft soil beside the strip. The acft bounced, then landed hard and the main gear collapsed.NTSB CHI83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Havana, ILThe aircraft collided with the ground during an attempted go around when the pilot stated that he did not see but two ofthe landing gear lights on. The approach was to runway 9 in a crosswind from 170 degrees at 18 KTS with gusts to 24 KTS the pilot described…NTSB ANC83FA075Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Soldotna, AKWitnesses observed the acft maneuvering erratically near the arpt & anticipated the accident. The 1st approach to rwy 25WAS described as erratic with minimal apparent control which included an abrupt pull-up, stall, bounce, & go-around in aleft pattern at 300…NTSB SEA83FA087Accident · 3 fatalField investigationFinal reportCessna 172P · 2nm E. Of Blyn, WAThe plts had received a wx briefing from seattle fss earlier in the day for a flt from seattle to port angeles. Due to the time span between arrival & departure at port angeles, the wx briefing was not valid for the return flt. The acft impacted the west…NTSB FTW83LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Odessa, TXThe acft was substantially damaged during a gear up landing. The pilot stated that the gear handle was put down on base leg and he had 3 green lights. He does not recall hearing a gear warning horn. When the acft was transported to a hangar the gear was up…NTSB CHI83LA175Accident · No injuriesLimited investigationFinal reportHughes 300C · Hollandale, MNThe pilot said 'that upon takeoff from truck, pulled too much power so he lost too much RPM, hit somewhat solid ground, slid 10 feet and stuck in the mud, the helicopter stopped immediately and flew apart.'NTSB DEN83FTC02Accident · 1 fatalFinal reportPitts S-15 · Laramie, WYThe acft crashed during a ferry flt in VMC wx conditions. While in formation with two other acft N6CQ was observed to pull up to a near vertical climb, reverse course and disappear. Found near the maneuver location, the acft struck the ground in a nearly…NTSB CHI83LA171Accident · No injuriesLimited investigationFinal reportBeech F33A · Peoria, ILPlt forgot to lower landing gear.NTSB MKC83LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · Axtell, NEThe plt reported that he began taking off on a 1310 ft rwy that was dry but spongy. The elevation was reported as 2210 ft, the wind was calm, and the temperature was 55 deg. The flaps were set at 10 deg. Reportedly, the acft lifted off, but settled back to…NTSB FTW83LA188Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Little Rock, ARThe pilot reported that prior to glide slope interception he placed his hand on the landing gear selector switch and was simultaneously told to contact the tower, which he did. As the acft approached the threshold, the throttles were retarded and props pushed…