NTSB investigations, 1997
154 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\") = 1997
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") = 1997 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 FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.NTSB CHI98LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boone, IAfailure of the pilot to maintain sufficient altitude/clearance from obstruction(s), while flying low over a river. The obstruction (power line) was a related factor.NTSB CHI98LA126Accident · 1 fatalLimited investigationFinal reportCessna 177 · Ft. Leonardwood, MOThe pilot's failure to maintain adequate obstacle clearance and his inadequate inflight decision which resulted in VFR flight in to instrument meteorological conditions. The pilot's overconfidence in his ability is a contributing factor.NTSB NYC98LA051Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Albany, OHthe pilot's improper in-flight planning/decision and failure to turn off the carburetor heat during the go-around. Related factors were: the pilot's lack of experience in make and model, and the proximity of trees.NTSB LAX98LA054Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stoil, CAThe pilot's failure to maintain adequate obstacle clearance and his inadequate visual outlook.. Factors were a severed fuel line which resulted in an in-flight fire, which diminished the pilot's ability to land the airplane with smoke and fire in the cockpit.NTSB FTW98LA075Accident · 1 fatalLimited investigationFinal reportCessna 172M · Monticello, UTThe pilot's failure to maintain adequate altitude and clearance from obstacles. Also causal was the pilot becoming lost and disoriented. Contributing factors were his lack of familiarity with the geographical area, lack of experience, night conditions, and…NTSB ATL98FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Tallahassee, FLThe pilot's failure to maintain the proper glidepath and adequate obstacle clearance which resulted in collision with a power transmission line.NTSB IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.NTSB ATL98LA027Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Monticello, FLthe pilot's inadequate preflight planning/preparation, and failure to ensure that the airplane would be able to clear trees during takeoff. Related factors were: the high/wet vegetation on the grass runway, and the proximity of trees to the runway.NTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.NTSB FTW98FA068Accident · 4 fatalField investigationFinal reportBell 407 · Littleton, COThe pilot's inability to maintain adequate visual lookout due to the lighting conditions and his failure to follow company procedures for departure from a landing zone. Factors were dark night conditions, bright lights in the landing zone which prevented…NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.NTSB ATL98FA023Accident · 1 fatalField investigationFinal reportBeech A100 · Charlotte, NCThe pilot's continued approach below decision height without reference to the runway environment, and his failure to execute a missed approach.NTSB ATL98LA021Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Bushnell, FLThe pilot's failure to maintain clearance from the trees during a hover. A factor was the pilot's diverted attention.NTSB SEA98LA020Accident · Minor injuriesLimited investigationFinal reportSchramm Helicycle · Big Timber, MTthe pilot's failure to maintain clearance from power lines. The pilot's diverted attention and transmission wires were factors.NTSB MIA98FA039Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Lansing, NCthe pilot's failure to maintain clearance from a wire.NTSB CHI98LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, ILthe pilot's failure to see-and-avoid the powerlines on short final. The location of the powerlines was a related factor.NTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB NYC98LA029Accident · Serious injuriesLimited investigationFinal reportBeech E33A · Westminster, MDthe pilot's improper in-flight planning/decision, his misjudgment of speed and distance while on final approach to land, and his delay in aborting the landing after failing to attain a proper touchdown point for landing.NTSB FTW98FA067Accident · 1 fatalField investigationFinal reportCessna 180 · Johnson City, TXThe pilot's failure to maintain obstacle clearance. Factors were the low ceilings, dark night light conditions, and the pilot's lack of visible horizon in the unpopulated area.NTSB MIA98LA026Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Cummings, GAthe pilot landed the airplane with a tailwind condition, too long and too fast for the runway conditions.NTSB SEA98LA013Accident · No injuriesLimited investigationFinal reportBell 206B · Forest Grove, ORExcessive deceleration of the helicopter by the pilot-in-command, resulting in an in-flight main rotor blade strike on the helicopter's external load line and subsequent main rotor separation. Downhill terrain which led to a descending approach to the pickup…NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB FTW98FA028Accident · 1 fatalField investigationFinal reportWeatherly 620B · Cee Vee, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight.NTSB ATL98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Blakley, GAthe pilot misjudge clearance from trees during pull-up from a swath run. The obstructions (power line and trees) were related factors.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB SEA98LA003Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Galata, MTThe pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…NTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…NTSB ANC98LA003Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sutton, AKThe pilot's failure to maintain clearance between the tail rotor and the external long line cable, and the subsequent entanglement of the tail rotor with the long line.NTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.NTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.NTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW98LA006Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Plains, TXThe pilot's improper decision to initiate takeoff with a vehicle on the runway.NTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.NTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).NTSB SEA97IA217Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Soda Springs, IDThe pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…NTSB ANC97LA154Accident · No injuriesLimited investigationFinal reportCessna 170B · Lime Village, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW97LA354Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Houma, LAThe loss of aircraft control resulting from a bird strike that severed the cyclic flight control.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).NTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.NTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.NTSB FTW97LA347Accident · No injuriesLimited investigationFinal reportHughes MDL-369HS · Brinkley, ARThe in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…NTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.NTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.NTSB SEA97LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Harrah, WAThe pilot's failure to maintain clearance from a transmission wire while on final approach. A factor was a 40-foot high transmission wire located approximately 20 feet from the end of the airstrip.