NTSB investigations, 1994
163 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\") = 1994
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") = 1994 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 LAX95LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-161 · Elko, NVThe pilot selected unsuitable terrain for takeoff.NTSB SEA95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, WAThe pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.NTSB LAX95LA047Accident · Serious injuriesLimited investigationFinal reportBenson B8M · Adelanto, CAthe pilot's inadequate compensation for the wind conditions during the downwind turn and his resulting failure to maintain adequate rotor rpm. A factor in the accident was the lack of an airspeed indicator.NTSB BFO95LA018Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sabinsville, PAThe pilot's inadequate visual lookout during cruise flight which resulted in inflight collision with wires.NTSB ATL95FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Statesboro, GAThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…NTSB LAX95FA046Accident · 2 fatalField investigationFinal reportMaule M-5-235C · Springville, CAthe pilot's entry into a box canyon at an altitude insufficient to maintain clearance from the surrounding terrain and obstacles. Factors in the accident were the high density altitude condition and the steep, rapidly rising nature of the mountainous terrain.NTSB ATL95LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Greer, SCThe pilot's failure to follow instrument approach procedures and his premature descent below the published decision height. A factor was pilot fatigue.NTSB NYC95LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Waldoboro, METhe pilot's premature lift off which resulted in insufficient climb performance and collision with trees.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB FTW95LA052Accident · No injuriesLimited investigationFinal reportCessna 172P · Blanco, TXThe pilot's use of unsuitable terrain for takeoff. Factors were the uphill terrain, the long vegetation, and short takeoff area available.NTSB SEA95LA023Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Yamhill, ORFailure of the pilot to maintain adequate altitude/clearance, while maneuvering to a hover, which allowed the external load cable/hook to become snagged and to rebound into the path of the main rotor blades.NTSB NYC95FA030Accident · 1 fatalField investigationFinal reportCessna 402C · Hyannis, MAthe pilot's failure to maintain a proper glide path during an ILS approach, which resulted in a collision with power lines. Factors in this accident were; adverse weather conditions with turbulence, down drafts and fog.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB FTW95LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Seguin, TXThe pilot's failure to attain a proper climb rate after takeoff. A factor was the dark night light condition.NTSB FTW95LA041Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Johnson City, TXThe pilot's failure to maintain clearance with the trailer while landing.NTSB CHI95LA037Accident · Minor injuriesLimited investigationFinal reportBeech G35 · Frankfort, ILFailure of the pilot to see-and-avoid the vehicle, and the vehicle driver's disregard for the need to remain clear of the aircraft's approach path. A factor related to the accident was: the proximity of a parked airplane to the runway.NTSB NYC95LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Dawson Springs, KYThe pilot's failure to maintain adequate obstacle clearance. Other related factors are night conditions and the pilot's improper inflight planning/decision.NTSB CHI95LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Tomahawk, WIthe collision with deer during landing - flare/touchdown.NTSB LAX95LA032Accident · Serious injuriesLimited investigationFinal reportBeech 65-90 · San Diego, CAthe inadvertent and premature deployment of the jumper's reserve parachute as he exited the aircraft.NTSB MIA95FA018Accident · 2 fatalField investigationFinal reportBölkow BO-105S · Perry, FLFailure of the pilot to maintain sufficient clearance from the power line, while buzzing (at low altitude).NTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.NTSB LAX95LA030Accident · Minor injuriesLimited investigationFinal reportBell UH-1E · Willits, CAthat the pilot misjudged the distance between the helicopter and the trees.NTSB ATL95FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Conway, SCThe pilot's failure to maintain a proper altitude during the missed approach, resulting in a collision with trees and terrain. Factors were the weather conditions (low ceiling, fog), and the pilot's diverted attention outside the cockpit.NTSB LAX95FA020Accident · 2 fatalField investigationFinal reportCessna T337H · Douglas City, CAThe improper in-flight decision of the pilot to fly in dark night time conditions in mountainous terrain during adverse weather conditions.NTSB MIA95FA010Accident · 2 fatalField investigationFinal reportCessna 182P · Raymond, MSThe pilot's impairment of judgment and performance due to alcohol, and his resulting failure to maintain altitude after takeoff.NTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.NTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.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 NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.NTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.NTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.NTSB FTW95LA011Accident · No injuriesLimited investigationFinal reportHughes 269C · Livingston, TXThe improper flare resulting in an undershoot of the intended landing area. A factor was the bird strike.NTSB BFO95FA001Accident · 1 fatalField investigationFinal reportCessna 172N · Fancy Gap, VAThe pilot's inadequate inflight planning and his failure to maintain adequate terrain clearance. Other related factors are: fog, rain, VFR flight into IMC, inexperience and mountainous terrain.NTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.NTSB CHI95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Carbondale, ILthe pilot's inadequate visual lookout, and improper altitude.NTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.NTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.NTSB LAX94LA379Accident · No injuriesLimited investigationFinal reportRockwell S2R · Visalia, CAthe pilot failed to maintain an adequate visual lookout and collided with power lines which resulted in an in-flight loss of control and subsequent collision with terrain.NTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.NTSB ANC94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's failure to maintain a positive rate of climb.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 MIA94LA210Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLThe pilot's failure to see and avoid the banner.NTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.NTSB NYC94LA171Accident · Serious injuriesLimited investigationFinal reportCessna 152-II · Enfield, NYThe pilot-in-command's attempt to take off under conditions beyond the performance capabilities of the airplane.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB LAX94LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rescue, CAThe pilot's delayed go-around. His inadequate compensation for the wind was a factor.