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 CHI95LA260Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A-450 · Grand Forks, NDthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the sunglare.NTSB ATL95LA149Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions Fantasy 6 · Kingsport, TNThe pilot's inadequate visual lookout.NTSB ATL95LA145Accident · No injuriesLimited investigationFinal reportBell 47G2 · Montrose, GAThe pilot's inadequate preflight planning and visual lookout.NTSB ANC95LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Port Alsworth, AKThe pilot's inadequate compensation for the crosswind condition, which resulted in a failure to maintain runway alignment. The crosswind and proximity of trees were related factors.NTSB CHI95LA245Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Oklee, MNthe pilot failed to maintain clearance with trees. Factors associated with the accident were the trees and the pilot's diverted attention.NTSB LAX95LA269Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Tulare, CAfailure of the pilot to see and avoid power lines along his route of flight.NTSB CHI95LA239Accident · Minor injuriesLimited investigationFinal reportK. Davey And B. Davey WAG-AERO · Hokah, MNthe pilot performing low altitude flight and the failure to maintain clearance with the trees. A factors associated with the accident was the trees.NTSB FTW95LA311Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Hico, TXThe pilot's failure to attain the proper touchdown point and the delayed go-around.NTSB NYC95LA169Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-2S · Honesdale, PAthe pilots misjudgment of the altitude required to perform an aerobatic maneuver, and the subsequent collision with trees.NTSB ANC95LA112Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Bettles, AKFailure of the pilot to ensuring the sling cable was free of the skid before lifting off into a hover, which allowed the cable to become wrapped (entangled) around the skid.NTSB NYC95LA166Accident · No injuriesLimited investigationFinal reportBeech V35B · Goshen, OHthe pilot's premature liftoff which resulted in an inadvertent stall and a subsequent collision with trees.NTSB ANC95LA108Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to properly align his takeoff path.NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB SEA95LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Kent, WAThe pilot's failure to maintain clear of the trees. The dark night light condition was a factor.NTSB CHI95LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Crete, NEthe pilot's failure to maintain clearance with the runway marker.NTSB FTW95LA288Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARThe pilot delayed pull-up from a swath run and failed to maintain clearance from the obstruction (grain elevator). A factor relating to the accident was: the pilot's use of medications that were not approved for use while flying.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB NYC95LA156Accident · No injuriesLimited investigationFinal reportSchweizer S-2-33A · Elmira, NYThe pilot's delayed decision to return to the departure airport, which resulted in insufficient gliding altitude, and the subsequent off airport landing in the trees.NTSB LAX95LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Rubidoux, CAthe pilot's inadequate preflight planning/preparation in that he attempted to fly an aircraft without first verifying the aircraft's gross weight and published performance capabilities.NTSB CHI95LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Culver, INThe student pilot's failure to maintain directional control of the airplane, while performing a go-around. A factor relating to the accident was: the proximity of trees beside the runway.NTSB SEA95LA139Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Orting, WAThe pilot's failure to see and avoid the cable.NTSB ATL95LA130Accident · No injuriesLimited investigationFinal reportCessna 150L · Holly Ridge, NCthe pilot diverted his attention and failed to maintain clearance from obstacles.NTSB FTW95LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Weston, TXThe pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…NTSB ANC95LA089Accident · No injuriesLimited investigationFinal reportCessna 208 · Talkeetna, AKThe pilot's inadequate visual lookout during the turn.NTSB FTW95FA259Accident · 2 fatalField investigationFinal reportCessna 152 · Ben Wheeler, TXThe pilot's intentional low level flying and not maintaining a clearance from the trees. A factor was the pilot exceeded the maximum allowable gross weight of the airplane.NTSB BFO95LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Wauseon, OHThe pilot's failure to obtain/maintain adequate altitude/clearance from obstacles during an attempted go-round. Related factors are the pilot's failure to attain the planned approach and the improper go-around procedures.NTSB ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.NTSB BFO95LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Phillips, MEthe private pilot's failure to obtain/maintain altitude/clearance from obstacles during the takeoff/initial climb. Related factors are the grass/turf runway, the improper weight and balance, and the tailwind.NTSB NYC95LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yellow Springs, OHinadequate visual lookout by the pilot which resulted in the airplane striking the tower.NTSB LAX95LA213Accident · No injuriesLimited investigationFinal reportBell 47-G2A · Bakersfield, CAthe pilot's failure to maintain adequate lateral clearance from the irrigation standpipe while applying chemicals to a field.NTSB BFO95LA065Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Grand River, OHThe pilot selected unsuitable terrain for the takeoff.NTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.NTSB CHI95LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lowell, MIthe pilot's failure to obtain/maintain altitude/clearance.NTSB CHI95LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bay City, MIFailure of the pilot to maintain clearance from obstacles and his intentional buzzing.NTSB FTW95FA238Accident · 1 fatalField investigationFinal reportSmith LONG-EZ · Cloudcroft, NMThe pilot's failure to maintain clearance from trees. Factors were the pilot exceeded the allowable maximum gross weight of the airplane, the rising terrain, and high density altitude.NTSB SEA95LA117Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Challis, IDInadequate preflight/planning preparation. Factors to the accident were: downdraft and tailwind.NTSB ANC95LA110Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot's inadequate compensation for the wind conditions during the landing approach, and his failure to maintain altitude/clearance from trees. A factor relating to the accident was: the gusty wind condition.NTSB FTW95FA231Accident · 1 fatalField investigationFinal reportWeatherly 620B · Flagler, COFailure by the pilot to maintain clearance from the static line of a power transmission array during an aerial application flight.NTSB BFO95LA057Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Quarryville, PAthe pilot's failure to attain proper altitude/clearance from obstacles during takeoff.NTSB SEA95LA112Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Caldwell, IDThe pilot's failure to maintain clearance from power lines. Factors include sunglare encountered when he turned into the sun.NTSB LAX95LA201Accident · Serious injuriesLimited investigationFinal reportCessna 180F · Cartago, CAthe pilot's inflight decision to attempt a low pass over a mountain airstrip at a high density alitude atmospheric condition, and, his failure to retract the flaps during the climb-out from the pass. The rising mountainous terrain surrounding the landing…NTSB SEA95LA110Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Umpqua, ORThe pilot's failure to maintain clearance with a tree, resulting in a tail rotor blade strike on the tree which disabled the tail rotor. Contributing to the accident was the 150-foot-high rock bluff.NTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB LAX95FA198Accident · 4 fatalField investigationFinal reportCessna 172N · Lovelock, NVthe pilot's intentional flight at low altitude and subsequent collision with transmission wires during dusk light conditions.NTSB ANC95LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Hope, AKThe pilot's failure to adequately compensate for wind conditions. Factors associated with the accident are the trees bordering the runway, and a downdraft.NTSB NYC95LA119Accident · Minor injuriesLimited investigationFinal reportErwin Taylor Mono Plane · Freeport, PAthe pilot's improper decision to initiate a takeoff on an uphill runway with high grass, which resulted in a premature lift off, and an inadvertent stall/mush into trees.NTSB LAX95LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Redding, CAthe pilot's improper use of the flight controls. The downward-sloping terrain and the intermittent gusty wind conditions were factors in this accident.NTSB NYC95LA118Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Moscow, PAThe pilot's inadequate compensation for a cross wind and his failure to maintain adequate obstacle clearance. A factor is the crosswind.NTSB CHI95LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · East Gull Lake, MNthe pilot's failure to maintain clearance from the trees. Factors in the accident were the crosswind and gusts.NTSB FTW95LA194Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Casa, ARThe pilot's failure to maintain obstacle clearance.