NTSB investigations, IN
68 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 7 |
| 1987 | 3 |
| 1988 | 10 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2006 | 2 |
| 2007 | 4 |
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.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' 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 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 CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB CHI07LA095Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Austin, INThe pilot's improper preflight planning/preparation, and his failure to abort the takeoff. Contributing factors were a tailwind and a short runway.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 CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB CHI06FA117Accident · 5 fatalField investigationFinal reportCessna U206G · Bloomington, INThe pilot's continued descent below decision height and not maintaining adequate altitude/clearance from the trees while on approach. Factors were the the night lighting conditions, and the mist.NTSB CHI04LA279Accident · Serious injuriesLimited investigationFinal reportErnst Pitts S2E · Hanover, INThe pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.NTSB CHI04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Fishers, INThe pilot not maintaining altitude/clearance from the trees during the circling approach, his continued descent below minimum descent altitude, and the pilot not performing a missed approach. A factor was the trees the pilot impacted during the circling…NTSB CHI03LA241Accident · 1 fatalLimited investigationFinal reportYoung Pietenpol Air Camper · Peru, INThe pilot not maintaining altitude/clearance from the trees during the landing. A factor was the trees he impacted.NTSB CHI03LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Evansville, INThe pilot's failure to attain the proper touchdown point. The barrels were a factor.NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB CHI02LA157Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Fishers, INThe pilot not performing a go-around prior to exceeding the proper touchdown point and the pilot not maintaining altitude/clearance from the trees. Factors to the accident were the pilot's inadequate preflight planning and the trees.NTSB CHI02LA055Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Elkhart, INThe pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.NTSB CHI01FA256Accident · 2 fatalField investigationFinal reportBeech E55 · Rensselaer, INthe pilot's ostentatious display when he buzzed the farmstead and did not maintain clearance from the barn.NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB CHI01FA032Accident · 1 fatalField investigationFinal reportSwearingen SA226TC · Fort Wayne, INThe indicated failure of the right hand AC bus during takeoff with low ceiling. The factors were the low ceiling, night, and the execssive workload the pilot experienced on takeoff with an electrical failure without a second in command.NTSB CHI00LA279Accident · 1 fatalLimited investigationFinal reportMockler Zodiac CH-600 · Carmel, INthe pilot not maintaining altitude/clearance from the tower. A factor was the tower.NTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…NTSB CHI99FA075Accident · 2 fatalField investigationFinal reportBeech BE-55 · Elkhart, INthe pilot failed to maintain a proper glidepath and obstacle clearance. Factors were the fog and dark night.NTSB CHI98LA332Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Decker, INThe pilot's failure to maintain obstacle clearance resulting in a collision with a fence.NTSB CHI98LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Laporte, INwas the student pilot s inadequate compensation for the wind conditions he encountered during the landing phase. A factor in this accident was the pilot s lack of total experience.NTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.NTSB CHI97LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, INimproper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.NTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.NTSB CHI96FA095Accident · 1 fatalField investigationFinal reportCessna 310 · Portland, INthe pilot's failure to maintain an altitude adequate for terrain clearance. A factor was the weather.NTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.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 CHI95LA016Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Ft. Wayne, INthe in-flight collision with birds(geese). A factors associated with the accident was the building which was contacted.NTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.NTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.NTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.NTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB CHI90LA277Accident · 1 fatalLimited investigationFinal reportNavion L-17A · Fort Wayne, INPoor judgement of the pilot due to impairment from consumption of alcohol and use of a drug, and his failure to maintain proper altitude/clearance above wooded terrain. Darkness was a related factor.NTSB CHI89FA196Accident · 3 fatalField investigationFinal reportBeech A36TC · Greencastle, INFailure of the pilot to maintain proper altitude during a visual approach at dusk. Factors related to the accident were: light conditions at dusk, the pilot's visual perception, and the trees.NTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.NTSB CHI89DEX02Accident · No injuriesFinal reportCessna 172 · Greencastle, INInflight collision with a large bird.NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB CHI88DET06Accident · 1 fatalFinal reportJones None · Elkhart, INInadequate aircraft design which resulted unacceptable aircraft takeoff and climb capability.NTSB CHI88FA203Accident · 2 fatalField investigationFinal reportPiper PA-20 · Claypool, INPilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree.NTSB CHI88FA198Accident · 2 fatalField investigationFinal reportPiper PA-28 · Auburn, INFlight known adverse weather conditions.NTSB CHI88DEX11Accident · 1 fatalFinal reportContinental Copters MK-5 · Redkey, INPhysical impairment of the pilot due to drugs which resulted in a misjudged approach and subsequent contact with trees during the approach to an aerial application swath run.NTSB CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…NTSB CHI88DEX02Accident · Serious injuriesFinal reportLogan Junior ACE · Cloverdale, INDuring approach, the aircraft struck power lines near the approach end of runway and crashed on the runway. The pilot had less than 1 hour flight time in this model homebuilt aircraft.NTSB CHI88FA067Accident · 2 fatalField investigationFinal reportGrumman American AA-5A · Martinsville, INPilot to take into caonsideration the wind direction and velocity before selecting his takeoff direction.NTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…NTSB CHI87LA215Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Belleville, INThe aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…NTSB DEN87FA218Accident · 2 fatalField investigationFinal reportCessna 172C · Switz City, INAfter departing the bloomfield arpt, the plt flew with his family over a coal mine area where he had done reclamation work. Witnesses at the mine stated that they observed the acft fly low over the mine pits & that the plt waved at them. The acft departed,…NTSB CHI87LA072Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Martinsville, INWhile landing to the east the plt was blinded by the sun and the acft struck telephone wires.NTSB CHI87DEX04Accident · Serious injuriesFinal reportAero Commander 500B · Hagerstown, INThe pilot was on the fourth leg of a night cargo flight cruising at approximately 500' AGL enroute to Mt. Vernon, IL, when the aircraft struck some trees and subsequently collided with the ground. The engines and propellers were both torn down and tested and…