NTSB investigations, 1990
181 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\") = 1990
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") = 1990 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 CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.NTSB SEA91LA033Accident · 1 fatalLimited investigationFinal reportErco 415-C · Ola, IDThe pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.NTSB ATL91LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hickory, NCThe pilots's inadequate visual lookout during flight. A factor in the accident was the pilot's failure to maintain a safe altitude.NTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB BFO91LA016Accident · 1 fatalLimited investigationFinal reportCessna 172P · Axton, VAThe pilot's failure to maintain adequate clearance with an obstacle. Contributing was an unmarked powerline and the pilot's lack of familiarity with the geographical area.NTSB MIA91FA035Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bunnell, FLFailure of the pilot to maintain altitude, while maneuvering at night over an unlighted area, which resulted in a collision with trees. Factors related to the accident were: darkness and possible spatial disorientation of the pilot due to lack of visual ques.NTSB SEA91LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Mulina, ORIn-flight collision with a rebounding long-line, which caused main-rotor RPM decay and tail-boom separation, compromising the pilot's ability to successfully accomplish an attempted autorotation.NTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.NTSB CHI91LA030Accident · No injuriesLimited investigationFinal reportCessna 177 · Mount Ayr, IAProper touch-down point not attained and go-around delayed by the PIC. Contributing factors were a downwind, crosswind, weather evaluation misjudged, wrong runway selected and lack of total experience by the PIC.NTSB LAX91LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Young, AZThe pilot selected the wrong runway and attempted to land with a tailwind.NTSB CHI91FA031Accident · 4 fatalField investigationFinal reportPiper PA-32-RT300 · Gaylord, MIThe pilot's failure to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night, adverse weather conditions, and the pilot's overconfidence in continuing VFR flight into these conditions.NTSB SEA91LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Boise, IDThe pilot's delaying remedial action after a poor landing approach.NTSB MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB ANC91LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Thorne Bay, AKThe pilot's delay in aborting the takeoff.NTSB NYC91LA024Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Buckland, MAThe pilot's failure to execute an aerobatic maneuver at an altitude sufficient to clear the stand of trees.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB NYC91LA022Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sherburne, NYThe pilot failed to maintain adequate altitude to outclimb surrounding terrain.NTSB NYC91LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Columbia, PAThe failure of the pilot to maintain a proper altitude on final approach and compensate for the headwind. A factor to the accident was the failure of the pilot to recognize his low altitude and execute a go-around.NTSB CHI91LA020Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180D · Crivitz, WIImproper planning/decision by the pilot, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB DEN91FA012Accident · 2 fatalField investigationFinal reportCessna T210M · Carbondale, COFailure of the pilot to see-and-avoid the power line.NTSB LAX91FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Goleta, CAThe pilot's failure to maintain proper glidepath while on final approach. A contributing factor was sunglare.NTSB LAX91LA011Accident · No injuriesLimited investigationFinal reportBeech C35 · Independence, CAThe pilot's failure to attain an altitude adequate to avoid colliding with ojbects during takeoff.NTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB FTW91DPG01Accident · Minor injuriesFinal reportCessna A-188 · Manila, ARThe pilot's failure to maintain proper clearance from power lines and the inadvertent stall.NTSB FTW91GA001Accident · No injuriesFinal reportMcdonnell Douglas 369E · Anadarko, OKFailure of the pilot to maintain proper visual lookout prior to and during departure.NTSB FTW90DQG05Accident · No injuriesFinal reportCessna T188C · Nazareth, TXThe pilot's failure to maintain obstacle clearance.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 CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB LAX90FA332Accident · 4 fatalField investigationFinal reportCessna 500 · San Luis Obispo, CAThe pilot's improper IFR (instrument) procedure, and his failure to maintain the minimum descent altitude (mda) for the approach. The adverse weather was a related factor.NTSB CHI90LA270Accident · Serious injuriesLimited investigationFinal reportBeech F-33A · Osage Beach, MOThe pilot's failure to establish a proper glide path, resulting in contact with trees short of the intended runway.NTSB DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.NTSB LAX90LA324Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Watsonville, CAImproper handling of the aircraft by the student pilot, which resulted in his failure to attain sufficient airspeed to climb after takeoff, and the instructor's (cfi's) inadequate supervision.NTSB LAX90DUJ08Accident · Serious injuriesFinal reportRockwell S-2R · Yuma, AZFailure of the pilot to select a cruise altitude which would ensure adequate clearance from obstructions. A factor in the accident was the dark night which inhibited the pilot's ability to see the obstruction.NTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.NTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.NTSB ATL90LA168Accident · Serious injuriesLimited investigationFinal reportSchleicher ASK-21 · Memphis, TNAn inflight collision with a tree due to misjudging his glidepath.NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB MIA90LA179Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Geneva, FLThe pilots failure to retract the flaps to the takeoff setting during a touch-and-go landing.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.NTSB DEN90LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Canon City, COThe pilot's failure to maintain an adequate pattern altitude and the possible existence of adverse winds due to the surrounding terrain.NTSB FTW90LA174Accident · Minor injuriesLimited investigationFinal reportCessna C172N · Marietta, OKFailure of the pilot to attain the proper climb rate after takeoff resulting in the aircraft colliding with trees at the departure end of the runway. Contribuing to the accident was the pilot in commands failure to account for high density altitude.NTSB FTW90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denver City, TXThe pilot's improper leaning of the fuel mixture.NTSB DEN90FA176Accident · 1 fatalField investigationFinal reportCameron O-84 · Taos, NMThe pilot's improper decision to attempt a go-around. A factor was the unfavorable wind encountered late in the attempted landing.NTSB CHI90LA242Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Blissfield, MIThe pilot's inadequate visual lookout which resulted in a collision with a utility wire.