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 DEN01FA105Accident · 2 fatalField investigationFinal reportSchempp-Hirth Nimbus-3DM · Alamogordo, NMThe flight crew's inadequate in-flight planning to fly over the mesa with insufficient altitude. A contributing factor was the downdraft weather conditionNTSB SEA01LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Sunriver, ORThe pilot's failure to maintain clearance from trees during initial climb. Trees were a factor.NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.NTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.NTSB NYC01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26E · New Milford, CTthe student pilot's improper decision to fly northeast of the airport with winds from the southwest, and his subsequent diverted attention to the glider's proximity to the airport while he searched for thermals, which resulted in an off airport landing.NTSB DEN01FA096Accident · 2 fatalField investigationFinal reportBeech 76 · Gunnison, COintentional buzzing by both pilots and their failure to maintain clearance with transmission wires. A contributing factor was the sun glare.NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.NTSB CHI01FA130Accident · 2 fatalField investigationFinal reportCessna 172N · Wichita, KSthe student pilot not maintaining clearance from the tower support wire during the practice emergency landing maneuver and the instructor pilot's inadequate supervision of the student pilot. Factors relating to the accident were the static wire and the low…NTSB SEA01LA082Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Nampa, IDthe pilot's inadequate compensation for strong, gusty, shifting winds while hovering in ground effect. Factors include a sudden directional change and increase in velocity of the gusty wind conditions.NTSB DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.NTSB FTW01LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Nacogdoches, TXthe pilot's failure to maintain clearance with the wires during takeoff. Contributory factors were the sunglare and the unmarked wires.NTSB SEA01LA077Accident · No injuriesLimited investigationFinal reportCessna 172S · Renton, WAA Canadian goose which crossed the aircraft's flight path and impacted the left wing during the aircraft's final approach.NTSB NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.NTSB LAX01LA153Accident · 1 fatalLimited investigationFinal reportHolt Christian Eagle II · White Water, CAThe pilot's failure to maintain an adequate clearance from the power lines during an intentional low level flight.NTSB SEA01LA074Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hagerman, IDThe pilot's failure to maintain proper runway alignment during an attempted go-around, resulting in an inflight collision with a wind sock. Factors were a short runway/landing area condition, the pilot's excessive airspeed on final approach, and the wind sock.NTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.NTSB NYC01LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, VAThe pilot's inadequate compensation for the runway conditions. Factors included the soggy runway conditions, and the lack of available takeoff performance data in the owners manual.NTSB DEN01LA073Accident · No injuriesLimited investigationFinal reportCessna 340 · Alamosa, COThe in-flight collision with a large bird during downwind approach for landing.NTSB MIA01LA096Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Brevard, NCan in-flight collision with a tree. Factors in this accident were the pilot's inadequate planned approach and excessive airspeed on the approach.NTSB FTW01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 · Alvarado, TXthe pilot's failure to maintain clearance with a marked static wire.NTSB ANC01LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Ophir, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate preflight planning/preparation resulting in a collision with trees during the initial climb. Factors in the accident were soft, snow-covered terrain, and trees in the area of…NTSB SEA01LA055Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Waitsburg, WAThe pilot's failure to maintain clearance from the power lines during a pull-up, resulting in an in-flight collision with the lines, loss of control and subsequent in-flight collision with terrain. Contributing factors were the power lines and the pilot's…NTSB CHI01LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Detroit Lakes, MNAltitude/clearance not maintained from the transmission wires during a low altitude flight/maneuver performed by the pilot. A factor to the accident was the transmission wires.NTSB CHI01FA089Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Webb Lake, WIthe pilot not maintaining altitude/clearance from the trees during takeoff. Factors were the trees, transmission wire, and the dark night.NTSB CHI01FA083Accident · 2 fatalField investigationFinal reportSwearingen SA227-AT · Beaver Island, MIThe flightcrew not maintaining altitude/clearance during the circling instrument approach. Factors were the pilot in command initiating the flight without proper weather reporting facilities at the destination, the flightcrew not flying to an alternate…NTSB CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.NTSB FTW01LA052Accident · 2 fatalLimited investigationFinal reportNanchang CJ-6A · Edgewood, TXthe pilot's failure to maintain obstacle clearance with the tower guy wire while the airplane was in cruise flight. A contributing factor was the pilot's failure to update his navigation chart with the location of the tower during his preflight…NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB ATL01LA023Accident · Serious injuriesLimited investigationFinal reportCessna 172SP · Austell, GAThe pilots failure to follow instrument flight procedures and descended below the published the minimum descent altitude and subsequently collided with trees short of the runway.NTSB LAX01LA078Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Holtville, CAThe pilot's failure to maintain clearance from the wires. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB CHI01FA067Accident · 2 fatalField investigationFinal reportCessna 182B · Piedmont, KSThe pilot's failure to maintain obstacle clearance. Contributing factors were low altitude maneuvering and the transmission wire.NTSB ANC01LA030Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Tyonek, AKThe pilot's failure to maintain adequate tail rotor clearance while maneuvering to land.NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB ATL01FA019Accident · 1 fatalField investigationFinal reportCessna 206H · Vandiver, ALThe pilot's inflight decision to continued visual flight into instrument meteorological conditions resulted in the inflight collision with trees. Low ceilings and trees were factorsNTSB FTW01LA046Accident · No injuriesLimited investigationFinal reportCessna 177RG · Del Rio, TXThe pilot's inadequate compensation for the winds. A factor was the windshear.NTSB DEN01IA036Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Salt Lake City, UTthe captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.NTSB SEA01FA032Accident · 2 fatalField investigationFinal reportHughes 369HS · Pierce, IDWhile maneuvering, clearance from an object was not maintained. A tree was a factor.NTSB MIA01LA047Accident · No injuriesLimited investigationFinal reportLarry Groover Eagle · Auburndale, FLthe pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.NTSB MIA01LA038Accident · No injuriesLimited investigationFinal reportGrob G102 · Clermont, FLThe pilot's premature extension of the speed brakes on landing resulting in the glider colliding with trees short of the runway.NTSB LAX01LA061Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Henderson, NVThe pilot misjudged his practice approach into a remote pinnacle landing site, dragging a skid across a rock resulting in a hard landing.NTSB MIA01LA037Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Belle Glade, FLThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with known wires along the swath run, and a loss of directional control on landing roll due to flight control damage sustained during the in-flight…NTSB LAX01FA049Accident · 1 fatalField investigationFinal reportBeech BE-55-D55 · Clifton, AZthe pilot's improper in-flight decision to attempt a landing on an unlit runway at night, and his failure to maintain the proper glide path and clearance from obstacles while on final approach, which resulted in the collision with a utility pole. A…NTSB CHI01LA042Accident · No injuriesLimited investigationFinal reportAerostar PA-60-601P · Preston, MNaltitude/clearance from the trees not being obtained/maintained by the pilot. Factors to the accident were the trees and the contamination of the pitot/static system.NTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.NTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.NTSB CHI01LA033Accident · Minor injuriesLimited investigationFinal reportSaab 340-B · Aberdeen, SDthe impact with the flock of snow geese.NTSB CHI01FA032Accident · 1 fatalField investigationFinal reportSwearingen SA226TC · Fort Wayne, INThe indicated failure of the right hand AC bus during takeoff with low ceiling. The factors were the low ceiling, night, and the execssive workload the pilot experienced on takeoff with an electrical failure without a second in command.NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.