NTSB investigations, CA
5 cases where the first occurrence was “Altitude deviation,uncontrolled”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1998 | 1 |
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\" = 110)
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" = 110) 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 LAX98FA169Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas DC-10-10 · Los Angeles, CAThe contaminated strain gage, which resulted in shorting of the strain gage's terminal lugs which lead to excessive autopilot initiated elevator movement, and excessive elevator actuation during recovery by the captain. Contributing factors were the failure…NTSB LAX87FA087Accident · 1 fatalField investigationFinal reportCessna 208 · Cima, CAWhile on a day/vfr flt from ontario, CA to las vegas, NV, the acft collided with mountainous terrain near the top of a 6500' peak. Radar data showed that aprx 20 min before the acdnt, the acft began a gradual dscnt from about 10,000'. No preimpact part…NTSB LAX86LA312Accident · No injuriesLimited investigationFinal reportMooney M20F · Cloverdale, CAThe acft collided with wires following a loss of control. The plt indicated that he was following a river at 1,500 ft MSL at a slow airspeed when the stall warning sounded. The plt stated that he lowered the nose in a downdraft and recovered close to the…NTSB LAX85LA155Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Santa Barbara, CAStudent plt stated that while flying the last leg of a solo cross country flight he was flying along the coast at 50 to 75 feet, he diverted his attention to look at the a man on the beach and when he looked back at the instruments he noticed the helicopter…NTSB LAX84FA429Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Julian, CAAfter takeoff several 360 deg climbing turns were made to gain alt to clear the mountain ridge. The ridge was approached at 4800 ft MSL with the plt expecting a thermal lift over the 5500 ft level which had been encountered many times before. At 4800 ft MSL…