NTSB investigations, CA
13 cases where the first occurrence was “Forced landing”.
Cases per year
| 1985 | 1 |
|---|---|
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2001 | 2 |
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\" = 180)
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" = 180) 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 LAX01LA168Accident · Minor injuriesLimited investigationFinal reportBeech BE77 · Riverside, CAThe student pilot's failure to maintain appropriate airspeed and to configure the airplane for climb-out.NTSB LAX01LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Lancaster, CAThe pilot's delay reversing course while flying toward rising terrain in a box canyon. Factors in the accident included a downdraft on the lee side of a ridge forming the box canyon, high density altitude, and the pilot's improper use of flaps.NTSB LAX00LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Concord, CAthe pilot's failure to use a checklist and remove the control gust lock.NTSB LAX95LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe improper supervision of the student pilot by the instructor by allowing the student to inadvertently pull the mixture control handle too far out causing the engine to lose power. The wet terrain condition was a factor.NTSB LAX91LA414Accident · No injuriesLimited investigationFinal reportLet L-13 · Adelanto, CAImproper planning/decision by the pilot. Loss of thermal lift was a related factor.NTSB LAX90LA168Accident · No injuriesLimited investigationFinal reportRobinson R22 · Irvine, CAThe cfi's failure to maintain rotor RPM during the practice autorotation.NTSB LAX89LA234Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hollister, CAFlight instructor's failure to take corrective action in sufficient time to prevent the airplane from striking the ground.NTSB LAX89LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fresno, CAThe pilot's inflight decision to abort the takeoff and land in a field. Contributing to the accident was the fence post that the aircraft collided with during the landing roll.NTSB LAX88LA182Accident · No injuriesLimited investigationFinal reportSlingsby T59D Kestrel 19 · Middletown, CANTSB LAX87LA043Accident · No injuriesLimited investigationFinal reportCessna A150M · Corona, CADuring a local flight, the pilot was practicing a simulated engine out procedure toward an open field on rolling terrain. He stated that he misjudged the rising terrain and got too low and slow to initiate a go-around. Subsequently, he was forced to land.…NTSB LAX86LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Banning, CAThe glider plt lost lift as he flew farther into the mountains with lack of thermal and ridge effect. A landing was attempted which resulted in an overrun into a ravine.NTSB LAX86LA203Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Palmdale, CAThe helicopter landed hard in the desert while on a VFR personal flt. The plt indicated that he just departed a mountian area for refueling. He also indicated he was disoriented and the compass was inoperable. He decided to land and check the fuel quantity.…NTSB LAX85FA111Accident · No injuriesField investigationFinal reportBeech C24R · Riverside, CAAn aborted takeoff was attempted by the plt when the acft failed to sustain flight. He landed on the side of the runway with one wheel in the grass and realized too late that normal braking was not sufficient to stop the landing roll before the acft went over…