NTSB investigations, 1995
12 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\") = 1995
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") = 1995 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 LAX96LA092Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Kailua Kona, HIThe failure of the Waco pilot to see and avoid the opposite direction Cessna 172 while both aircraft were taxiing in a non-movement area of the airport. Factors in the accident were: the congested nature of the taxi lane, which limited the Waco pilot's…NTSB CHI95LA318Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Belvidere, ILinadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.NTSB FTW95LA352Accident · No injuriesLimited investigationFinal reportCessna 172E · Alpine, TXThe failure of the pilots of both airplanes to see and avoid each other. A factor was the Cessna's inoperative radio.NTSB CHI95LA252Accident · No injuriesLimited investigationFinal reportStevens Acro II · Oshkosh, WIthe failure of the pilot of the Acro II, N40LF, to maintain clearance from the Cessna 172, N5542R.NTSB FTW95FA319Accident · No injuriesField investigationFinal reportBoeing 737-3A4 · Dallas, TXFailure of the flightcrews of the Boeing 737, N675AA, and the Cessna 401, N31DB, to see and avoid each other. Factors were: the failure of 737 flightcrew to respond to the traffic advisory given by the ground controller identifying potentially conflicting…NTSB LAX95LA239Accident · No injuriesLimited investigationFinal reportCessna 182A · Paso Robles, CAFailure of the great lakes pilot to see-and-avoid the Cessna 182. The sun glare was a related factor.NTSB LAX95LA194Accident · Serious injuriesLimited investigationFinal reportAero Commander 500S · Santa Barbara, CAthe inadequate visual lookout by both pilots and their failures to maintain adequate separation from each other while taxiing in a non-movement area.NTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.NTSB NYC95IA114Incident · No injuriesIncident investigationFinal reportBoeing 767-383ER · Newark, NJthe pilot of the B-767, LNRCK, misjudged clearance between his airplane and the B-737, N13624, resulting in an on-ground collision.NTSB SEA95LA076Accident · No injuriesLimited investigationFinal reportCessna 402B · Boise, IDFailure of both pilots to perform adequate visual lookout during taxi, and the ground controller's failure to identify the position of the Piper PA-34 before issuing taxi instructions. Factors relating to the accident were: decreased visibility due to…NTSB MIA95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Venice, FLFailure of the globe GC-1B (swift) pilot to see the Piper PA-23 in time to avoid a collision, and the Piper PA-23 pilot's delay in initiating remedial action to avoid the collision.NTSB MIA95LA086Accident · No injuriesLimited investigationFinal reportLockheed L-1011-385 · San Juan, PRThe tug operator of another airplane commencing pushback procedures without clearance to do so from the dispatching agent, resulting in an on-ground collision between both airplanes.