NTSB investigations, 2005
112 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 302 |
|---|---|
| 1983 | 260 |
| 1984 | 261 |
| 1985 | 230 |
| 1986 | 213 |
| 1987 | 198 |
| 1988 | 191 |
| 1989 | 203 |
| 1990 | 181 |
| 1991 | 155 |
| 1992 | 189 |
| 1993 | 170 |
| 1994 | 163 |
| 1995 | 163 |
| 1996 | 146 |
| 1997 | 154 |
| 1998 | 161 |
| 1999 | 164 |
| 2000 | 164 |
| 2001 | 150 |
| 2002 | 143 |
| 2003 | 155 |
| 2004 | 137 |
| 2005 | 112 |
| 2006 | 114 |
| 2007 | 126 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2005
AND 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 year(c."eventDate") = 2005 AND 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 DFW06CA048Accident · Minor injuriesData collectionFinal reportBell 206L-4 · Washington, LAThe in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.NTSB ATL06CA026Accident · Serious injuriesData collectionFinal reportEurocopter France AS-350-B2 · Jasper, ALThe pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.NTSB ANC06LA014Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F-19 · Chenga Bay, AKThe pilot's failure to maintain adequate altitude/clearance during takeoff initial climb, which resulted in an in-flight collision with trees, and subsequent collision with the ground.NTSB LAX06LA058Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Dixon, CAthe pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.NTSB LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB SEA06FA015Accident · Minor injuriesField investigationFinal reportAgusta A109E · Olympia, WAThe pilot's improper positioning of the number 2 Power Flight Control switch and his inability to obtain the proper climb rate to clear a concrete wall barrier. Contributing factors included the checklist not being followed and the limit override switch not…NTSB DEN06FA010Accident · 2 fatalField investigationFinal reportLancair LC-40-550FG · Steamboat Spgns, COthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.NTSB SEA06LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Gleneden Beach, ORThe pilot's failure to maintain clearance from objects while maneuvering over the airport environment. Dark night conditions, trees, and ground fog were factors.NTSB LAX06LA015Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Avalon, CAthe pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…NTSB SEA06LA006Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Burlington, WAThe pilot's failure to maintain clearance from a utility pole during a precautionary landing. The utility pole was a factor.NTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.NTSB NYC06CA009Accident · No injuriesData collectionFinal reportSikorsky S-76B · New York City, NYThe pilot flying's failure to maintain adequate aft hover clearance from a fence, and the pilot in command's delayed remedial action. A factor was the dark night lighting conditions.NTSB DEN06LA002Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Albuquerque, NMthe pilot's improper in flight planning decision to takeoff and land (splash and dash) in close proximity to trees. Contributing factors are the trees and the water.NTSB ATL06LA003Accident · 1 fatalLimited investigationFinal reportGrumman F6F · Monterey, TNThe pilot's inadequate preflight planning and inadequate evaluation of the weather, inadequate visual lookout, and his failure to maintain clearance, resulted in the in-flight collision with power lines.NTSB NYC06CA006Accident · Minor injuriesData collectionFinal reportMooney M20K · Ithaca, NYThe pilot's failure to comply with the published instrument approach procedure, which resulted in an in-flight collision with trees.NTSB MIA06CA009Accident · No injuriesData collectionFinal reportCessna 172N · Punta Gorda, FLThe in-flight collision with a bird resulting in substantial damage to the airplane.NTSB LAX06CA002Accident · Serious injuriesData collectionFinal reportBell 206B · Pixley, CAthe pilot's failure to maintain clearance with the wire during a low altitude aerial application flight.NTSB DEN06LA016Accident · Serious injuriesLimited investigationFinal reportAbruzzo Grom-1 · Kendall, KSthe downdraft forcing the balloon into the power lines. A contrbuting factor was the clear air turbulence and the power lines.NTSB DFW05CA253Accident · No injuriesData collectionFinal reportCessna 172S · Batesville, TXThe pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB DFW05CA247Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Mexia, TXThe pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB LAX05TA306Accident · No injuriesFinal reportBell 407 · Inyokern, CAThe pilot failed to maintain tail rotor clearance from obstacles during landing.NTSB LAX05LA308Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350B3 · Running Springs, CAThe pilot's failure to maintain an adequate clearance from trees while performing long line external lift operations.NTSB DFW05FA244Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA20-C1 · Pleasanton, TXThe flight instructor's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB ATL05CA161Accident · Minor injuriesData collectionFinal reportBell 47G-3B · Summerville, TNThe pilot's failure to maintain adequate clearance and adequate visual lookout during take-off which resulted in an in-flight collision with a tree and roll over.NTSB DFW05CA236Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Epps, LAThe pilot's failure to maintain clearance with the power lines.NTSB DFW05CA235Accident · Serious injuriesData collectionFinal reportBell 47G · Swifton, ARThe pilot's failure to maintain clearance with the power lines. A contributing factor was sun glare.NTSB IAD05LA129Accident · Minor injuriesLimited investigationFinal reportDassault/Sud Falcon 20D · Lorain, OHThe ingestion of multiple birds in each engine at takeoff, which resulted in a complete loss of engine power.NTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB DFW05CA213Accident · No injuriesData collectionFinal reportBell 206L · Gulf of MexicoThe pilot's failure to maintain clearance with a stationary object while landing.NTSB ATL05FA145Accident · 1 fatalField investigationFinal reportCessna 310R · Apopka, FLThe pilot's failure to maintain adequate visual lookout and object clearance, which resulted in the in-flight collision with trees.NTSB SEA05CA173Accident · No injuriesData collectionFinal reportHughes 369E · Donnelly, IDThe pilot's failure to maintain clearance of a tree during a landing attempt due to loss of visibility from a self induced brown-out condition. Contributing factors were the pilot's failure to identify a hazardous landing site, and the tree.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB IAD05CA117Accident · Minor injuriesData collectionFinal reportCessna C-172G · Eustis, METhe pilot's failure to maintain clearance from a bush during the aborted landing.NTSB CHI05LA211Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Buchanan, NDThe pilot failed to maintain obstacle clearance from the power lines. Factors included the glare on the windshield and the power lines.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB ANC05TA111Accident · No injuriesFinal reportMcDonnell Douglas 500D · Delta Junction, AKThe pilot's failure to maintain clearance from trees during the approach to landing, which resulted in the main rotor blades striking a tree. A factor associated with the accident was the tree.NTSB DFW05FA192Accident · 2 fatalField investigationFinal reportAero Commander 112 · Junction, TXThe pilot's failure to attain the proper climb rate resulting in the airplane's wing colliding with a tree and subsequent impact with the ground. Contributing factors were the pilot's improper use of the airplane's flaps, and the rising terrain.NTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.