NTSB investigations, 2001
15 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\") = 2001
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") = 2001 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 FTW02LA047Accident · No injuriesLimited investigationFinal reportCurtiss-Wright SB2C-5 · New Orleans, LAthe Helldiver pilot's failure to maintain visual separation with the Cessna while taxiing. Contributing factors were the Cessna pilot's failure to comply with the local controller's instructions to continue taxiing and the failure of the local and ground…NTSB LAX02LA034Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401B · Las Vegas, NVthe failure of the AT-401 pilot to maintain clearance with the AT-402 airplane during landing. Contributing factors were the unreliable communication radio in the AT-401, the AT-401 pilot's continued flight with known communication radio problems, and the…NTSB FTW02LA024Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Giddings, TXThe failure of the Cessna pilot to maintain directional control while landing, which resulted in a collision with the Lake.NTSB LAX02LA009Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chandler, AZThe Bellanca pilot's failure to maintain directional control while taxiing due to his improper brake usage.NTSB LAX02FA004Accident · No injuriesField investigationFinal reportPiper PA-28-140 · Van Nuys, CAThe failure of the air traffic controller to provide effective separation on the runway surface as specified in FAA Order 7110.65, Paragraph 3-9-6.NTSB NYC02LA006Accident · No injuriesLimited investigationFinal reportPierce Bushby Mustang II · W Hampton Beach, NYThe pilot's inadequate lookout during the taxi.NTSB MIA01LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe failure of the pilot of N89803 to insure his brakes were set and that the airplane was not rolling prior to diverting his attention to duties inside the cockpit, resulting in N89803 rolling forward and colliding with N8660Q which was parked in front of…NTSB ATL01LA073Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Belleview, FLThe pilot of the Christian Ealge II, N321JK, failure to maintain visual look out, prior to takeoff.NTSB IAD01LA062Accident · No injuriesLimited investigationFinal reportEaa Chapter 40 Cubby Sport Trainer · Elkton, MDThe Cubby pilot's inadequate visual lookout for the Bellanca on the runway, prior to landing.NTSB LAX01LA172Accident · No injuriesLimited investigationFinal reportBell 206B · San Diego, CAthe failure of the ground personnel to maintain clearance between two aircraft on the ramp, while one airplane was taxiing and the other was standing with the engine running and rotor blades turning.NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.NTSB FTW01LA071Accident · No injuriesLimited investigationFinal reportBeech 58 · Shreveport, LAthe pilot's failure to maintain visual separation with a parked airplane while taxing. Contributory factors were the dark night light conditions, the rain, and the non-lighted ramp area where the unoccupied airplane was parked.NTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…NTSB NYC01LA075Accident · No injuriesLimited investigationFinal reportBoeing B-737-832 · Boston, MAThe inadequate visual lookout by theMD-81's tug driver during the pushback operation.NTSB LAX01LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · San Luis Obispo, CAThe failure of the other pilot to ensure adequate taxi clearance between aircraft.