NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
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\" = 220) 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" = 220) 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 NYC82DA209Accident · No injuriesFinal reportCessna 421C · Saratoga Spring, NYThe aircraft was on a flight to reposition it for an air taxi operation. The pilot-in-command (PIC) was in the right seat while the second-in-command (SIC) was flying in the left seat. During arrival to the Saratoga county airport, the aircrew were cleared…NTSB ANC82DAG46Accident · No injuriesFinal reportCessna 172 · Quinhagak, AKThe pilot reported that he landed on a gravel bar about 900 ft long with a passenger to go fishing. Later, he took off to the west with a slight head wind. Near the end of the gravel bar was a tree with branches sticking out of the water. As the pilot took…NTSB SEA82DA148Accident · No injuriesFinal reportPiper PA-22-135 · Weiser, IDDuring a simulated forced landing, the instructor pilot took control of the aircraft at the go-around point. He followed the normal procedure for the go-around (full power) carb heat, etc), except that he continued the low approach to provide the student with…NTSB MKC82FCJ05Accident · 1 fatalFinal reportTaylorcraft BC-12-65 · Max, NEPilot flying cross-country at low altitude collided with wires and crashed. No malfunctions of aircraft observed.NTSB CHI82DA325Accident · No injuriesFinal reportCameron 0-77 · Wall Lake, MIThe pilot reported that during flight, he encountered unexpected light turbulence and elected to land at the next available spot. He stated that during a landing approach at about 50 ft above the treetops, a gust of wind was encountered that forced hot air…NTSB LAX82DA317Accident · No injuriesFinal reportPiper PA-12 · Phoenix, AZThe aircraft collided with trees during takeoff from a 900 foot, dirt strip. The weather was VFR. The temperature was 102 degrees. No accident report was filed. The pilot had an expired medical certificate.NTSB FTW82DA339Accident · Minor injuriesFinal reportNorth American AT-6A · Abilene, TXThe pilot landed on runway after the T-6 landed on grass to right of the runway. The T-6 turned toward the ramp and crossed path of the Cessna on the runway. A collision occurred as the Cessna pilot tried to go-around and overfly the AT-6.NTSB DEN82DA169Accident · Serious injuriesFinal reportQuicksilver Mxii · Broomfield, COReportedly, the pilot made an intersection takeoff from about midfield on runway 02. He stated that he took off at rotation speed plus 2 KTS. The passenger reported that they reached about 40 ft AGL, then lost lift and begun to settle. As the two-place…NTSB ATL82FLJ08Accident · Serious injuriesFinal reportPiper PA-25-260 · Scotland Neck, NCDuring the fourth swath run the acft struck a 60-foot tree approximately 5 ft from the top.NTSB ANC82DA073Accident · No injuriesFinal reportCessna 185 · Near Skwentna, AKThe pilot of the float plane began his takeoff from a narrow river with a left turn at the lift-off point. After becoming airborne and while turning, the right wing struck a branch. The pilot stated that the aircraft came to rest in the trees, upside down.…NTSB ATL82DA238Accident · No injuriesFinal reportCessna 152 · Stone Mountain, GAThe pilot reported that a split-s maneuver was performed at a low altitude and the aircraft struck the branches of a pine tree. The aircraft continued to fly and the pilot returned to the airport. There was damage to the right wing and the fuselage.NTSB ATL82DA237Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Spout Springs, NCThe pilot stated that the wind was gusting and shifting as he was landing with a cumulus build-up nearby. He reported that during his landing, he increased his airspeed to compensate for a gusty crosswind. The pilot stated that the mechanical brakes did not…NTSB DEN82DA161Accident · Minor injuriesFinal reportAir Tractor AT-301 · Center, COThe pilot was on the first swath run of his second load. He stated that as he started to cross below transmission lines, when he saw a small boy and a dog appear from a ditch below the wires. He stated that when he pulled up to avoid the child, the aircraft…NTSB NYC82FA193Accident · 2 fatalField investigationFinal reportCessna 180H · Porter, METhe acft was taking off from a pond which is about 4,200 ft at its longest length. A power line extends across the pond about 2,000 ft from the south end. The acft was observed to takeoff to the north remaining on the water while passing under the wires. The…NTSB CHI82DA299Accident · No injuriesFinal reportQuickie Quickie · Youngstown, OHDuring takeoff, the home built aircraft struck the tops of trees near the departure end of the 3300 ft runway. The pilot stated that the aircraft climbed very slowly and was barely able to climb at a greater rate than the upslope of the runway. The elevation…NTSB FTW82DA322Accident · No injuriesFinal reportCessna T188C · Altheimer, ARThe pilot stated he encountered turbulence while flying under a power line during a crop spraying operation. The left wing pitched-up and struck the power line and the aircraft went into an uncontrolable left bank. He reduced power and landed in a bean field,…NTSB CHI82DA298Accident · No injuriesFinal reportQuickie · Greenville, MIDuring the preflight inspection. The laminar-flow wing and canard were carefully wiped free of a heavy deposit of dew. All items of inspection were satisfactory. The engine was warmed up while taxiing to the runway. It was noted that beads of moisture were…NTSB MKC82IA138Incident · Minor injuriesIncident investigationFinal reportPiper PA-25-235 · Wilsonville, NEThe pilot stated that he was overcome by exposure to the organic phosphate he was deploying. According to local law enforcement authorities, the aircraft crashed in a field and came to rest inverted. Medical tests for toxic chemical exposure were inconclusive.NTSB LAX82FA291Accident · 1 fatalField investigationFinal reportCessna 152 · Weaverville, CAThe student pilot was practicing takeoffs and landings at a unidirectional runway. The airport procedure was to takeoff downhill on runway 18 and to land uphill on runway 36. Pilots, who flew at the airport, stated that go-arounds were not made on runway 36…NTSB FTW82DA319Accident · No injuriesFinal reportEagle DW-1 · Cheneyville, LAThe acft was on the approach to spray a cottonfield when a collision with an unseen power line occurred. The collision forced the acft down and the pilot made a hard landing which damaged the landing gear and the right wing. The visibilitywas about 5 miles in…NTSB DEN82FTE22Accident · 1 fatalFinal reportEiriavion PIK-20D · Crested Butte, COThe pilot was attending an "aviation weekend" sponsored by the town of Crested Butte, CO. He had flown in this area often and was acquainted with the terrain and weather. After being towed to an area near the northwest corner of mt Crested Butte, a normal…NTSB ANC82DA065Accident · No injuriesFinal reportMaule M-4-210C · Eagle River, AKThe pilot reported that he preflighted the float plane, pumped the floats, and checked for water. After the engine start, taxi, and pretakeoff checks, he set the flaps at the first notch. He aborted his first takeoff run and taxied back for a longer run. The…NTSB MIA82DA162Accident · No injuriesFinal reportMooney M20F · Orlando, FLThe pilot reported that rain had occurred on the previous night and there was water on the 2430 ft grass runway. He reported that during rotation, the aircraft hit the water and lost airspeed. Subsequently, the aircraft failed to gain sufficient altitude to…NTSB ATL82DA225Accident · No injuriesFinal reportPiper PA-38-112 · Keyser, WVPilot was making a go-around over a 1700 foot runway. Full flaps were left down until end of runway and then raised to 21 degrees. Terrain was rising faster then aircraft was climbing. Aircraft struck trees and nosed down into the ground. Temperature was 85…NTSB SEA82DA132Accident · Minor injuriesFinal reportCessna 172M · Donnelly, IDThe aircraft floated the entire length of the runway without touching down before a go-around was started. During the go-around, the left wing collided with a tree at near-stall speed. The aircraft yawed 180 degrees and impacted the ground going backwards.NTSB FTW82DA312Accident · No injuriesFinal reportCessna 177 · Springer, NMWhile en route on a flight from gallup, NM to dalhart, TX, the left fuel tank would not feed. The pilot made a precautionary landing on rough, grassy terrain with no damage. An examination revealed that the tab for the left filler cap was broken and the cap…NTSB DEN82IA150Incident · No injuriesIncident investigationFinal reportAerospatiale 350D · Near Winter Par, COWitnesses who were aboard the aircraft stated that the aircrafts rotor struck a tree during a "straffing run" on a railroad trestle just below the Continental divide. The pilot stated that the engine flamed out as he passed over the trestle. The aircraft was…NTSB SEA82FAD01Accident · 1 fatalFinal reportLake LA-4-200 · Ketchikan Intl., AKDeparting under a special VFR clearance, the acft entered IMC within a period of approximately 15 secs after takeoff. The acft struck trees & the ground approximately 2 mi south of the airport.NTSB ATL82DA219Accident · No injuriesFinal reportCessna 188 · Bishopville, SCThe pilot reported that as he was entering a field on his third swath, the aircraft collided with a single transmission line. The line was leading to the center of a cotton field. The pilot did not see the line. After contacting the line, the aircraft was…NTSB MKC82FCD09Accident · Serious injuriesFinal reportHughes 269B · Tipton, IAThe helicopter crashed during takeoff on a flight to pollenate corn. The pilot reported that he made a running takeoff across the runway. He stated that the helicopter became airborne at the north edge of the runway, but started to settle as it went over the…NTSB SEA82FYP10Accident · Serious injuriesFinal reportPiper PA-22-150 · Tieton, WAAfter takeoff, the pilot turned to the left, but then he was unable to clear trees while climbing over rising terrain. A witness that saw the plane turn after takeoff stated that most airplanes continue climbing over a nearby lake and gain altitude before…NTSB NYC82DA168Accident · No injuriesFinal reportPiper PA-18S · Moultonboro, NHAccording to the pilot, he taxied to a takeoff point farther out than normal and it took longer to get the plane "on the step" due to very heavy air. When the pilot reached the abort point he used control back pressure to "pop off" the water. However, he was…NTSB SEA82DYK10Accident · 2 fatalFinal reportBeech S35 · Mckenzie Bridge, ORThe aircraft was landed at the Mckenzie Bridge state airport where two passengers deplaned. The airport had a 2600 ft turf runway with an upslope gradient of 3.4% toward the east. The airport/facility directory stated, "unattended. Land to e, takeoff to w.…NTSB FTW82FRJ14Accident · Serious injuriesFinal reportCessna 188 · Monroe, LADuring turn around after first spray run, the aircraft collided with trees at an altitude of 75 feet. The path of flight was on a heading of 280 degrees, into the sun.NTSB DEN82FTE20Accident · No injuriesFinal reportSteen Skybolt · Glenwood Spring, COThe aircraft crashed into trees in mountainous terrain about 10 miles southwest of the Glenwood springs county airport. This occurred while the pilot was flying low over the mountainous area and was unable to outclimb the rising terrain. The density altitude…NTSB CHI82DA268Accident · No injuriesFinal reportPiper PA-38 · Antioch, ILThe pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that…NTSB FTW82FPJ17Accident · 1 fatalFinal reportPiper 28-140 · Harrah, OKDuring takeoff, the pilot elected to cross under a power line near the end of the runway when he realized he could not fly over. As the plane crossed under the power line, the right main gear struck a steel perimeter fence post. Across the street form the…NTSB LAX82DA271Accident · Minor injuriesFinal reportGrumman G-164A · Chandler, AZWhile spraying at night & during the fourth pass under power lines crossing the field, the acft contacted the wires. After the accident the flagger at the field informed the plt that the wind was causing the wires to whip up & down at times.NTSB FTW82FPJ16Accident · Serious injuriesFinal reportPiper 18 · Gage, OKThe aircraft was being used to spray grasshoppers and was flying in an easterly direction. The right wing struck a high line wire that is oriented north and south. After striking the wire the aircraft struck the ground approximately 190 feet east of the high…NTSB FTW82FPD16Accident · Serious injuriesFinal reportCessna 188B · Stanford, TXThe pilot had completed spraying approximately 75 percent of a 76 acre field. Witnesses stated that the aircraft collided with the lower of two powerlines. The aircraft was observed to clear the higher of the two power lines but hook the lower set of wires…NTSB NYC82FNC11Accident · Serious injuriesFinal reportFirefly 7 · Winslow, MEWhile descending to land in an open field, the balloon began drifting towards high powerlines. In an attempt to avoid a collision, the pilot fired the burner approximately nine times, using short blasts of the burner. The balloon failed to gain altitude and…NTSB ANC82DAA09Accident · No injuriesFinal reportCessna 182 · Ft. Yukon, AKThe pilot stated that he overflew the Ft. Yukon airport and observed men working on runway 21. He flew a downwind pattern for runway 03. While on final approach to runway 03 the pilot observed an "x" on the end of the runway the pilot attempted a landing off…NTSB ATL82FLJ07Accident · Serious injuriesFinal reportGrumman American AA-1B · Gatesville, NCWhile on final approach for landing, the pilot added 1/3 flaps and adjusted the throttle to clear obstacles. He reported that when he was on short final, he was distracted by several deer that were approaching the touchdown point. The pilot theorized that…NTSB SEA82DA114Accident · No injuriesFinal reportMong Sport 1 · Battleground, WAThe pilot tookoff from a rough turf field adjacent to a school after a parade featuring his plane. The day was hot and the field was short. The pilot was unable to clear 60 foot trees and impacted the ground.NTSB CHI82DA251Accident · Serious injuriesFinal reportCessna 172P · Washington Island, WIDuring arrival, the pilot made an approach to runway 14 for a night landing. After flaring to land, the aircraft was observed to float. The pilot stated that he had come in high, and during a go-around, the aircraft did not seem to climb properly, then…NTSB MKC82DA125Accident · No injuriesFinal reportCessna 150G · Bonner Springs, KSThe aircraft was flown from a private airstrip at maximum gross weight and an uphill takeoff run. The pilot stated he could not maintain airspeed. During a turn to make an emergency landing the left wing contacted a utility wire and the aircraft was…NTSB LAX82FUQ16Accident · Serious injuriesFinal reportGrumman G-164 · Lancaster, CAPlt was spraying very low due to wind conditions. Acft struck a water sprinkler & immediately caught on fire.NTSB ATL82DA214Accident · No injuriesFinal reportHiller UH-12E · Centre, ALWhile returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing.NTSB SEA82DA108Accident · No injuriesFinal reportGrumman AA-5B · Corvallis, ORThe aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it…NTSB SEA82DA106Accident · Minor injuriesFinal reportBeech A23-19 · Carlton, WAThe purpose of the flight was for mineral exploration. The pilot reported that the sun was low on the horizon which resulted in long shadows being cast by the terrain. In the vicinity of hoodoo peak, the pilot determined that he had allowed the aircraft to…