NTSB investigations, CA
21 cases where the first occurrence was “Collision between aircraft (other than midair)”.
Cases per year
| 1994 | 1 |
|---|---|
| 1995 | 2 |
| 1996 | 2 |
| 1998 | 2 |
| 1999 | 3 |
| 2001 | 3 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 LAX08LA004Accident · No injuriesLimited investigationFinal reportYakovlev YAK-50 · El Cajon, CAThe inadequate visual lookout of the pilot of another airplane and his failure to maintain clearance from a taxiing airplane.NTSB SEA07LA101Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Llano, CAThe failure of the other pilot to maintain directional control during landing roll.NTSB SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.NTSB LAX07LA064Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · San Diego, CAFailure of the captain of the other taxiing airplane to maintain clearance from an occupied airplane stopped on the ramp.NTSB LAX06LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAthe failure of the pilot of the other airplane to maintain an adequate clearance from obstacles while taxiing.NTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.NTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.NTSB LAX04LA027Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · San Diego, CAthe pilot of the other airplane's inadvertent application of the rudder pedals rather than the brakes, which resulted in the collision with the Cessna 172R.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 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 LAX01LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · San Luis Obispo, CAThe failure of the other pilot to ensure adequate taxi clearance between aircraft.NTSB LAX00LA060Accident · No injuriesLimited investigationFinal reportPitts S-2B · Santa Ana, CAThe failure of the pilot of the other airplane to maintain an adequate obstruction clearance while taxiing.NTSB LAX99FA218Accident · No injuriesField investigationFinal reportBoeing 747-4F6B · Los Angeles, CAAirport management's failure to ensure that its current operating procedure, which required the arriving airplane to power into the terminal gate, was being used. Also causal was (1) the ground service company's utilization of an outdated arrival procedure…NTSB LAX99LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Madera, CAThe pilot's failure to maintain an adequate visual lookout and to see the stationary airplane on the taxiway ahead.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 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 LAX96LA222Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · San Francisco, CAinadequate visual lookout by the United Airlines tug driver during the pushback operation. Contributing factors were: the driver's reduced ability to observe the American B-767 due to the nighttime condition, and United Airlines management's failure to ensure…NTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.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 LAX94LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R22-B · Stockton, CAA failure of the pilot-in-command of a landing helicopter to maintain sufficient clearance from a second helicopter.