NTSB investigations, 1999
164 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\") = 1999
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") = 1999 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 CHI00LA051Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Orleans, NEthe pilot's failure to maintain adequate clearance from the power line. The power line was a factor.NTSB NYC00FA057Accident · 1 fatalField investigationFinal reportCessna 152 · N. Stonington, CTThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the pilot's lack of recent flight experience.NTSB NYC00LA052Accident · No injuriesLimited investigationFinal reportCessna P210N · Greenwood, DEthe failure of the pilot to use full power for takeoff, which resulted in not obtaining a positive rate of climb and the inadvertent collision with trees. A factor was the fog.NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB IAD00LA013Accident · Serious injuriesLimited investigationFinal reportRogers RAF 2000 · Franklin, NYwas the pilot's failure to abort the takeoff due to inadequate rotor rpm.NTSB ANC00LA016Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F-19 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area. Factors associated with the accident were snow-covered terrain, and a tree.NTSB MIA00LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pelzer, SCThe student pilot's failure to recognize and compensate for changing wind conditions while on final approach and landing and his failure to initiate a timely go-around, resulting in collision with trees and a utility pole.NTSB SEA00LA028Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Salem, ORFailure of the pilot to maintain ground clearance, resulting in the long-line snagging and then striking the tail rotor.NTSB SEA00LA027Accident · Serious injuriesLimited investigationFinal reportBeech B-19 · Grand Coulee, WAThe pilot's failure to maintain clearance from power transmission lines. Factors include dark night conditions.NTSB MIA00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.NTSB FTW00LA037Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the go-around. A factor was the gust of wind.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.NTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.NTSB NYC00LA033Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Fayetteville, WVThe pilot's decision to continue the landing attempt too far down the runway. A factor was the pilot's self-induced pressure to land the airplane, due to the sickness of the front seat passenger.NTSB FTW00LA024Accident · No injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot's failure to maintain clearance with the powerlines.NTSB IAD00FA003Accident · 1 fatalField investigationFinal reportCoughlin LONG-EZ · Remington, VAthe pilot's failure to maintain adequate altitude/clearance from the trees while maneuvering at low altitude.NTSB LAX00LA027Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Castroville, CAThe pilot's inadequate visual lookout and diverted attention.NTSB NYC00FA020Accident · 2 fatalField investigationFinal reportCessna 210L · Medina, OHThe pilot's failure to maintain proper altitude during the final approach segment of the visual approach. A factor was the diminishing light conditions of a deepening dusk.NTSB CHI00LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Waukon, IAthe pilot failed to maintain directional control of the airplane during the aborted landing. Factors relating to the accident included the crosswinds, the fence, and the trees.NTSB CHI00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Crandon, WIthe deer that ran out onto the runway and collided with the airplane. A factor associated with the accident was the night lighting conditions.NTSB FTW00LA015Accident · 2 fatalLimited investigationFinal reportSturges Spezio Sport · Mathis, TXthe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB CHI00LA015Accident · Serious injuriesLimited investigationFinal reportWelch Murphy Rebel · Saint Johns, MIthe pilot not maintaining altitude and clearance. Factors were the trees, the flap control not fully engaged, and the pilot's lack of total experience in the kind of airplane flown.NTSB ATL00LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Arecibo, PRThe pilot's failure to maintain altitude clearance during final approach to landing. A factor was the hay bundles.NTSB ANC00LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Gambell, AKAn in-flight collision with a bird.NTSB ANC00LA004Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Soldotna, AKAn in-flight collision with a bird.NTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.NTSB FTW00LA005Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Brownfield, TXThe pilot's failure to maintain clearance with power wires while maneuvering during an aerial application flight. A factor was the sunglare.NTSB NYC00FA004Accident · 1 fatalField investigationFinal reportCessna 182R · Killingworth, CTThe pilot's failure follow the published instrument approach procedure. A factor in the accident was the low cloud ceiling.NTSB SEA00FA001Accident · Minor injuriesField investigationFinal reportde Havilland DHC-2 Mark 1 · Port Blakely, WAThe pilot-in-command's failure to maintain adequate clearance from trees/terrain. Contributing factors were rising terrain and trees.NTSB MIA99FA269Accident · 1 fatalField investigationFinal reportPiper PA-31P · Louisville, MSThe pilot's disregard for the published minimum descent altitude resulting in tree contact and separation of 51 inches of the left wing. Findings in the investigation were the pilot's two failures of the ATP checkride in a multiengine airplane.NTSB FTW99LA255Accident · No injuriesLimited investigationFinal reportBell OH-58A · Ratcliff, TXThe pilot's failure to maintain clearance with the tree while maneuvering during an aerial application flight. Factors were the sunglare, and the pilot's diverted attention while adjusting the GPS receiver.NTSB DEN99LA171Accident · No injuriesLimited investigationFinal reportRobinson R22 · St. George, UTThe pilot's inadequate visual lookout. Factors included the pilot concentrating on the maneuver being practiced to such an extent that he was inattentive to outside surroundings, and the sun glare.NTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.NTSB IAD99FA069Accident · Serious injuriesField investigationFinal reportCessna 150M · Ellicott City, MDthe flight instructor's failure to follow the balked landing procedure in the owner's manual by retracting the flaps from 40 degrees to zero degrees.NTSB SEA99LA173Accident · No injuriesLimited investigationFinal reportCessna 150M · Camas, WAA misjudged approach and inadequate airspeed. Sunglare, a delayed decision to go-around, and not maintaining clearance from a fence were factors.NTSB NYC99GA234Accident · Serious injuriesFinal reportBell 206L-1 · Randolph, NYThe pilot's failure to maintain visual separation from the wires. A factor was sunglare.NTSB MIA99FA263Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Moreland, GAThe pilot's failure to maintain the minimum descent altitude while executing a localizer approach. Contributing factors were low ceilings and dark night conditions as well as the trees.NTSB DEN99LA163Accident · No injuriesLimited investigationFinal reportRobinson R22A · Tucumcari, NMThe pilot's inadequate visual lookout. A factor was a reduced visual detection due to background vegetation and terrain.NTSB NYC99LA224Accident · 1 fatalLimited investigationFinal reportNorth American T6-G · Falmouth, KYThe pilot's misjudgment of altitude/clearance on approach which resulted in an in-flight collision with trees.NTSB ATL99FA127Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Carthage, MSThe pilot-in-command's failure to maintain altitude clearance while maneuvering. A factor was the pine trees.NTSB LAX99TA299Accident · Minor injuriesFinal reportBell B212 · Bakersfield, CAThe failure of the pilot-in-command to maintain adequate visual surveillance to see and avoid power transmission wires known to be in the area.NTSB LAX99FA301Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Strathmore, CAThe failure of the pilot to maintain an adequate terrain and obstacle clearance altitude, which resulted in a collision with power transmission wires.NTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.NTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.NTSB SEA99LA153Accident · No injuriesLimited investigationFinal reportCessna 210B · Dixie, IDInadequate airspeed and clearance was not maintained. Mountainous conditions, trees, and an inadequately planned approach were factors.NTSB FTW99LA252Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Seminole, TXThe pilot's failure to maintain clearance with powerlines. A factor was the pilot's diverted attention to the light bar for the electronic swath guidance system installed in the airplane.NTSB CHI99FA332Accident · 1 fatalField investigationFinal reportPiper PA-12 · Neguanee, MIthe pilot failed to maintain clearance from the tower.NTSB SEA99FA152Accident · 3 fatalField investigationFinal reportCessna T210M · Marcola, ORThe pilot's failure to maintain clearance from the terrain while descending in an area of deteriorating weather. Factors include mountainous terrain, clouds, low ceilings, the pilot's inadequate preflight weather analysis, and his improper decision to attempt…NTSB NYC99FA213Accident · 3 fatalField investigationFinal reportCessna 172N · Sussex, NJThe pilot's improper decision to takeoff with a tailwind. Factor's in this accident were the tailwind condition and pressure to depart caused by other airplanes performing successful downwind departures.