NTSB investigations, 1989
203 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\") = 1989
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") = 1989 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 FTW90LA047Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Stephenville, TXImproper planning/decision by the pilot.NTSB ANC90FA021Accident · 1 fatalField investigationFinal reportPiper PA-31 · Beluga, AKFailure of the pilot to maintain proper altitude. Darkness and adverse weather conditions were related factors.NTSB ATL90FA038Accident · 3 fatalField investigationFinal reportCessna T210N · Spindale, NCThe pilot-in-command's improper IFR procedure which resulted in descent below the minimum descent altitude. Contributingfactor(s) was: the fog and low ceiling.NTSB CHI90LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe dual student did not maintain proper glidepath and his misjudgment for compensation for wind conditions resulted in a collision with utility wires. The cfi's inadequate supervision during the duel flight operation contributed to the accident.NTSB DEN90FA028Accident · 1 fatalField investigationFinal reportAerospatiale SA316B · Park City, UTFailure of the pilot to make a vertical takeoff, while departing with a cable attached, and his failure to insure the cable remained clear of the trailer. The trailer (vehicle) was a contributing factor.NTSB LAX90LA041Accident · Serious injuriesLimited investigationFinal reportBarnes AX-7 · Sun City, AZInadequate visual lookout by the student pilot (his failure to see & avoid). The transmission line and the student's lack of familiarity with the area were related factors.NTSB SEA90FA021Accident · 2 fatalField investigationFinal reportBeech B35 · Bremerton, WAThe pilot's improper IFR procedure, his failure to maintain proper alignment on the ILS approach, and his failure to initiate a missed approached after reaching the lateral limits of the ILS system or decision height. Darkness and deteriorating weather were…NTSB SEA90LA016Accident · 1 fatalLimited investigationFinal reportHughes 269C · Estacada, ORThe pilot misjudged clearance between her external load and the obstruction. Factors related to the accident were: the obstruction, improper maintenance and modification of the external load line/hook by the operator, failure of the pilot to jettison the…NTSB BFO90LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Front Royal, VAFailure of the instructor pilot (CFI) to maintain proper runway alignment with the runway. Contributing factors were: the student pilot's high and fast approach, the cfi's delay in initiating remedial action, the crosswind, and the runwaylight.NTSB NYC90LA028Accident · No injuriesLimited investigationFinal reportCessna 205 · Morristown, NJIn-flight collision with object.NTSB BFO90LA021Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Paint Bank, VAThe pilot's improper inflight planning which led to an off-airport landing after encountering deteriorating lift conditions. Contributing factors were the mountainous terrain and lack of a suitable landing area.NTSB DEN90FA022Accident · Serious injuriesField investigationFinal reportCessna 182F · Oakley, UTThe pilot diverted his attention, misjudged his altitude and failed to maintain clearance above the trees, while maneuvering at low altitude over mountainous terrain. The mountainous terrain, high density altitude, low airspeed, and trees were contributing…NTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.NTSB FTW90FA024Accident · Serious injuriesField investigationFinal reportCameron V-77 · Tornillo, TXMechanical failure of the ignitor system, and failure of the pilot to use emergency burner relight procedures.NTSB LAX90LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · S. Juan Batista, CAThe pilot's intentional buzzing and failure to see and avoid a guy wire.NTSB FTW90LA021Accident · Minor injuriesLimited investigationFinal reportCameron N-105 · Bryan, TXPilot's misjudgement/compensation for the wind change and his delayed response in initiating a climb in order to clear the tower.NTSB MIA90LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Immokalee, FLFailure of the pilot to maintain proper altitude and his failure to maintain adequate visual lookout to see and avoid obstructions. The static line (obstruction) was a contributing factor.NTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.NTSB LAX90LA012Accident · No injuriesLimited investigationFinal reportCulver VEE · Santa Paula, CAThe pilot's failure to maintain sufficient airspeed for a positive rate of climb.NTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.NTSB BFO90LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Churchville, MDThe pilot not maintaining adequate clearance from the wind sock during an aborted landing. A contributing factor was the presence of another aircraft.NTSB NYC90LA018Accident · No injuriesLimited investigationFinal reportMaule M-5 · Plattsburgh, NYThe pilot's inadequate preflight planning to assure clearance from the surrounding brush.NTSB ATL90DKJ02Accident · No injuriesFinal reportBell 47G2 · Wettumpka, ALThe pilot's failure to avoid obstacles during aerial application maneuvering.NTSB LAX90FA017Accident · 2 fatalField investigationFinal reportBeech F35 · Lake Berryessa, CAInadequate visual lookout by the pilot and his failure to maintain proper altitude. The power lines was a related factor.NTSB DEN90FA013Accident · 2 fatalField investigationFinal reportCessna T210L · Penasco, NMImproper inflight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were: failure of the pilot to obtain (and/or understand) wind aloft information, his lack of…NTSB MKC90FA017Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Elkader, IAThe pilot's failure to maintain clearance from the runway marker at the departure end of the runway.NTSB ATL90LA012Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Knightdale, NCThe pilot's failure to maintain the proper glide path to the runway resulting in the airplane colliding with trees while making an approach to landing with no electrical power.NTSB ATL90LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAInadequate visual lookout by the pilot (failure to see & avoid the obstruction). Contributing factors were the transmission (power) line and lack of visual cues (pilot's visual perception).NTSB DEN90LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Albuquerque, NMImproper planning/decision by the pilot. Factors related to the accident were: the pilot's lack of familiarity with the aircraft, his failure to use the recommended flap extension, his failure to maintain an airspeed above the automatic gear extension speed…NTSB MKC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Yates Center, KSThe pilot's selection of the wrong direction to attempt a takeoff which resulted in the inability to climb sufficiently to aviod trees.NTSB CHI90LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedarburg, WIDelay of the flight instructor (CFI) in making a go-around and his failure to attain sufficient airspeed to climb after taking off again. The transmission wire (power line) and high vegetation were contributing factors.NTSB CHI90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MIInadequate supervision of the flight by the flight instructor (CFI), failure of both the student and the CFI to see-and-avoid the static line, and failure of the pilots to maintain adequate clearance from the power line/static wire. The static wire was a…NTSB NYC90FA011Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Glastonbury, CTThe pilot-in-command's failure to maintain adequate altitude control during maneuvering flight. Contributing to the accident was the failure of the airplane's electrical system and the pilot's operation at night, without emergency lighting (flashlight).NTSB MKC90FA005Accident · 2 fatalField investigationFinal reportPiper PA-28 · Delavan, MNFailure of the pilot to maintain proper altitude during a low pass, and to see-and-avoid obstructions (inadequate visual lookout). Factors related to the accident were: the pilot's ostentatious display and the obstructions (powerlines).NTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.NTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.NTSB FTW90FA005Accident · 5 fatalField investigationFinal reportCessna 208 · Uncertain, TXImproper planning/decision by the pilot-in-command, and failure of the aircrew to maintain runway alignment and clearance from the high obstructions (trees) beside the runway. Related factors were: weather conditions, dark night, lack of runway edge lights,…NTSB ATL90DLG01Accident · 1 fatalFinal reportCessna 188B · Hartsville, SCThe failure of the pilot to maintain adequate in-flight clearance from obstacles.NTSB LAX90LA004Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pacoima, CAThe pilot's misjudgement of the proper altitude and distance from the runway during a night approach.NTSB FTW90FA002Accident · 2 fatalField investigationFinal reportCessna 550 · Hurdle Mills, NCImpairment of the pilot-in-command (PIC) due to drugs/medication, chemotherapy and fatigue; failure of the PIC to assure that the IFR (instrument) apch procedure was followed; and his failure to maintain the minimum descent altitude (mda). Inadequate…NTSB CHI90LA001Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Manistique, MIA delayed by the pilot in going around and his failure to obtain adequate airspeed before fully retracting the flaps, which allowed the aircraft to mush. The contributing factors were: the pilot's failure to attain the proper touchdown point during the…NTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…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 ANC89LA176Accident · No injuriesLimited investigationFinal reportCessna 185 · Trading Bay, AKPilot in commands failure to perform an adequate visual approach resulting in collision with a tree.NTSB ANC89DAG02Accident · 1 fatalFinal reportEvanson Long EZ/52 · Palmer, AKPilot-in-command's failure to maintain the proper altitude.NTSB LAX89LA331Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproper in-flight planning/decision by the instructor pilot (CFI). Factors related to the accident were: the cfi's lack of familiarity with the geographic area, and the fence.NTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).NTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.NTSB LAX89LA324Accident · 2 fatalLimited investigationFinal reportHughes 269A · AganaInadequate visual lookout by the pilot, which resulted in his failure to see-and-avoid the power line. The power line was a related factor.