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 CHI03LA241Accident · 1 fatalLimited investigationFinal reportYoung Pietenpol Air Camper · Peru, INThe pilot not maintaining altitude/clearance from the trees during the landing. A factor was the trees he impacted.NTSB CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.NTSB CHI03LA243Accident · Minor injuriesLimited investigationFinal reportRockwell International S-2R · Mitchell, SDThe pilot's inadequate visual lookout and not maintaining clearance from the power line during the low level aerial application maneuver. A related factor was the power line.NTSB ANC03CA078Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Aniak, AKThe pilot's inadvertent touchdown, and failure to maintain clearance from trees during an aborted landing, which resulted in the nose over of the airplane. A factor associated with the accident was the soft terrain.NTSB LAX03CA250Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13E-M74 · Tulare, CAthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.NTSB CHI03LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Evansville, INThe pilot's failure to attain the proper touchdown point. The barrels were a factor.NTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.NTSB CHI03LA224Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Highland, MIFailure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.NTSB ANC03LA084Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Big Lake, AKThe failure of the pilot of the seaplane and the operator of the jet ski to maintain an adequate visual lookout, which resulted in a collision during the airplane's landing flare.NTSB MIA03LA146Accident · 1 fatalLimited investigationFinal reportSonerai Sonerai IIB · Lakeland, FLThe pilot's decision to conduct low level flight and his failure to maintain obstacle clearance.NTSB SEA03LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Newman Lake, WAThe pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.NTSB SEA03FA143Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · White Bird, IDThe failure of the pilot to maintain clearance with terrain while maneuvering. Factors contributing to the accident included the impairment of the pilot due to carbon monoxide exposure and the trees.NTSB CHI03LA210Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Cleveland, MNThe pilot's inadequate visual lookout and low altitude flight when he failed to maintain altitude/clearance from the transmission wire. A factor contributing to the accident was the transmission wire.NTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.NTSB NYC03CA157Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS-4 · Ashburnham, MAThe pilot's improper in-flight decision to over fly a suitable landing area. Factors in this accident were weak thermal lift activity, and lack of suitable terrain at the time of the landing.NTSB SEA03LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stuart Island, WAThe pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.NTSB CHI03LA205Accident · No injuriesLimited investigationFinal reportCessna 182Q · Empire, MIThe pilot's failure to abort the takeoff. A contributing factor to the accident included the pilot not utilizing all available engine power during the entire takeoff. Additional factors were the improper wing flap setting and the cherry-tree orchard.NTSB LAX03TA229Accident · No injuriesFinal reportSikorsky S-64E · Tucson, AZthe pilot's failure to maintain tail rotor clearance while hovering resulting in a tail rotor blade strike.NTSB FTW03LA186Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Ship Shoal 80The pilot's failure to maintain clearance with a parked/stationary aircraft.NTSB FTW03FA182Accident · 2 fatalField investigationFinal reportCessna 172S · McKinney, TXThe CFI's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during the forced landing. A contributing factor was the impact with a bird, which affected the performance of the airplane.NTSB FTW03LA178Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Ship Shoal 80The pilot's failure to maintain clearance with the safety fence while landing on an off-shore helipad.NTSB SEA03LA130Accident · No injuriesLimited investigationFinal reportCessna T210M · Essex, MTThe unexpected transit of a deer across the runway which impacted the aircraft during the pilot's aborted landing.NTSB SEA03LA127Accident · Minor injuriesLimited investigationFinal reportLockheed 402-2 · Headquarters, IDThe pilot's improper preflight planning and improper fuel consumption calculations. Factors contributing to the accident included the unfavorable wind condition, the downdraft, and the trees.NTSB SEA03FA123Accident · 3 fatalField investigationFinal reportBeech A24-R · Yellow Pine, IDThe pilot's failure to maintain clearance. Factors include trees and mountainous terrain.NTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.NTSB LAX03LA214Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt. Charleston, NVthe pilot's inadequate in-flight planning and selection of the wrong route of flight, which led the airplane toward rising terrain in excess of the performance capability of the airplane. Also causal was the pilot's delayed decision to divert her route of…NTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.NTSB DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.NTSB NYC03LA142Accident · No injuriesLimited investigationFinal reportBeech 24 · Rome, NYThe pilot's failure to maintain directional control during a go-around which resulted in the airplane impacting trees. A factor in the accident was the shifting wind.NTSB CHI03LA182Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Dexter, MOThe pilot's inadequate visual lookout and failure to maintain clearance from the wires during the aerial application flight. Factors contributing to the accident were the helicopter's low altitude and the transmission wires.NTSB CHI03LA180Accident · No injuriesLimited investigationFinal reportCessna 170B · Widener, ARThe pilot's failure to maintain clearance from the wires and his failure to maintain adequate airspeed, resulting in a stall. A factor contributing to the accident was the unmarked wires.NTSB DEN03LA109Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Las Vegas, NMthe pilot's failure to maintain obstacle clearance and visual lookout. Contributing factors were his attention being diverted and the trees.NTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.NTSB LAX03LA210Accident · No injuriesLimited investigationFinal reportBeech S35 · Weed, CAthe pilot's failure to maintain an adequate terrain/object clearance altitude.NTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.NTSB CHI03LA171Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marked Tree, ARThe pilot's failure to maintain clearance with the wire. Contributing factors were the low altitude flight/maneuver and the static wire.NTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…NTSB IAD03CA057Accident · Minor injuriesData collectionFinal reportBoeing A75N1(PT17) · Sutton, WVThe pilot's failure to abort the takeoff in a timely manner. Factors included the high density altitude conditions, and the pilot's lack of familiarity with the airplane's high density altitude performance characteristics.NTSB ANC03LA059Accident · No injuriesLimited investigationFinal reportWilliamson Glastar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in the airplane impacting trees along the side of the runway. A factor contributing to the accident was the pilot's improper recovery from a bounced…NTSB SEA03LA101Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Royal City, WAThe pilot's failure to maintain clearance from a 20 foot high post while applying chemicals to an agricultural field, which resulted in impact damage to the right main landing gear, and ultimately to a collapse of the subject gear during the subsequent…NTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.NTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.NTSB FTW03LA168Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Encinal, TXThe pilot's failure to maintain clearance from a tree. A contributing factor was the pilot's diverted attention.NTSB NYC03LA120Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shiloh, NJThe pilot's improper in-flight decision to not jettison his load when he realized that he would not clear the trees. A factor was the pilot's inattention to his airspeed at liftoff and on climb.NTSB CHI03FA149Accident · 1 fatalField investigationFinal reportCessna 172S · Sidnaw, MIThe improper short/soft field landing procedure by the pilot and his lack of recent experience in type of operation. Contributing factors were the short/soft field runway, the trees and his delay in aborting the takeoff.NTSB LAX03LA177Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe pilot's failure to maintain an adequate visual lookout.NTSB LAX03LA172Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Livermore, CAthe pilots acceptance of a clearance meant for another aircraft. Contributing to the accident was the failure of departure controller to detect the pilot's incorrect read back and the controllers improper radio technique, which increased the chances of call…NTSB DEN03LA089Accident · No injuriesLimited investigationFinal reportBeech A36 · Afton, WYthe pilot's failure to achieve an adequate climb rate, resulting in an inflight collision with the sign. Contributing factors were the pilot's improper mixture leaning procedure, the high density altitude, his failure to abort the takeoff in a timely manner,…NTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.