NTSB investigations, 1991
23 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 30 |
|---|---|
| 1983 | 14 |
| 1984 | 26 |
| 1985 | 25 |
| 1986 | 29 |
| 1987 | 25 |
| 1988 | 18 |
| 1989 | 19 |
| 1990 | 23 |
| 1991 | 23 |
| 1992 | 12 |
| 1993 | 13 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 17 |
| 1997 | 15 |
| 1998 | 15 |
| 1999 | 17 |
| 2000 | 19 |
| 2001 | 7 |
| 2002 | 10 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 11 |
| 2006 | 8 |
| 2007 | 9 |
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\") = 1991
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\" = 270)
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") = 1991 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" = 270) 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 SEA92FA026Accident · 7 fatalField investigationFinal reportCessna 172P · Snohomish, WAA visual lookout was not maintained.NTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.NTSB SEA92FA022Accident · Serious injuriesField investigationFinal reportCessna 150E · Vancouver, WAInadequate visual lookout on the part of the pilot as well as both the flight instructor and student of the other aircraft. A factor contributing to the accident was the other pilot's lack of landing light usage.NTSB FTW92FA025Accident · No injuriesField investigationFinal reportBeech B19 · Forth Worth, TXInadequate visual lookout by the pilots-in-command of both aircraft, which resulted in their failure to see-and-avoid the other aircraft. A factor related to the accident was: failure of the developmental controller or the supervisor to provide adequate…NTSB MIA92FA012Accident · 1 fatalField investigationFinal reportCessna 177 · Green Cove Spgs, FLThe pilot in command's failure to maintain a visual lookout.NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.NTSB CHI91LA270Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Watertown, SDAttempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.NTSB FTW91FA131Accident · 1 fatalField investigationFinal reportSchempp-Hirth DISCUS-B · Medina, TXThe failure of the pilot in command to maintain an adequate visual lookout. A factor was collision induced incapacitation.NTSB CHI91FA235Accident · 2 fatalField investigationFinal reportAero Commander 500B · Silica, KSThe failure of both pilots to maintain adequate separation during formation flight. Related factors are overconfidence in personal ability and poor planning/decision.NTSB CHI91FA212Accident · Serious injuriesField investigationFinal reportCentrair Pegasus 101B · Hinckley, ILThe failure of both pilots to maintain adequate visual lookout and ensure adequate separation during traffic pattern operations. A related factor is the non-standard uncontrolled airport procedures used by N126CC.NTSB CHI91FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Quincy, ILThe failure by the pilot of the other airplane to maintain clearance. Factors in the accident were the pilot's attempt to fly formation, his inadequate group briefing, and the lack of experience on the part of the pilot of the other airplane.NTSB ATL91FA117Accident · 2 fatalField investigationFinal reportFuji LM 1 · Keystone Hghts, FLFailure of the number four pilot (in N2100J) to maintain adequate visual lookout and/or clearance from the number three aircraft (N2109L).NTSB ATL91FA108Accident · 2 fatalField investigationFinal reportCessna T37B · Chickamauga, GAThe T-37 pilot misjudged the clearance between his aircraft and the A-26.NTSB LAX91LA204Accident · 1 fatalLimited investigationFinal reportAyres S2RT34 · Marysville, CAThe pilots' inadequate visual lookout for other air traffic.NTSB FTW91FA074Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-20 · Kenefic, OKImproper planning/decision by the pilots of both aircraft, and the Mitsubishi pilot's misjudgment of his position, while attempting to fly formation at night with an aircraft that did not have all navigation lights operative. Factors related to the accident…NTSB DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.NTSB CHI91LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDInadequate visual outlook by the pilot in command.NTSB NYC91LA113Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Pleasant Valley, NYThe failure of the pilot of N5232K to maintain visual contact and separation with N9763U.NTSB ANC91FA050Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Tatitlek, AKFailure of both pilots to see-and-avoid each other (inadequate visual lookout). A factor related to the accident was: inadequate communication among all participating aircrews.NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…NTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.NTSB LAX91FA098Accident · 2 fatalField investigationFinal reportBell 206B · Santa Paula, CAInadequate visual lookout by the Bell 206B pilot, which resulted in his failure to see-and-avoid the pitts S-2A. A factor related to the accident was: the S-2A pilot's restricted visibility from the tailwheel equipped airplane, once it was in position on the…NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.