NTSB investigations, 2006
79 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 290 |
|---|---|
| 1983 | 222 |
| 1984 | 210 |
| 1985 | 187 |
| 1986 | 159 |
| 1987 | 123 |
| 1988 | 135 |
| 1989 | 122 |
| 1990 | 141 |
| 1991 | 146 |
| 1992 | 143 |
| 1993 | 163 |
| 1994 | 124 |
| 1995 | 139 |
| 1996 | 110 |
| 1997 | 111 |
| 1998 | 105 |
| 1999 | 116 |
| 2000 | 109 |
| 2001 | 130 |
| 2002 | 105 |
| 2003 | 87 |
| 2004 | 72 |
| 2005 | 80 |
| 2006 | 79 |
| 2007 | 77 |
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\") = 2006
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\" = 230)
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") = 2006 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" = 230) 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 CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.NTSB LAX07FA060Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Big Pine, CAThe inadequate in-flight/planning decision of both pilots to fly up a box canyon at low altitude, and their failure to maintain clearance from the terrain.NTSB LAX07FA062Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Young, AZThe pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…NTSB NYC07FA048Accident · 2 fatalField investigationFinal reportBell 407 · Dagsboro, DEThe pilot's improper decision to depart under visual flight rules into night instrument meteorological conditions. Contributing to the accident was the fog and the dark night conditions.NTSB LAX07LA054Accident · 2 fatalLimited investigationFinal reportJohn Lauer Harmon Rocket II · Bakersfield, CAThe pilot's failure to maintain terrain clearance during an aerobatic maneuver.NTSB SEA07LA025Accident · 2 fatalLimited investigationFinal reportHolloway RV6A · North Bend, ORThe pilot's failure to maintain clearance from the water while performing low altitude maneuvering flight resulting in an in flight collision with the water.NTSB DFW07FA019Accident · 2 fatalField investigationFinal reportCessna 172S · Hominy, OKThe pilot's continued cruise flight into adverse weather conditions, and his failure to maintain clearance from terrain. Contributing factors were the dark night conditions, and the low ceilings.NTSB LAX07LA027Accident · 2 fatalLimited investigationFinal reportAir Creations Tanarg 912 · Bisbee, AZThe pilot's failure to maintain clearance from the mountainous terrain.NTSB NYC07LA020Accident · No injuriesLimited investigationFinal reportCessna 182RG · Toms River, NJThe private pilot's failure to attain the proper touchdown point, and the flight instructor's inadequate remedial action, which resulted in a landing short of the runway. A contributing factor was the gusty wind conditions.NTSB CHI07LA013Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Forest Lake, MNthe altitude/clearance with terrain not maintained by the pilot.NTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…NTSB DFW07LA011Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A++ · Eugene Isl 259The flight crew's failure to maintain clearance with the water and their diverted attention to secondary tasks while preparing to land. Contributing factor were the low ceilings and the heavy rains restricting their visibility.NTSB NYC07FA009Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Odenton, MDThe pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…NTSB NYC07LA008Accident · 1 fatalLimited investigationFinal reportFlynn William Pazmany PL-4 · Fredricksburg, VAThe pilot's intentional low altitude maneuvering, which resulted in an inadvertent collision with terrain.NTSB LAX06FA304Accident · 2 fatalField investigationFinal reportCessna 182K · Sedona, AZThe pilot's failure to maintain clearance from trees and terrain while maneuvering in mountainous/hilly terrain in a high density altitude environment.NTSB LAX06CA296Accident · No injuriesData collectionFinal reportBell 47G · Angels Camp, CAa hard landing due to the pilot's inadequate compensation for a wind shift encountered on final approach and his failure to maintain an adequate translational lift airspeed.NTSB CHI06CA266Accident · No injuriesData collectionFinal reportMD Helicopters 369FF · Port Clinton, OHThe pilot not maintaining clearance from the water during the survey flight. A factor was the low altitude the survey flight was flown at.NTSB LAX06LA293Accident · 2 fatalLimited investigationFinal reportChampion 7EC · Clipper Mills, CAThe pilot failed to maintain clearance from mountainous terrain. A contributing factor was the pilot's impairment from ingestion of marijuana.NTSB CHI06LA258Accident · 1 fatalLimited investigationFinal reportGarner Garner Falcon · Newton, IAAn inflight collision with terrain during an unknown phase of flight. A factor was the pilot's lack of experience.NTSB SEA06CA177Accident · No injuriesData collectionFinal reportCessna 182RG · Shelton, WAThe pilot's failure to extend the landing gear prior to a practice soft-field landing, and the certified flight instructor's failure to take remedial action. Factors include the pilot's failure to use a checklist.NTSB LAX06GA287Accident · 2 fatalFinal reportNorth American OV-10A · Porterville, CAthe pilot's failure to maintain adequate terrain clearance while maneuvering over rising terrain in a box canyon. Also causal was the pilot's failure to adhere to procedures/directives regarding minimum altitude requirements.NTSB CHI06CA257Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Anamoose, NDThe pilot not maintaining altitude/clearance from terrain during the aerial application pass.NTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB ANC06CA127Accident · No injuriesData collectionFinal reportCessna 172 · Healy, AKThe pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.NTSB LAX06LA275Accident · 2 fatalLimited investigationFinal reportTerry Tevis RV-6A · Novato, CAThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.NTSB SEA06LA164Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Townsend, MTThe pilot's failure to maintain terrain clearance while intentionally maneuvering low to the ground.NTSB CHI06LA240Accident · No injuriesLimited investigationFinal reportCessna A188B · Rolla, NDThe pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…NTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.NTSB DEN06LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Santa Fe, NMthe pilot's improper decision to continue the attempted takeoff when Vx airspeed was not obtained, and failure to abort the takeoff during ground roll which resulted in an impact on the remaining runway with the landing gear retracted. A contributing factor…NTSB CHI06CA229Accident · No injuriesData collectionFinal reportCessna 150 · Jamestown, NDThe pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.NTSB SEA06CA160Accident · No injuriesData collectionFinal reportRobinson R-22B · Boise, IDThe instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.NTSB ANC06CA110Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Coldfoot, AKThe pilot's selection of an unsuitable landing area, which resulted in an in-flight collision with terrain during an aborted landing. Factors associated with the accident were wind gusts, and rough and uneven terrain.NTSB CHI06CA217Accident · No injuriesData collectionFinal reportVeltman CH701 · Owosso, MIThe pilot's inadequate preflight planning and inadequate compensation for the tailwind condition. Factors included the tailwind and the power lines.NTSB CHI06FA218Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Boyceville, WIThe pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…NTSB NYC06MA192Accident · 1 fatalMajor investigationFinal reportEmbraer 110P1 · Pownal, VTThe pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…NTSB LAX06FA256Accident · 2 fatalField investigationFinal reportCessna 182P · Whitethorn, CAThe pilot's loss of situational awareness with regard to the airplane's proximity to mountainous terrain, and her failure to maintain an adequate terrain clearance altitude or flight path, which resulted in an in-flight collision with the terrain.NTSB ANC06LA109Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Anaktuvuk Pass, AKThe pilot's failure to abort the takeoff at his predetermined reference point, which resulted in a collision with the shore during takeoff-initial climb, and structural damage to the airplane.NTSB ANC06LA103Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Juneau, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…NTSB SEA06CA148Accident · No injuriesData collectionFinal reportCessna 172F · American Falls, IDThe pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.NTSB SEA06CA145Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Lamont, WAThe pilot's failure to maintain terrain clearance while maneuvering.NTSB LAX06FA243Accident · 2 fatalField investigationFinal reportRaytheon G36 · Bullhead City, AZThe pilot's misjudged distance and speed that led to a long landing, and his inadequate recovery from a bounced landing, all due to the effects of impairment from alcohol consumption, which resulted in an in-flight collision with terrain during an aborted…NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB NYC06CA173Accident · No injuriesData collectionFinal reportBell 47G-2 · Petersburg, WVThe passenger's inadvertent interference with the flight controls, which resulted in a loss of directional control and subsequent impact with the ground.NTSB LAX06FA222Accident · 2 fatalField investigationFinal reportRaytheon A36 · Somis, CAa ground collision during an emergency landing for undetermined reasons.NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB CHI06CA162Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Bowbells, NDThe pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.NTSB DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.NTSB LAX06FA206Accident · 4 fatalField investigationFinal reportCessna 180 · Payson, AZThe pilot's failure to maintain clearance from the terrain during a low level flyby maneuver. A factor was glare from the sun and shadows created by the mountainous terrain.NTSB LAX06LA205Accident · No injuriesLimited investigationFinal reportCessna 177B · Redwood City, CAA collision with water for undetermined reasons.