Skip to content

NTSB investigations

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."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.\"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."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 MKC82DA164Accident · No injuriesFinal reportBeech 95-B55 · Goodland, KSThe pilot was on a cross-country flight with a refueling stop at Goodland, KS. During arrival at Goodland, he elected to land on runway 05. There was no evidence that he established radio contact with Goodland flight service, located on the airport, for an…Sep 2, 1982 · N8453N · Substantial damage NTSB FTW82DA292Accident · No injuriesFinal reportCessna 210K · Austin, TXDuring the landing roll, the nose gear collapsed and the aircraft was substantially damaged. The nose gear retraction-extension mechanism had been serviced just prior to this flight and on several other occasions for failing to properly extend or retract.…Jul 22, 1982 · N8218M · Substantial damage NTSB SEA82DA118Accident · No injuriesFinal reportCessna 182C · Near Dixie, IDThe pilot was taking off from a wet, sod airstrip when he elected to abort at about the midway point of the runway. While aborting, the aircraft hit a soft spot in the runway which sheared off the nose gear. Aircraft continued off end of runway and burned.Jul 19, 1982 · N8548T · Destroyed NTSB ATL82DA157Accident · No injuriesFinal reportCessna 150F · Monroeville, ALAfter making a normal landing touchdown, the nosewheel was held off until it lowered naturally. The pilot stated that when the nosewheel touched down, it seemed that the wheel would not turn. At about that time, the nose gear collapsed and the propeller,…Jun 6, 1982 · N8780S · Substantial damage NTSB MIA82DA126Accident · No injuriesFinal reportPiper PA-38-112 · Ft. Pierce, FLAccording to the student pilot, the nose gear collapsed during the takeoff roll after he applied back pressure for a climb attitude at about 60 to 62 knots. He stated that the aircraft did not want to climb, and simultaneously, the nose dropped. An…May 31, 1982 · N9655T · Substantial damage NTSB ANC82DA044Accident · No injuriesFinal reportCessna 150 · Kodiak, AKThe pilot received a weather briefing before takeoff. At that time, the weather at the destination was improving, but was still marginal VFR. The pilot took off and proceeded on a VFR flight plan. While en route, he determined that either his compass or…May 29, 1982 · N1263Q · 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 MKC82IA071Incident · No injuriesIncident investigationFinal reportBeech F33A · Chesterfield, MOWhen the aircraft was returning for landing, the pilot selected gear down and stated that he felt it extend but could not recall seeing the green gear down lights because he was scanning for traffic. Shortly afterwards he experienced a rapid electrical power…May 4, 1982 · N2048Z · Minor damage NTSB MIA82DA108Accident · No injuriesFinal reportBeech 77 · Jacksonville, FLAs the nosewheel touched down during the landing roll, the instructor noted that the wheel was skidding. This was verified when he raised the nosewheel off the ground and the skidding stopped. As the plane decelerated and the nose inevitably dropped, the…Apr 24, 1982 · N37149 · 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 NTSB NYC82DA069Accident · No injuriesFinal reportCessna 310 · Pittsburgh, PAAfter takeoff a loud bang was heard during gear retraction. A fly by the tower confirmed that the nose gear was not in the locked position and all attempts to lock it failed. Touchdown was made on the main landing gear and after the airspeed dissipated to…Apr 7, 1982 · N8039Q · Substantial damage NTSB ATL82DA094Accident · No injuriesFinal reportPiper PA-32-301T · Lexington Park, MDThe pilot stated that while decelerating through approximately 50 knots on landing rollout he lowered the nose. The nose gear collapsed after encountering a soft spot on the runway.Mar 28, 1982 · N81573 · Substantial damage NTSB FTW82IA095Incident · No injuriesIncident investigationFinal reportCessna 402C · Chickasha, OKA checkout was being performed with the PIC in the right seat and the trainee in the left seat. As power was increased for takeoff during a touch and go landing, the PIC heard the propellers strike the runway. The trainee lifted the aircraft off the ground,…Mar 16, 1982 · N6838A · Minor damage NTSB NYC82DA027Accident · No injuriesFinal reportCessna 152 · Ansonia, CTAfter departure from bridgeport on a local instructional flight, it was decided that a landing would be made at the Ansonia airport. The instructor reported that there was no NOTAM concerning hazardous runway conditions at Ansonia. During landing, the…Jan 27, 1982 · N4918H · Substantial damage