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 LAX82DA223Accident · No injuriesFinal reportRobinson R22 · Concord, CADuring a landing, the pilot reported that he came to a 3 ft hover then initiated a descent by lowering the collective. He stated that when the helicopter was about 6 inches above the ground, he lowered the collective to complete the landing, and at that…NTSB CHI82DA208Accident · No injuriesFinal reportCessna A188B · Greenbush, MNThe aircraft crashed during takeoff from a grass runway that had not been mowed for several weeks. The field elevation was 1070 ft, the wind was calm, and the temperature and dew point were 62 and 50 degrees. A full flap (20 degree) configuration was used for…NTSB MKC82FCQ10Accident · Serious injuriesFinal reportBeech A35 · Bird City, KSThe pilot entered traffic to land on runway 26 at a private airport with no UNICOM and no usable windsock. He stated that on final approach, the aircraft encountered a gust of wind and rolled to the right. He was unable to recover. The right wing hit the…NTSB CHI82FA206Accident · 1 fatalField investigationFinal reportMcclary Mong Sport · Cedar, MNWitnesses observed the acft enter a steep nose down attitude & slow spiral from which the acft did not recover.NTSB CHI82DA207Accident · No injuriesFinal reportCessna 182RG · Midland, MIWhile taxiing to the wash rack, the pilot decided to make a takeoff and landing. After takeoff, he entered the downwind and observed two other aircraft entering behind him. While maintaining separation from the other aircraft and looking for a flock of birds…NTSB ATL82FLQ06Accident · 1 fatalFinal reportBellanca 8KCAB · Mayfield, KYThe aircraft crashed while the pilot was performing an aerobatic routine at an airshow. After about 7 minutes in an 8 minute act, the pilot performed an 8-point roll at about 200 ft AGL, then pulled up into a hammerhead stall. After a hammerhead turn to the…NTSB LAX82DA216Accident · No injuriesFinal reportNorth American 0-47B · Porterville, CADuring arrival for landing, the pilot was leading a flight of five dissimilar aircraft. After pitching out in a 360 degree, overhead approach, the pilot flew a fairly tight pattern. On base, when he would normally have felt the gear lock in place, his…NTSB SEA82DA084Accident · No injuriesFinal reportBeech B19 · Quincy, WADuring a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled…NTSB MIA82DA133Accident · No injuriesFinal reportBell 47G-4 · N. Greenville, FLThe pilot took off at about 1922 to dispense a non-toxic liquid chemical and fertilizer on a nearby melon field. After one normal swath run on a northerly heading, he pulled up and began a procedure turn to the left (west). He stated the afternoon sun…NTSB SEA82FYA08Accident · 1 fatalFinal reportCessna T210M · Shoshone, IDThe aircraft crashed in a near level attitude and at a high rate of speed. Neither the seat belt nor shoulder harness was fastened. The pilot's blood alcohol level was 236 mg%.NTSB LAX82DA215Accident · No injuriesFinal reportAerospatiale 341G · Flagstaff, AZThe pilot reported that he lifted off to a 5 ft hover with 4 passengers and 70 gallons of fuel on board. He reported that during the hover check, all instruments were in the green with the turbine outlet temperature at 550 degrees. The pilot stated that he…NTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…NTSB DEN82DTG05Accident · No injuriesFinal reportCessna 188 · Devils Lake, NDThe pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…NTSB ANC82FAG30Accident · 2 fatalFinal reportPiper PA-18 · Near Dillingham, AKThe acft impacted a side of a mountain Near horseshoe pass at an elevation of 250 ft above sea level. The accident occurred during the hours of daylight with VMC prevailing.NTSB FTW82FPG14Accident · 2 fatalFinal reportAeronca 7AC · Lehi, ARThe acft was believed to have departed the west memphis arpt at approximately 1900. The acft was found at approximately 2000 in an open field 2 mi sw of the arpt. The acft had collided with the ground very hard in a nose down condition. Neither occupant…NTSB ATL82FLA03Accident · 2 fatalFinal reportCessna 172M · Thomasville, GAThe aircraft was being operated on a business flight for the purpose of surveying farm crops in the area. At about 1700 EDT, it crashed into a 20 acre farm lake while on a westerly heading. The weather was reported as clear, visibility 6 to 7 miles with haze,…NTSB LAX82DA209Accident · No injuriesFinal reportBeech M35 · Coalinga, CAAs the pilot was arriving to an uncontrolled airport, he could see a group of planes on the runup pad at the approach end of the runway. As he continued with his arrival and approach, he radioed his intentions, but heard no transmissions from the departing…NTSB LAX82FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Meiners Oaks, CAWitnesses in a remote canyon reported an aircraft making low passes in that area. They last saw the plane going up the canyon. Later, the aircraft was located on a wall of the same canyon. Tests of the pilot's blood showed an alcohol level of .279 percent.…NTSB CHI82DA204Accident · No injuriesFinal reportMooney M20F · Plainwell, MIThe pilot reported that when he entered the traffic pattern, the radios did not work. He stated that he had his mind on this problem and did not put the gear down. Also, he reported that on downwind, the gear warning horn did not work, and subsequently, the…NTSB ATL82FA155Accident · 2 fatalField investigationFinal reportPiper PA-30 · Snow Hill, MDThe pilot/owner and another occupant with a commercial certificate and an instrument rating took off on a IFR flight plan. The weather at the departure point and destination was characterized by low ceilings and reduced visibilities in fog and rain.…NTSB LAX82FA208Accident · 3 fatalField investigationFinal reportCessna T210N · Humphreys Peak, AZTe acft impacted Humphreys Peak at 10,200 ft MSL. The last wx observation at grand canyon was at 1745. The reported wwx was a clear sky & 50 mi visibility.NTSB SEA82DA080Accident · No injuriesFinal reportEagle DW-1 · Sprague, WAThe pilot had checked out in this make and model of aircraft on the preceeding day. On the day of the accident, he was spraying fertizer in a crosswind condition. He stated that he was on a downhill swath run in gusty conditions when he deployed the controls…NTSB FTW82DA205Accident · No injuriesFinal reportGrumman G-164A · Angleton, TXWhile concentrating on his flagger, the pilot misjudged his altitude and allowed the aircraft to collide with a levee. The pilot then dumped his load and made an emergency landing, during which time, the aircraft nosed over.NTSB DEN82FTA10Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendive, MTThe pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…NTSB DEN82DTK05Accident · No injuriesFinal reportGrumman G-164 · Murdo, SDDuring a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.NTSB LAX82FA203Accident · No injuriesField investigationFinal reportCessna T210N · Llano, CAThe pilot stated that when he attempted to extend the gear with the normal system, it would not operate. He stated that he cycled the gear handle 4 or 5 times and checked the circuit breakers. Reportedly, he tried to extend the gear with the hand pump but it…NTSB FTW82DA203Accident · No injuriesFinal reportAero Commander S2R · Lake City, ARThe aircraft departed from a soft private ag strip with a heavy load and would not climb high enough to get above wheat in a field off the end of the runway. The aircraft collided with the wheat and was subsequently destroyed by ground fire.NTSB ANC82DAG28Accident · 1 fatalFinal reportPiper PA-18 · Kenai, AKPilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.NTSB NYC82DA105Accident · No injuriesFinal reportBeech B95 · Farmingdale, NYAfter being newly painted at prospectville, PA, the plane was being flown to Farmingdale, NY where the pilot received a special VFR clearance. According to the pilot, the gear was lowered on the downwind leg for runway 19, but an abnormal noise was heard and…NTSB NYC82DA107Accident · No injuriesFinal reportCessna T210F · Meadville, PAAccording to the pilot, while performing the landing checklist his attention was distracted and a gear check was not accomplished. The aircraft was landed with the gear up causing substantial damage to the skin of the aircraft and the propeller.NTSB FTW82DA198Accident · No injuriesFinal reportBell 47D1 · Jonesboro, ARAfter loading 40 gallons of herbicide on the aircraft the pilot attempted to lift off the back of the loading truck. The takeoff was normal; however, as the helicopter cleared the truck, it was not able to sustain a hover. The pilot then executed a running…NTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…NTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…NTSB DEN82DA093Accident · No injuriesFinal reportBeech V35A · Colorado Spring, COThe pilot stated, the engine run-up was normal and the mixture was leaned at 1700 RPM to obtain initial EGT movement off the bottom of the guage. He reported taking off uphill on runway 03. He noted that the acceleration was slow, but attributed it to the…NTSB DEN82DTG04Accident · No injuriesFinal reportBoeing A75N1 · Northwood, NDThe pilot was on a flight to practice aerial application. This was his first flight in this make and model of aircraft. While making a practice run over an open field with water in the chemical tanks, the left main gear contacted the ground damaging the…NTSB FTW82DA189Accident · No injuriesFinal reportBell 47D-1 · Harrisburg, ARDuring an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…NTSB FTW82DA188Accident · No injuriesFinal reportCessna T188C · Knobel, ARThe pilot stated that during his swath run the engine seemed to hesitate. While checking the engine the pilot collided with a levee and the landing gear separated from the aircraft. The pilot made a forced landing in an adjacent field.NTSB LAX82DA177Accident · No injuriesFinal reportSwearingen SA26-T · Fresno, CAThe aircraft was observed to make a gear up landing. Investigation revealed that the gear operated normally and that the gear lever was found in the down position. The circuit breaker was popped.NTSB NYC82FFA05Accident · Serious injuriesFinal reportNavion A · Hancock, NYThe pilot reported that during takeoff, he climbed to about 20 to 30 ft and raised the gear. At about that time, the aircraft began to sink. He stated that he pulled the power off just before the aircraft hit the ground a few miles from the airport. An…NTSB LAX82DUJ39Accident · Serious injuriesFinal reportCessna 182Q · Camp Verde, AZOn final approach the pilot allowed the aircraft to descend into bushes at the end of the runway. The pilot landed hard, the nose wheel collapsed and the aircraft nosed over.NTSB ATL82FKJ12Accident · 1 fatalFinal reportPiper J3C-65 · Alabaster, ALDuring an air show, the aircraft was observed flying slowly over the runway on a southerly heading at about 200 to 250 ft AGL. Full left rudder was applied along with full up elevator and the plane entered a spin. After one turn, full opposite rudder was…NTSB SEA82FYM15Accident · 3 fatalFinal reportBeechcraft S35 · Walla Walla, WAWhile en route on a dark night, the aircraft collided with mountainous terrain in a heavily wooded, snow covered area. An investigation revealed that the plane crashed while in or near level flight at an altitude of about 4500 ft MSL. The top of the mountain…NTSB LAX82DA172Accident · Minor injuriesFinal reportBeech A23-19 · Peach Springs V, AZDuring a cross country air race the aircraft failed to clear a ridgeline. The pilot stated that with full throttle and adequate rpm's the aircraft was unable to climb out of a downdraft after having flown into a box canyon.NTSB MKC82DA082Accident · Minor injuriesFinal reportBell 47G2 · Thornton, IADuring the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.NTSB FTW82FA173Accident · 2 fatalField investigationFinal reportGulfstream American 980(695) · Carlsbad, NMThe acft crashed about 1/2 mi sw of the departure end of rwy 32L. The rwy had been illuminated at the time of takeoff with the acft making a left turn into an area that was not illuminated toward the mountains. It was a very dark night with an…NTSB FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.NTSB ATL82FLT04Accident · 3 fatalFinal reportPiper PA-32R-300 · Iuka, MSThe aircraft crashed during a pass across the airport. A witness was parked, facing east, in the runup area for runway 18. According to him, the the aircraft took off about 6 minutes earlier, made a traffic pattern, and crashed behind and to his right. The…NTSB LAX82FA171Accident · 3 fatalField investigationFinal reportCessna 172N · El Portal, CAThe wreckage was located at 4,750 ft MSL on the east side of a north/south oriented ridge. The acft had traveled uphill approximately 110 ft on a 45 deg slope on a heading of 236 deg, coming to rest about 50 ft below the top of the ridge.NTSB LAX82FVD16Accident · No injuriesFinal reportScorpion 133 · Fremont, CAThe student pilot, builder of the helicopter was on a dual instructional flight with an instructor pilot (ip). The student had about 71 hours in this make and model while the ip had 18 hours. After making two landings, a descending turn was made to a downwind…NTSB LAX82FA162Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Santa Barbara, CAThe pilot visited fresno fss for a weather briefing on route to Santa Barbara. He was advised of weather and told VFR flight was not recommended. The pilot then said he would go VFR and make an instrument approach at Santa Barbara if weather was as bad as…