# NTSB investigations, AL: Nose gear collapsed

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ATL07CA126](https://openairdocs.org/ntsb/ATL07CA126.md): Rans RV-9A · Harvest, AL · Accident · No injuries · Data collection · Final report · Sep 12, 2007 · N269RV · Substantial damage
  > The pilot's improper landing flare and touchdown.
- [NTSB ATL84LA034](https://openairdocs.org/ntsb/ATL84LA034.md): Cessna 150A · Dauphin Island, AL · Accident · No injuries · Limited investigation · Final report · Oct 29, 1983 · N6673T · Substantial damage
  > The acfts nose gear collapsed during landing. The student plt was on a solo training mission to practice landings. The plt said he made a normal landing and as the nose gear was lowered he added slight right rudder to hold a roll parallel to the rwy…
- [NTSB ATL83LA166](https://openairdocs.org/ntsb/ATL83LA166.md): Beech C-23 · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1983 · N6022Y · Destroyed
  > The acft nose gear collapsed during landing on a student solo flt. The student and CFI flew a dual flt first and some airwork and 3 landings were accomplished. The 1st landing after the CFI got out of the acft was nose first with a bounceand a go-around. This…
- [NTSB ATL82DA157](https://openairdocs.org/ntsb/ATL82DA157.md): Cessna 150F · Monroeville, AL · Accident · No injuries · Final report · Jun 6, 1982 · N8780S · Substantial damage
  > After 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,…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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" = 'AL' 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
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=192&state=AL

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
