Skip to content

NTSB investigations, NC

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ATL05IA116Incident · Minor injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Greensboro, NCThe inadequate assembly of the nose landing gear selector valve by a parts supplier, which resulted in internal seal damage and a hydraulic leak that led to the collapse of the nose landing gear. A factor was the insufficient information provided by the…Jun 28, 2005 · N623BR · Minor damage NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.Feb 18, 2005 · N1476A · Substantial damage NTSB ATL03LA071Accident · Minor injuriesLimited investigationFinal reportCessna 310F · Reidsville, NCThe failure of maintenance personnel to properly install the nose gear landing door link during an annual inspection that resulted in the failure of the nose gear to fully extend.Mar 30, 2003 · N5810X · Substantial damage NTSB ATL98LA043Accident · Minor injuriesLimited investigationFinal reportWilde Mickey Questair 20 · Greensboro, NCThe improper installation of the nose landing gear strut, which led to the collapse of the nose gear upon touchdown.Feb 15, 1998 · N94FA · Substantial damage NTSB ATL94LA096Accident · No injuriesLimited investigationFinal reportBeech 23-C23 · Knightdale, NCThe pilot's improper landing flare that resulted in the collapse of the nose landing gear.May 6, 1994 · N6660R · Substantial damage NTSB ATL89LA205Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Hertford, NCPilot's failure to properly flare the airplane during landing. Factors contributing to the accident were the high obstructions at both ends of the runway.Aug 31, 1989 · N5796V · Substantial damage NTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.Dec 13, 1987 · N6258S · Substantial damage NTSB ATL86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCStudent pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced…Dec 6, 1985 · N44687 · Substantial damage NTSB ATL85LA025Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600A · Charlotte, NCDuring final approach the pilot was unable to lower the nose gear therefore he landed with the nose gear retracted. Post crash examination revealed that the nose steering actuating bolt was fractured. The facture surfaces exhibited signatures of a progressive…Nov 1, 1984 · N90609 · Substantial damage NTSB ATL84LA132Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Charlotte, NCUpon landing the nose landing gear sheared off the acft. Exam of the nose gear revealed that two fatigue cracks had propogated to the point of total failure. The gear was the subject of an airworthiness directive that required inspection of the gear…Mar 23, 1984 · N5HE · Substantial damage