Fatal NTSB investigations
1,358 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 81 |
|---|---|
| 1983 | 60 |
| 1984 | 74 |
| 1985 | 67 |
| 1986 | 54 |
| 1987 | 54 |
| 1988 | 52 |
| 1989 | 62 |
| 1990 | 59 |
| 1991 | 51 |
| 1992 | 68 |
| 1993 | 49 |
| 1994 | 45 |
| 1995 | 51 |
| 1996 | 40 |
| 1997 | 45 |
| 1998 | 49 |
| 1999 | 50 |
| 2000 | 49 |
| 2001 | 51 |
| 2002 | 39 |
| 2003 | 46 |
| 2004 | 41 |
| 2005 | 39 |
| 2006 | 44 |
| 2007 | 38 |
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 c.\"highestInjuryLevel\" = 'Fatal'
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 c."highestInjuryLevel" = 'Fatal' 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 NYC08FA056Accident · 1 fatalField investigationFinal reportBeech H35 · Warrenton, VAThe pilot's failure to follow the published instrument approach procedure and his failure to maintain the minimum descent altitude which resulted in collision with trees and terrain. Contributing to the accident were the night, instrument meteorological…NTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.NTSB DEN08FA036Accident · 1 fatalField investigationFinal reportCessna 182Q · Farmerville, LAThe pilot's failure to maintain aircraft control due to the effects of impairment from alcohol consumption resulting in the collision with the trees.. A contributing factor was the Federal Aviation Administration's failure to identify existing evidence of…NTSB NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.NTSB CHI08LA037Accident · 2 fatalLimited investigationFinal reportPadelt PG37-1 · Hampton, IAThe pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.NTSB NYC08FA026Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Jamestown, TNThe pilot’s failure to maintain clearance from a known wire hazard during takeoff.NTSB CHI08FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Browerville, MNAn in-flight collision with at least one Canada goose, and the resulting damage to the left stabilator that caused the airplane to become uncontrollable. Contributing to the accident was the night lighting condition, which precluded any possibility of the…NTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.NTSB SEA07FA262Accident · 3 fatalField investigationFinal reportBeech A-36TC · Burlington, WAThe pilot's decision to descend below the published minimum descent altitude (MDA), and his failure to maintain clearance from vertical objects during an instrument approach. Contributing to the accident were low ceilings, inadequate preflight planning, and…NTSB NYC07CA215Accident · 1 fatalData collectionFinal reportEbersole Hummel Ultra Cruiser · Newry, PAThe pilot's failure to maintain adequate clearance from trees while maneuvering.NTSB ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB LAX07TA227Accident · 1 fatalFinal reportBell 205 A1++ · Happy Camp, CAthe pilot's failure to maintain clearance with the trees during a long-line operation. Contributing factors were the Forest Service's inadequate communication between crews, failure to properly assess the safety of the intended drop zone, reduced visibility…NTSB DFW07LA170Accident · 1 fatalLimited investigationFinal reportHazen Fly Baby · Page, OKThe airplane's collision with wooded and mountainous terrain for undetermined reasons.NTSB CHI07LA208Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Osceola, INThe pilot's failure to maintain clearance with the trees during the aerial application flight. Factors associated with the accident were the trees and the pilot's lack of experience in flying aerial application flights.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB CHI07FA187Accident · 2 fatalField investigationFinal reportCessna 500 · Conway, ARThe pilot's failure to fly a stabilized approach and his delayed decision to abort the landing. Contributing to the accident was the standing water on the runway.NTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.NTSB SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB SEA07LA249Accident · 1 fatalLimited investigationFinal reportCessna 177 · Pinecliff, WAThe pilot's failure to maintain clearance from the trees while maneuvering in mountainous terrain. Factors include the mountainous terrain, low ceilings, and trees in the area where the pilot was maneuvering.NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB CHI07LA147Accident · 1 fatalLimited investigationFinal reportThrush S2RHG-T65 · Tyndall, SDThe pilot not maintaining altitude/clearance from a powerline while maneuvering. A factor was the low visibility associated with the thunderstorm and the powerlines.NTSB LAX07LA168Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Colusa, CAThe pilot's failure to maintain clearance from wires.NTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB LAX07LA126Accident · 1 fatalLimited investigationFinal reportArbc 150A · Mecca, CAThe pilot's decision to fly in forecasted unfavorable wind conditions that exceeded the balloon's capabilities.NTSB ATL07FA069Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Andrews, NCThe pilot's misjudgment of distance and altitude during a night approach for landing, resulting in an in flight collision with wires and the ground.NTSB LAX07LA122Accident · 1 fatalLimited investigationFinal reportScottish Bulldog 120 · So Lake Tahoe, CAThe pilot's failure to maintain clearance from objects and the mountainous terrain.NTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.NTSB CHI07FA069Accident · 2 fatalField investigationFinal reportEurocopter France EC120B · Gulf of MexicoThe pilot's inadequate compensation for the gusty wind conditions which resulted in his failure to maintain clearance with the structure extending from the offshore oil platform. Contributing to the accident was the gusty wind condition.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB ATL07FA031Accident · 3 fatalField investigationFinal reportCessna 182P · Columbia, SCThe pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.NTSB DFW07FA051Accident · 2 fatalField investigationFinal reportCessna 182R · Batesville, ARThe pilot's failure to maintain clearance from trees. A contributing factor to the accident was the prevailing low ceilings.NTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.NTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.NTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.NTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.NTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…NTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.NTSB NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB DCA07MA003Accident · 2 fatalClass 1 · MajorFinal reportCirrus Design SR-20 · Manhattan, NYC, NYThe pilots' inadequate planning, judgment, and airmanship in the performance of a 180º turn maneuver inside of a limited turning space.NTSB LAX06LA292Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-103A Twin II Acro · Minden, NVThe inadequate pre-takeoff checks by the flightcrew that failed to detect that the spoilers were deployed during the takeoff and initial climb. Also causal was the inadequate supervision of the flight by the flight instructor.NTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.NTSB SEA06GA158Accident · 4 fatalFinal reportEurocopter AS-350-B3 · Yellow Pine, IDThe pilot's intentional low altitude flight and his failure to maintain an adequate altitude to clear the trees.