Skip to content

NTSB investigations, CA

17 cases where the first occurrence was “Nose gear collapsed”.

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" = 192) 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\" = 192)
  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" = 192)
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 LAX07LA136Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CACollapse of the landing gear for undetermined reasons.Apr 1, 2007 · N81PC · Substantial damage NTSB LAX00LA137Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Oakland, CAThe inadvertent porpoise and improper remedial action of the pilot during the landing attempt.Jan 26, 2000 · N228ER · Substantial damage NTSB LAX97LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Redlands, CAthe pilot's improper landing flare and recovery from a subsequent bounced landing.Nov 23, 1996 · N6096Q · Substantial damage NTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.Feb 29, 1996 · N2132F · Substantial damage NTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.Oct 12, 1994 · N8154C · Substantial damage NTSB LAX93LA374Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Columbia, CAthe pilot's improper use of the elevator control during the takeoff ground roll which resulted in a porpoise and nose gear collapse. A factor in the accident was the pilot's low total experience and lack of total time in type.Sep 26, 1993 · N3561H · Substantial damage NTSB LAX93LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeport, CAthe student pilot's misjudging the landing flare altitude. A factor relating to this accident was the student pilot's lack of total experience.Apr 28, 1993 · N6273Q · Substantial damage NTSB LAX90LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot not flaring for the touchdown.Jul 1, 1990 · N89756 · Substantial damage NTSB LAX89LA085Accident · No injuriesLimited investigationFinal reportCessna TR182 · Oakland, CAPrevious damage due to previous hard landing.Jan 17, 1989 · N5398R · Substantial damage NTSB LAX86LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Salinas, CAThe acft collided with the surface of rwy 13 after the nose gear collapsed. The plt indicated the three green gear safe indicator lights were illuminated prior to touchdown. The acft was landed on the main gear first and then the nose gear. The nose gear…Aug 25, 1986 · N56710 · Substantial damage NTSB LAX86LA261Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAWhile practicing takeoffs and landings on an authorized solo instructional flight the student pilot ballooned and began to porpoise down the runway. On the third nose gear contact with the runway the nose gear collapsed.Jun 22, 1986 · N63437 · Substantial damage NTSB LAX85LA135Accident · No injuriesLimited investigationFinal reportBeech 65 · Camarillo, CAAn inspection of rwy 8 disclosed the acft touched down on the two main gear simultaineously, followed immediately by thecollapse of the nose gear. The acft's nose & both propellers contacted the rwy, with no indication of a yaw. The nose gear actuator ass'y…Feb 10, 1985 · N212Y · Substantial damage NTSB LAX85LA064Accident · No injuriesLimited investigationFinal reportBeech B-60 · Van Nuys, CADuring landing roll out the plt observed the acft's nose gear begin to collapse. Although on approach the plt had placed the ldg gear selector in the down position & had observed the illumination of the green gear down lights, the plt responded to the…Dec 9, 1984 · N6023S · Substantial damage NTSB LAX85LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAAccording to the pilot, unforecast wx was encountered in cruise at 6,500 ft. the student became lost and elected to make a precautionary landing in an unimproved field. The nose gear collapsed on touchdown and the acft nosed over coming to rest inverted. No…Oct 27, 1984 · N48809 · Substantial damage NTSB LAX84LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Emigrant Gap, CAThe student & instructor plt (CFI) were on a dual x-country flt. They proceeded to fly to an unattended arpt at Emigrant Gap, CA, which was at an elevation of 5284 ft. after arriving, they circled the arpt & made a low pass over the rwy. They saw tracks on…Feb 27, 1984 · N25592 · Substantial damage NTSB LAX82FA195Accident · Minor injuriesField investigationFinal reportDouglas DC10-10 · San Francisco, CADuring the initial pushback from the gate prior to eng start a loud noise was heard & the acft nose slowly settled onto the tug that was performing the pushback. The captain ordered the acft evacuated using the emergency slides. The upper jaw of the towbar…May 27, 1982 · N1833U · Substantial damage NTSB LAX82FUA13Accident · No injuriesFinal reportCessna 152 · Long Beach, CADuring the landing roll, the nose gear collapsed and the plane veered off the runway. The student pilot and a witness stated that the gear collasped after a normal landing. The nosewheel tire had uneven wear characerics. There was substantial damage to the…Apr 18, 1982 · N5513L · Substantial damage