# NTSB investigations, 2012, FL: Aircraft maintenance event

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 ERA13LA048](https://openairdocs.org/ntsb/ERA13LA048.md): Cirrus Design SR22 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Oct 21, 2012 · N6839R · Substantial damage
  > A main landing gear wheel fire for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operations.
- [NTSB ERA12LA524](https://openairdocs.org/ntsb/ERA12LA524.md): Piper PA-32R-301T · Riverview, FL · Accident · No injuries · Limited investigation · Final report · Aug 23, 2012 · N362DM · Substantial damage
  > Damage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.
- [NTSB ERA12LA494](https://openairdocs.org/ntsb/ERA12LA494.md): Piper PA-44-180 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Aug 1, 2012 · N740FT · Substantial damage
  > Inadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.
- [NTSB ERA12LA366](https://openairdocs.org/ntsb/ERA12LA366.md): Bell 206B · Longboat Key, FL · Accident · No injuries · Limited investigation · Final report · May 25, 2012 · N806LA · Substantial damage
  > Unknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.
- [NTSB ERA12CA278](https://openairdocs.org/ntsb/ERA12CA278.md): Piper PA-18A · West Palm Beach, FL · Accident · Minor injuries · Data collection · Final report · Apr 12, 2012 · N12003 · Substantial damage
  > The inadequate assembly of the brakes, which caused them to lock during the landing roll when the airplane transitioned from asphalt to turf, resulting in the airplane nosing over.
- [NTSB ERA12LA234](https://openairdocs.org/ntsb/ERA12LA234.md): Cessna 172K · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 2012 · N79509 · Substantial damage
  > A total loss of engine power due to the improper installation of the crankshaft gear bolt or lockplate by maintenance personnel. Contributing to the accident was the lack of suitable terrain for a forced landing.
- [NTSB ERA12LA219](https://openairdocs.org/ntsb/ERA12LA219.md): Cirrus Design SR22 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Mar 9, 2012 · N444VR · Substantial damage
  > The inadequate servicing and maintenance of the engine and the airplane owner and maintenance personnel's disregard of the manufacturer's recommended engine overhaul schedule and service bulletins, which resulted in an in-flight internal failure and seizure…

## 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 year(c."eventDate") = 2012
  AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/040/sequence?state=FL&year=2012

---
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.