NTSB investigations, 1998
11 cases where the first occurrence was “Collision between aircraft (other than midair)”.
Cases per year
| 1994 | 7 |
|---|---|
| 1995 | 12 |
| 1996 | 15 |
| 1997 | 12 |
| 1998 | 11 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 15 |
| 2002 | 8 |
| 2003 | 10 |
| 2004 | 6 |
| 2005 | 10 |
| 2006 | 6 |
| 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\") = 1998
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\" = 271)
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") = 1998 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" = 271) 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 LAX99LA059Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · North Las Vegas, NVFailure of the pilot-in-command of the other aircraft to see and avoid the stationary Cessna TR182.NTSB LAX99LA069Accident · No injuriesLimited investigationFinal reportCessna 182G · San Andreas, CAThe other pilot's failure to maintain an adequate visual lookout while taxiing in a confined area between rows of parked aircraft.NTSB IAD99LA022Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Easton, MDThe failure of both the pilot-in-command (CFI) and dual student of the other aircraft (Pitts) to maintain adequate visual lookout.NTSB CHI99LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Brainerd, MNThe visual lookout not obtained/maintained by the pilot of the other aircraft. Contributing factors were the unicom frequency not selected and the traffic advisory not issued by the pilot of the other aircraft. An additional factor was the aircraft moving on…NTSB ANC99FA012Accident · Minor injuriesField investigationFinal reportBoeing 747-400 · Anchorage, AKThe excessive taxi speed by the pilot of the other aircraft. A factor associated with the accident was the other pilot's inadequate maneuver to avoid the parked airplane.NTSB LAX99LA025Accident · No injuriesLimited investigationFinal reportde Havilland Tiger Moth DH 82A · Petaluma, CAFailure of the pilot in the Tiger Moth to see and avoid traffic. A contributing factor was the delayed reaction of the student pilot in the Cessna to initiate a turnoff of the taxiway once it became apparent that the other airplane did not see him.NTSB LAX98LA302Accident · No injuriesLimited investigationFinal reportBognuda Livio IV Lancair · Reno, NVThe failure of the pilot-in-command to maintain adequate visual surveillance of the taxiway in front of his aircraft to avoid the collision.NTSB CHI98LA297Accident · No injuriesLimited investigationFinal reportCessna 180 · Oshkosh, WIthe pilot of the other airplane did not maintain proper clearance.NTSB FTW98LA317Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXThe inadequate visual lookout by the pilots of both airplanes.NTSB CHI98LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Lincoln, NEthe pilot of N60BH failed to maintain clearance with N11498. Factors associated with the accident were the diminished visual lookout due to the runway and the tail wheel configuration of N60HB, along with the controllers failure to point out traffic.NTSB MIA98LA111Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Sanford, FLThe failure of the pilot of N101DT to maintain a visual lookout during the taxi phase of his flight and the failure of the ground controller to issue a traffic advisory to N101DT about the location of N6285M.