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 MIA89LA056Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Crystal River, FLThe plt stated that he was giving a friend a ride in the acft when he inadvertantly struck powerlines and crashed in shallow water.NTSB LAX89LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Hesperia, CAAt the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…NTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.NTSB ANC89LA024Accident · No injuriesLimited investigationFinal reportCessna 170B · North Pole, AKThe plt rprtd that drg an apch to land, a x-wind caused the acft to drift to the left. Subsequently, the left wing struck trees along the edge of the rwy & the acft crashed. The plt rprtd the wind was from 120 deg at 6 gusting 10 KTS.NTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB LAX89FA057Accident · 1 fatalField investigationFinal reportBeech N35 · Hanford, CAThe pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…NTSB FTW89FA025Accident · 1 fatalField investigationFinal reportLuscombe 8E · Port Lavaca, TXThere were no records to indicate the non-instrument rated pilot received a pre-flight weather briefing from any weather reporting service. Witnesses in the area of the accident stated the night was dark and the ground was covered with fog. The airplane…NTSB NYC89LA034Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Oxford, CTCollision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.NTSB MKC89FA027Accident · 6 fatalField investigationFinal reportBeech E-90 · Locust Grove, ARThe pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.NTSB LAX89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Santa Maria, CADuring a pleasure flight, the airplane was being flown along a ridgeline while the pilot and passenger were looking for an old airplane wreck. The pilot was distracted and did not notice the airplane was entering a canyon and rising terrain. When the pilots…NTSB MIA89FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Jacksonville, FLDrg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…NTSB ATL89FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, FLAircraft departed on a cross country instructional flight. The aircraft landed for fuel at orlando int'l and departed VFR. There were no witnesses. The accident site was located by ELT signal in a treeline that bordered the west end of a large open pasture.…NTSB MIA89FA027Accident · 2 fatalField investigationFinal reportGrumman AA5A · Tampa, FLWitnesses stated the acft was flying at low alt in the area of lake thonotosassa just before it struck the top static wire of a group of power lines. Impact occurred while the acft was on a southerly heading. The acft then crashed into an orange grove. An…NTSB ANC89LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Meshik Lake, AKThe pilot was attempting to takeoff from an unimproved landing area with two hunter-friends. He stated that the aircraft bounced three times, reached an altitude of about four feet, then hit the ten-foot high trees at the departure end of the area and nosed…NTSB ATL89LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Deane, KYWhile en route to wise, Virginia from richmond, Kentucky on a pleasure flight, the airplane collided with trees on rockhouse mountain. The airplane was substantially damaged and the pilot and passenger were seriously injured. The fuel selector was found…NTSB ATL89LA027Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Greensboro, NCPIC was attempting to land at unfamiliar airport with narrow rwy, 25 feet wide, bounded by trees. He did not determine wind other than its general direction. Crosswind was four knots. On short final, after crossing over trees that were approach obstacles,…NTSB LAX89LA038Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Vacaville, CADuring final approach, the glider collided with a fence. A witness stated that, 'the pilot simply let the glider get too low and too slow and hit a fence.' There were no mechanical problems reported prior to the accident. The pilot did not file an acdt report.NTSB FTW89FA012Accident · 1 fatalField investigationFinal reportPiper 601B · Houston, TXPilot's decision to fly the approach visually with outside reference to the lights and inadvertently descending below the decision height off the proper glide path.NTSB MKC89LA018Accident · Serious injuriesLimited investigationFinal reportRockwell S2R · Sublette, KSWhile conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the…NTSB LAX89DUJ01Accident · Serious injuriesFinal reportCessna A188A · Casa Grande, AZDuring aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.NTSB CHI89LA016Accident · No injuriesLimited investigationFinal reportBeech F35 · Milwaukee, WIWhile executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…NTSB MKC89LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Blue Springs, MOThe plt said, while cruising over a water reservoir at about 500 feet AGL, he collided with two waterfowl, believed to be geese. One struck the wing tip, the other near the wing root. Acft control remained constant with no control problems encountered, and…NTSB DEN89LA026Accident · No injuriesLimited investigationFinal reportCessna 210D · Malta, MTThe private plt, alone in the aircraft, was performing a landing on a paved road at a hunting resort. During final approach the Cessna struck power lines and damaged the nose gear. The acft touched down on the road and the nose gear collapsed. A post accident…NTSB LAX89DUM02Accident · Serious injuriesFinal reportPiper PA-36-285 · Brawley, CAAt the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued.NTSB SEA89LA011Accident · 1 fatalLimited investigationFinal reportRoman LONG-EZ · Salmon, IDThe purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree…NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB NYC89FA006Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Renovo, PAImproper VFR procedures the pilot's visual lookout was improper and he collided with a static wire.NTSB NYC89LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, PAThe CFI and student plt were practicing touch and go landings. The CFI said the landing was long and the aircraft was not quite aligned with the rwy. By the time the aircraft was realigned and under control the CFI thought there was insufficient rwy to stop…NTSB ANC89LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Eagle, AKThe pilot-in-command was attempting to air drop groceries to a mining site and a box of bread hit the horizontal stabilizer. The aircraft returned and landed uneventfully at Eagle airport.NTSB SEA89FA006Accident · No injuriesField investigationFinal reportBeech B-99A · East Sound, WAThe crew elected to depart the airport under a special VFR clearance. Wx at the departure airport was 700 ft ovc with visibility 1 and 1/4 miles. The destination airport was within 25 nautical miles of the departure airport and was reporting a bkn ceiling of…NTSB DEN89LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe commercial Balloon plt and one pax were participating in a Balloon fiesta. The acft took off from Albuquerque, on a local flight in light winds. At altitude, the Balloon encountered easterly winds that carried the Balloon southwest of Albuquerque, where a…NTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…NTSB LAX89LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Auberry, CAThe pilot was unfamiliar with the area that he was attempting to land in and circled to familiarize himself with the terrain. He then made a low pass over the dirt runway and circled to land. The first attempt was discontinued because the pilot felt that he…NTSB ANC89LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · Wasilla, AKDrg arrival to land on a lake at night, the plt began a 180 deg turn from a NE heading at aprx 500' AGL to a final apch on a sw heading. As the acft was in the turn, it began losing altitude rapidly. The plt applied power to stop the descent, but the acft…NTSB NYC89LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mayville, NYWhile on short final for landing, the flt encountered turbulence and began settling over trees located near the end of the runway. In the attempt to go around the plt allowed the acft to decelerate. The acft drifted 30 degrees right of the runway and crashed…NTSB MKC88FA183Accident · 3 fatalField investigationFinal reportBeech D55 · N. Little Rock, ARThe pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…NTSB NYC88LA240Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Burlington, CTThe plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB SEA88LA184Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Eugene, ORPlt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and…NTSB CHI88DET06Accident · 1 fatalFinal reportJones None · Elkhart, INInadequate aircraft design which resulted unacceptable aircraft takeoff and climb capability.NTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…NTSB CHI88FA237Accident · 2 fatalField investigationFinal reportCessna 182RG · Zanesville, OHThe pilot's poor judgement/decision-making, and his over confidence in his own ability which led to his repeated decisions to operate his aircraft in adverse weather conditions. The fact that the pilot had operated the aircraft in adverse weather conditions…NTSB DEN88LA205Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lund, UTThe private plt was spraying crops during an aerial application flight. During a right turn at the end of a spray run, he said he diverted his attention into the cockpit to check the metering rate, and may have inadvertently pushed the control stick forward.…NTSB ATL88LA250Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Surf City, NCA landing was attempted at a private turf strip in gusty wind conditions. At level off for a 3-point landing on rwy 24, the right wing was lifted sharply by a wind gust. Right aileron and rudder were applied and power was added to go-around. As the airplane…NTSB SEA88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Gasquet, CAThe pilot stated that as he turned final approach, intense sunglare was encountered. The plt executed a go-around 'in the blind,' and collided with trees in approach path. The acft remained flyable and the pilot diverted to medford, Oregon.NTSB FTW88FA162Accident · 1 fatalField investigationFinal reportCessna 172P · Marietta, OKThe plt elected to land on rwy 17 with wind from 300 degrees at 6 knots. During the second go-around the airplane's left wing struck a tree at a point 30 feet above the ground and the aircraft ended up inverted in a parking lot. Plt stated he had landed at…NTSB CHI88FA203Accident · 2 fatalField investigationFinal reportPiper PA-20 · Claypool, INPilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree.NTSB CHI88DER13Accident · No injuriesFinal reportPiper PA-22-150 · Cohasset, MNFailure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach.NTSB ATL88LA246Accident · No injuriesLimited investigationFinal reportCessna 182K · Hendersonville, NCThe pilot was nearing touchdown on a normal landing when the left side of the windscreen was struck by a bird. The startled pilot was distracted long enough for the aircraft to bounce on the runway. Elevator control was lost after the first bounce. A nose low…