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 LAX97LA248Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Buttonwillow, CAfailure of the pilot to maintain adequate clearance from a utility pole (obstruction) during aerial application. The obstruction was a related factor.NTSB FTW97LA276Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Palestine, ARThe pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.NTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.NTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…NTSB MIA97LA210Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Woodeberry, TNin-flight collision with a fence during takeoff. Factors in this accident were the pilot's inadequate pre-flight by not calculating the total weight of the airplane, and high temperatures.NTSB ANC97LA101Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Eagle, AKThe pilot's inadequate recovery from a bounced landing and his inadequate in-flight planning/decision making during an aborted landing.NTSB NYC97LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Springfield, KYthe pilot's misjudgment of distance and speed, and his delay in aborting the landing. Factors relating to the accident were: the pilot's failure to attain a proper touchdown point for landing, and proximity of the fence to the runway.NTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB SEA97LA161Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Bend, ORthe pilot's failure to attain a proper climb rate. High density altitude and the pilot's failure to use all of the available runway were factors.NTSB MIA97LA205Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Mooresville, NCThe pilot's failure to obtain the proper touchdown point on landing resulting in a go-around, and a subsequent in-flight collision with trees and terrain.NTSB CHI97LA207Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Columbia, MOthe pilot's failure to properly judge the landing approach. The proximity of transmission wires was a related factor.NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB ATL97LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Spruce Pine, NCThe pilot's failure to maintain terrain clearance after turning the wrong way in a traffic pattern.NTSB LAX97LA239Accident · No injuriesLimited investigationFinal reportCessna 172 · Aguiguan Island, MauritiusThe pilot's failure to maintain runway alignment while landing on an undeveloped private dirt strip.NTSB ATL97LA094Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180C · Dyersburg, TNthe pilot's improper planning/decision and failure to insure the that airplane would remain clear of trees during the go-around. Factors relating to the accident included: the high temperature, high density altitude, and the proximity of trees.NTSB FTW97LA242Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edna, TXfailure of the pilot to maintain clearance from a guy wire, during a swath run.NTSB CHI97LA192Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgregor, MNthe pilot's improper planning/decision, his failure to abort the takeoff while sufficient runway was remaining, and/or his failure to jettison his load in order to achieve sufficient climb rate to clear trees. His lack of certification and training to perform…NTSB SEA97LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Prineville, ORThe pilot's selection of an unsuitable landing area, his improper decision to attempt an aborted takeoff on a short airstrip surround by rising terrain and trees, and his failure to maintain clearance from the trees during the aborted takeoff attempt. Factors…NTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.NTSB ANC97FA092Accident · 2 fatalField investigationFinal reportCessna 207A · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…NTSB FTW97LA233Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Swifton, ARthe pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.NTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.NTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.NTSB LAX97LA215Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Nimbus 3/24.5 · Macdoel, CAthe pilot's failure to see and avoid a set of power lines while making an off-airport landing due to a lack of lift.NTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.NTSB NYC97LA117Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harrisonburg, VAthe pilot's failure to obtain the proper touchdown point. A contributing factor was the transmission line.NTSB SEA97LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Waldport, ORthe pilot's inadequate preflight planning/preparation to ensure he could execute a safe departure in the meteorological conditions present at the time. Related factors included: the unfavorable/variable/gusty wind conditions; and a power line near the…NTSB NYC97LA119Accident · Minor injuriesLimited investigationFinal reportEnstrom F-280C · Sharon, VTThe pilot's improper decision to descend and fly at 100 feet over a river and his failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with wires.NTSB SEA97LA136Accident · Serious injuriesLimited investigationFinal reportStaudacher S-260-2 · Wallace, IDthe pilot's improper planning/decision, which resulted in his failure to maintain adequate altitude/distance from wooded terrain during a low-altitude course reversal. Related factors include mountainous/hilly terrain, blind canyon, low ceiling, and trees in…NTSB IAD97LA083Accident · 1 fatalLimited investigationFinal reportErcoupe G · Dalton, NYthe pilot's delay in aborting the landing after allowing the airplane to touchdown long. His failure to attain a proper touchdown point was a related factor.NTSB CHI97LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-25 · Sullivan, MOthe pilot's continued VFR flight into instrument meteorological conditions in an airplane not equipped for flight into IMC. Factors were: the pilot's inadequate preflight preparation, his inadequate evaluation of the weather, and fog.NTSB NYC97LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Walton, NYThe pilot's improper inflight decision to establish an approach without confirming the landing area, and his delayed go-around, which resulted in the inflight collision with trees.NTSB NYC97LA105Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Fredericksburg, VAThe pilot's delayed go-around which resulted in the inflight collision with trees off the departure end of the runway.NTSB CHI97LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Gregory, MIThe pilot's improper planning/decision. The tailwind and location of trees were related factors.NTSB MIA97FA176Accident · 3 fatalField investigationFinal reportCessna 172N · Comerio, PRthe pilot's improper in-flight planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from obstructions on rising terrain.NTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.NTSB CHI97LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, INimproper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.NTSB FTW97LA196Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Welsh, LAThe pilot's failure to maintain clearance with a moving vehicle. Factors were: the lack of runway signs and a runway safety area, and the difficulty for the pilot and driver of the vehicle to visually detect each other due to high vegetation at the edge of…NTSB NYC97LA097Accident · Serious injuriesLimited investigationFinal reportEnstrom 280-C · Clarksburg, NJThe pilot's failure to maintain adequate clearance from the hangar.NTSB ATL97LA073Accident · 1 fatalLimited investigationFinal reportCapstaff Challenger II · Southern Pines, NCThe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain clearance from obstacles.NTSB CHI97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.NTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…NTSB CHI97LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Huron, SDThe pilot's failure to maintain clearance from known transmission lines.NTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.NTSB NYC97FA080Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Waterford, VAfailure of the pilot to follow the published instrument (IFR) approach procedure, by failing to maintain the minimum altitude for that segment of the approach.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.NTSB IAD97FA065Accident · 2 fatalField investigationFinal reportLockheed PV2 · Blandburg, PAPilot in command misjudged his maneuvering altitude. Factors to this accident were the mountainous terrain, windy conditions, turbulence in the area, and smoke.NTSB MIA97LA143Accident · No injuriesLimited investigationFinal reportCessna 150G · Raleigh, NCfailure of the pilot to maintain proper runway alignment during the attempted landing and go-around. Factors relating to the accident were: the gusty crosswind condition, and proximity of trees to the runway.NTSB ATL97FA060Accident · 1 fatalField investigationFinal reportBeech C23 · Athens, GApilot impairment of judgment and performance, due to alcohol; and his failure to maintain sufficient altitude or clearance from obstacles, while maneuvering at low altitude at night. Darkness was a related factor.NTSB CHI97LA106Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Highmore, SDa premature lift-off of the airplane by the pilot in command.