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 SEA94LA046Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Manila, UTThe pilot's failure to maintain clearance. Factors include a tailwind, gusts, and a tree just off the departure end of the field used for takeoff.NTSB SEA94FA045Accident · 2 fatalField investigationFinal reportCessna 172D · Bandon, ORThe pilot's failure to maintain adequate clearance. Factors include strong, gust winds, a dark night, and the pilot's lack of experience in nighttime operations.NTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.NTSB LAX94LA080Accident · 2 fatalLimited investigationFinal reportCessna 150G · Truckee, CAThe pilot's impaired judgment and impaired performance, while under the influence of drugs, that resulted in his failure to maintain sufficient altitude and clearance above the mountainous terrain and obstructions (power line & trees).NTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.NTSB ANC94LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot-in-command not maintaining the proper clearance from the terrain during the approach.NTSB FTW94FA050Accident · 1 fatalField investigationFinal reportCessna 172M · Lancaster, TXwas THE FAILURE OF THE PILOT TO MAINTAIN AIRCRAFT CONTROL DUE TO PHYSICAL IMPAIRMENT (ALCOHOL).NTSB CHI94LA052Accident · No injuriesLimited investigationFinal reportCessna 404 · Big Rapids, MIThe pilot's descent below the minimum descent altitude.NTSB MIA94LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-301P · Fort Myers, FLThe failure of the pilot-in-command to abort the takeoff. A contributing factor was the soft condition of the runway surface.NTSB CHI94LA042Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Pratt, KSThe pilot-in-command's failure to maintain clearance from obstacles. Factors contributing to the accident are the pilot's misjudged fuel consumption calculations and the weather (high winds).NTSB NYC94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Hopkinsville, KYthe pilot's improper IFR procedure by conducting flight below minimum descent altitude (MDA) without visual referece which resulted in an inflight collision with wires. A factor was the wire.NTSB CHI94LA046Accident · No injuriesLimited investigationFinal reportCessna 550 · West Chicago, ILthe collision with birds/geese shortly after takeoff. Reduced visibility in fog was a factor.NTSB FTW94FA041Accident · 1 fatalField investigationFinal reportQuicksilver MX II · Newark, TXPoor judment of the pilot after use of drugs, his improper planning/decision, and his failure to remain clear of an obstruction during takeoff. Factors related to the accident were: the pilot's overconfidence with the aircraft's ability, a tailwind condition,…NTSB LAX94LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Panoche, CAthe pilot's improper approach speed and glide path, and his delayed initiation of a go-around. A factor in the accident was the wind shear condition created by the hills immediately off the departure end of the dirt airstrip.NTSB SEA94LA037Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Sublimity, ORThe pilot's failure to maintain clearance from unmarked transmission wires. Factors include the pilot's inadequate visual lookout, and unmarked wires in the area of operation.NTSB LAX94LA055Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Paula, CAThe pilot's failure to follow proper procedures/directives prohibiting night operations at the airport and failure to maintain the proper glidepath. The pilot's diverted attention was a factor in this accident.NTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.NTSB SEA94LA036Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Pasco, WAThe pilot in command's failure to maintain clearance with the irrigation sprinkler system.NTSB FTW94FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKWas the pilot-in-command continued VFR flight into IMC. A factor was fog.NTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…NTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.NTSB BFO94LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Greentown, PAThe pilot's selection of the wrong runway, and his delay in attempting a go-around which resulted in an inflight collision with the trees. A related factor was the unfavorable wind.NTSB FTW94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fredericksburg, TXThe pilot's utilization of unsuitable terrain for takeoff.NTSB MIA94FA015Accident · 1 fatalField investigationFinal reportCessna 182Q · Crestview, FLWas incapacitation of the pilot due to cardiovascular disease during an instrument approach resulting in the aircraft descending uncontrolled until tree and ground impact. Contributing to the accident was the pilot's decision to fly with known cardiovascular…NTSB LAX94LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Lake Berryessa, CAthe pilot's selection of an inadequate obstacle clearance cruise altitude.NTSB LAX94LA033Accident · No injuriesLimited investigationFinal reportRobinson R22A · Santa Rosa, CAthe separation of the tail rotor due to a collision with a mylar balloon and the subsequent hard landing during an autorotation. A factor in the accident was the dark night lighting conditions which limited the pilot's ability to see and avoid the balloon.NTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.NTSB SEA94LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander AC-100-180 · Oregon City, ORThe pilot's failure to maintain clearance from transmission wires. Factors include light conditions at dusk, and transmission wires near the approach end of the runway.NTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.NTSB NYC94LA017Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Littleton, MAThe flight instructor's inadequate in-flight decision in the selection of the simulated forced landing area, and his delay in initiating a go around which resulted in the airplane colliding with trees.NTSB ANC94LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Karluk, AKThe selection of unsuitable terrain for landing.NTSB CHI94FA018Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Atkinson, NEthe instrument rated commercial pilot's failure to maintain adequate clearance from terrain/obstructions during the initial climb after takeoff. Related factors are the weather conditions (fog) and the pilot's failure to maintain the proper rate of climb.NTSB FTW94LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Tomball, TXWas the pilot's disregard for and continued descent below mda and his delay in executing a go around.NTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.NTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.NTSB NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.NTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.NTSB ATL93LA163Accident · No injuriesLimited investigationFinal reportAerospatiale TB21 · Spruce Pine, NCThe pilot's inadequate inflight decision in delaying a go-around attempt and in attempting a go around with full flap extension.NTSB ANC93LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Rocky River, AKThe pilot misjudging his altitude on final approach.NTSB LAX93FA369Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Wildomar, CAThe failure of the tail rotor blade after being struck by the pilot's knee board, and the failure of the pilot to adequately secure the knee board while in flight.NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.NTSB LAX93LA361Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Buttonwillow, CAThe pilot's failure to avoid wires.NTSB LAX93LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Hesperia, CAThe pilot in command not maintaining a proper glidepath. Factors pertaining to this accident were: the pilot in command not obtaining a weather forecast for the return flight, and the lack of total experieince in night flying.NTSB SEA93LA200Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waterville, WAThe pilot's inadequate visual lookout and failure to maintain clearance from the powerline.NTSB SEA93LA211Accident · No injuriesLimited investigationFinal reportCessna 150L · Silverton, ORClearance was not maintained. A factor to the accident was: poor in-flight planning/decision.NTSB SEA93LA198Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164A · Dayton, WAThe pilot in command's failure to maintain proper clearance from the power lines. The unmarked power lines were a factor.NTSB LAX93LA349Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Sonoma, CAthe airport management's failure to provide notice of the banner operation and to close the runway. An additional cause was the banner operator's failure to ensure that the runway on which he placed his banner equipment was closed.NTSB ATL93LA156Accident · Serious injuriesLimited investigationFinal reportBrown VAN'S RV-3 · Statesville, NCWas the pilot's failure to see and avoid utility lines. A factor was the sunglare.NTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.NTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.