Skip to content

NTSB investigations, CA

23 cases where the first occurrence was “On ground/water encounter with weather”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 330) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 330)
  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" = 330)
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 LAX07CA018Accident · No injuriesData collectionFinal reportCodding/Fluno Sportsman GS-2 · Hopland, CAthe pilot's excessive braking during landing roll, which resulted in the airplane nosing over. A contributing factor was the erroneous windsock indication, which prompted the pilot to land with a tailwind, and inadvertently increase his landing roll.Oct 20, 2006 · N429AD · Substantial damage NTSB LAX05CA287Accident · No injuriesData collectionFinal reportCessna A185E · San Andreas, CAthe pilot's failure to maintain directional control of the airplane upon encountering a dust devil during the takeoff roll.Sep 1, 2005 · N1644M · Substantial damage NTSB LAX97LA231Accident · Minor injuriesLimited investigationFinal reportCessna P206B · Desert Center, CAThe pilot's unexpected encounter with dust devils during the takeoff ground roll.Jul 4, 1997 · N4733F · Destroyed NTSB LAX97LA083Accident · No injuriesLimited investigationFinal reportCessna 182H · Burbank, CAthe pilot's improper planning/decision concerning landing and taxiing in high wind conditions. Factors relating to the accident were: the unfavorable wind conditions, and the lack of crosswind limit information in the Cessna 182H Pilot's Operating Handbook…Jan 6, 1997 · N1870X · Substantial damage NTSB LAX91LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe failure of the pilot to employ proper flight control positioning to maintain control of the airplane during taxi.Jun 3, 1991 · N12447 · Substantial damage NTSB LAX91LA208Accident · No injuriesLimited investigationFinal reportCessna C172M · Coalinga, CAThe pilot's encounter with a dust devil which resulted in his loss of control during landing rollout.May 11, 1991 · N73001 · Substantial damage NTSB LAX90LA273Accident · No injuriesLimited investigationFinal reportCessna 172P · Mammoth Lakes, CAInadvertent encounter with high velocity winds.Aug 1, 1990 · N51872 · Substantial damage NTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.Jun 4, 1990 · N21Y · Substantial damage NTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.Apr 15, 1990 · N9394C · Substantial damage NTSB LAX89LA306Accident · No injuriesLimited investigationFinal reportCessna A185F · Big Bear City, CAThe pilot's inadequate compensation for the unfavorable wind conditions.Sep 8, 1989 · N252W · Substantial damage NTSB LAX89LA090Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Huntington Bch, CAThe pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors.Jan 18, 1989 · N58072 · Substantial damage NTSB LAX88LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Tracy, CAThe surface wind was strong when the pilot began taxiing for takeoff. He did not obtain a preflight weather briefing for the flight. As the aircraft taxied from behind a hangar the strong wind lifted one of the wings and the aircraft rolled over on its back.Dec 12, 1987 · N734YZ · Substantial damage NTSB LAX88DUQ02Accident · Minor injuriesFinal reportIsgrigg Elite · Tehachapi, CAThe homebuilt gyroplane became uncontrollable during take-off roll on runway 27R. The aircraft pitched up and then rolled on its left side. The national weather service reported the winds in the area at the time of the accident to be from 290 degrees at 12-15…Nov 21, 1987 · N333JE · Substantial damage NTSB LAX87LA162Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Paula, CAAt the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the…Mar 30, 1987 · N6339K · Substantial damage NTSB LAX87LA159Accident · No injuriesLimited investigationFinal reportJones Pitts Special S1A · Franklin, CADuring the landing roll, the pilot was unable to maintain directional control when a gust of wind from the right pushed the aircraft off the left side of the runway. The aircraft collided with the terrain and nosed over. There was no mechanical failure or…Mar 29, 1987 · N9GD · Substantial damage NTSB LAX86LA274Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ukiah, CAThe Piper PA-18-150 encountered turbulent wind conditions and dragged the left wing during a takeoff ground run from rwy 33. The plt reported that during the takeoff ground run, the right wing lifted causing the left wing to drag on the rwy. The aircraft then…Jun 30, 1986 · N2406J · Substantial damage NTSB LAX86LA150Accident · No injuriesLimited investigationFinal reportCessna 172M · Rosamond, CAThe plt reported that he successfully touched down during conditions of a right, 90 deg. Crosswind. The plt stated that a gust was then encountered which 'weather cocked' his acft. As he attempted to realign the acft with the rwy the downwind wing contacted…Apr 3, 1986 · N666BH · Substantial damage NTSB LAX86LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Apple Valley, CAA Cessna 172N nosed over on the taxiway after completing a full stop ldg on the rwy. Winds were reported from 180 deg at 18 KTS gusting to 23 KTS with peak gusts from the se at 31 KTS. UNICOM reported winds from the s at 20 KTS gusting to 30 KTS. The plt had…Mar 15, 1986 · N739GB · Substantial damage NTSB LAX85LA149Accident · No injuriesLimited investigationFinal reportCessna 172G · Mojave, CAPrior to landing the plt was advised of wind gusts as high as 68 KTS. Plt landed & while taxiing to the ramp a gust of wind was experienced which blew the acft over to an inverted position.Feb 20, 1985 · N1112F · Substantial damage NTSB LAX84LA226Accident · No injuriesLimited investigationFinal reportCessna 172K · Lancaster, CAThe acft was blown over as it turned crosswind in gusts up to 40 KTS. The plt said he was using the procedures for taxiing in wind conditions. The Cessna 172 is limited to a 15 kt crosswind component for takeoff.Mar 21, 1984 · N78178 · Substantial damage NTSB LAX84LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Mammoth Lakes, CAThe plt reported that the acft was blown over as he taxied for takeoff. Also, he reported the wind to be from 200 degrees at 20 KTS. The recorded wind from 180 degrees at KTS gusting to 40 KTS. The maximum demonstrated crosswind component for this acft is 15…Feb 13, 1984 · N3194R · Substantial damage NTSB LAX84LA075Accident · No injuriesLimited investigationFinal reportCessna 180 · Ocotillo Wells, CAThe plt reported that during arrival, he checked for the wind conditions & there appeared to be a light x-wing of appx 5 to 8 KTS. However, while on the landing roll, he encounter an unexpected wind that yawed the acft to the left. Subsequently, the acft…Nov 26, 1983 · N4509B · Substantial damage NTSB LAX82DA206Accident · No injuriesFinal reportCessna 172 · Mojave, CAWhile the pilot was boarding the aircraft, 2 linemen were holding the wings down. During taxi, the pilot was having difficulty controlling the aircraft. As the aircraft was turning to the runway heading, the wind raised the right wing, the spinning prop hit…May 8, 1982 · N5111E · Substantial damage