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 SEA88LA168Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Dixie, IDWhile on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the…NTSB LAX88FA306Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Temecula, CAFailure of the pilot to properly initiate a go-around during an aborted landing. The loss of directional control during the landing, failure to return to the runway for the aborted takeoff, and not establishing the proper rate of climb due to high density…NTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…NTSB CHI88LA229Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Schaumburg, ILDuring an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of…NTSB LAX88LA304Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barrett Junct., CAWhile descending into a canyon, the aircraft struck powerlines, went into an uncontrolled descent and collided with the terrain. The pilot stated that he could not see the powerlines and that his visibility was restricted by the sun. All four passengers…NTSB BFO88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, WVThe plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…NTSB MKC88FA166Accident · Serious injuriesField investigationFinal reportCessna 150 · Reed Springs, MOThe accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately…NTSB FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…NTSB BFO88LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Port Royal, VAThe pilot departed fredericksburg, VA, for a power line patrol flight in Port Royal, VA. After intersecting the power lines at the substation, the patrol was initiated flying 10 ft above and 20 ft to the left of the lines. The plt stated he was looking…NTSB BFO88DID04Accident · 1 fatalFinal reportPiper PA-25-250 · Waverly, VAThe acft contacted pwr lines, crashed and burned during an aerial appliation flt. Witnesses reported that it looked as if the plt descended to fly under the lines when it suddenly pulled up and contacted them.NTSB ATL88LA243Accident · No injuriesLimited investigationFinal reportSchempp-Hirth 2 · Whitwell, TNThe pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did…NTSB ATL88DMG08Accident · No injuriesFinal reportPiper PA-25-235 · La Grange, NCThe pilot reported that the spray boom collided with a tree, resulting in the left aileron being jammed in an uncontrollable position. The acft impacted in a field.NTSB NYC88LA225Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Readington, NJWhile attempting a go-around from a rejected landing in x-wind conditions the plt who had no landings in the last 90 days failed to initiate the go-around with sufficient time/distance to clear trees off the end of the rnwy. The acft struck the trees and was…NTSB MKC88LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hebron, NEWhile making a aerial application swath run, the pilot was checking his spray booms because of some malfunctioning nozzles. Exiting the field between two groups of trees on the border he failed to see power line poles. He struck the wires, then the terrain,…NTSB MIA88FA257Accident · Serious injuriesField investigationFinal reportHughes 500 · Riviera Beach, FLThe traffic watch helicopter was cruising northbound along the interstate at 450 ft AGL & 85 KTS airspeed. A grinding noise was heard & the tail rotor separated from the acft. The acft began an uncommanded right turn which was arrested in about 1/4 turn. The…NTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…NTSB CHI88DEP11Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Plover, WIThe aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944…NTSB LAX88LA285Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Lake Arrowhead, CADuring a local parachute jump flight, the airplane was unable to gain enough altitude to clear rising terrain. The airplane collided with a tree and eventually the terrain. There were no reported mechanical failures or malfunctions. The acft handbook lists…NTSB LAX88DVA10Accident · No injuriesFinal reportAyres S2R-T34 · Huron, CADuring an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the…NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB SEA88LA152Accident · 1 fatalLimited investigationFinal reportCassutt III · Shelton, WAAcft had been restored and recertificated since last flight in 1969. On initial test flight takeoff, plt immediately turned to and flew low, slow landing pattern circuit with sounds of reduced power, colliding with trees in final approach turn. Investigation…NTSB ATL88DKG17Accident · No injuriesFinal reportIntermountain Mfg. Callair A-9 · Redbud, GANTSB CHI88FA198Accident · 2 fatalField investigationFinal reportPiper PA-28 · Auburn, INFlight known adverse weather conditions.NTSB CHI88DEX11Accident · 1 fatalFinal reportContinental Copters MK-5 · Redkey, INPhysical impairment of the pilot due to drugs which resulted in a misjudged approach and subsequent contact with trees during the approach to an aerial application swath run.NTSB ATL88DKG12Accident · No injuriesFinal reportCessna 188B · Bainbridge, GANTSB NYC88LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20C · E. Stroudsburg, PAThe plt said that during an attempted landing the acft floated during the flare. After using about half the rwy he decided to go-around. The temp was 90 deg f resulting in a density alt of 3200 ft. the plt said he applied full pwr but the acft did not climb…NTSB MKC88DCA02Accident · Serious injuriesFinal reportCallair A-9A · Rush Hill, MOAbout 25 minutes after sunset, the airplane struck a powerline and pole during a spray run. The airplane struck the ground inverted.NTSB CHI88LA191Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · St. Charles, MIThe pilot failed to attain sufficient altitude to clear obstacles during the initial climb-out and the aircraft collided with trees located off the departure end of the private grass strip. The aircraft fell to the ground, where it caught fire and was…NTSB NYC88FA202Accident · 2 fatalField investigationFinal reportCessna 172P · Post Mills, VTThe plt flew the acft to an arpt with two turf rwys. Rwy 5/23 was 2300' long & rwy 4/22 was 2600' long. After attending a meeting which ended at 1600 EDT, the plt elected to wait until later in the day to takeoff after the air had cooled. Subsequently, he…NTSB ATL88DLT01Accident · 1 fatalFinal reportVan RV-4 · Ashland City, TNNTSB LAX88FA278Accident · 1 fatalField investigationFinal reportCessna T-210 · Brea, CANTSB LAX88LA276Accident · Serious injuriesLimited investigationFinal reportRaven RX-6 · Sun City, CAThe pilot & pax departed on a local area balloon flt. After 30 minutes the pilot began a descent to an open feild north of some power lines. During the descent the balloon began to drift to the right and the pilot realized that his ground crew did not have…NTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…NTSB LAX88FA272Accident · 3 fatalField investigationFinal reportCessna 177RG · Cedar Grove, CAPilots decision to attempt a flight through a mountainous area at an altitude insufficient to ensure terrain clearance.NTSB DEN88LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Forsyth, MTNTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…NTSB LAX88DUM05Accident · No injuriesFinal reportAir Tractor AT-301 · Niland, CAJust after takeoff, the pilot made a right turn to locate the ground flaggers and to avoid transmission wires. The pilot, unable to locate the flaggers, initiated a climb to avoid wires and rising terrain. However, the airplane did not gain sufficient…NTSB DEN88LA161Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Buchanan, NDThe plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…NTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…NTSB FTW88DRD14Accident · Serious injuriesFinal reportGrumman G-164A · Crowley, LAThe agricultural pilot was working in a field which had telephone lines at one end and power lines at the other. On his last run, as he started his pull up, the airplane struck the power lines at one end of the field. The airplane went through the power…NTSB MKC88LA126Accident · No injuriesLimited investigationFinal reportRockwell S2R · England, ARThe plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.NTSB LAX88LA268Accident · No injuriesLimited investigationFinal reportRaven S-60A · Bakersfield, CADuring a sightseeing flight, while on final approach, the balloon collided with power lines. The wires arced starting a fire which damaged the balloon envelope. The plt did not file an acc report. The plts last medical exam was on 7/3/79.NTSB FTW88DRD13Accident · Serious injuriesFinal reportGrumman G-164A · Kinder, LAThe pilot was spraying a fungicide on the field and the owner of the field was flagging for him, on the top of a dike, on the west end of the field. During normal operation, the flagman stayed in position until the airplane was 300 feet away, at which time he…NTSB DEN88FA212Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Kanosh, UTPlt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…NTSB FTW88DRD12Accident · No injuriesFinal reportTexas Helicopter M74C · Rayville, LAThe commercial pilot was spraying his cotton field with his own helicopter. The acft hit a tree during a right turning pull-up. The tail rotor blades were severed first then, during an uncontrolled right turn, the tailboom hit another tree. The main rotor…NTSB CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…NTSB CHI88LA155Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Hillsboro, OHAfter making a low pass down a private strip, the aircraft experienced a wire strike followed by an uncontrolled descent into the ground. The pilot stated that his attention was diverted by the owner of the strip.NTSB SEA88LA123Accident · Serious injuriesLimited investigationFinal reportKaman HH43 · Joseph, ORThe pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.NTSB ANC88LA081Accident · 1 fatalLimited investigationFinal reportCessna 206 · Naknek, AKThe pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…NTSB MKC88FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Beedeville, ARIntentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.