# NTSB investigations, PA: Fire/smoke (post-impact)

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 CEN18FA144](https://openairdocs.org/ntsb/CEN18FA144.md): Cirrus Design SR22 · Williamsburg, PA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2018 · N451TD · Destroyed
  > The pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…
- [NTSB ERA18LA072](https://openairdocs.org/ntsb/ERA18LA072.md): Cessna P210N · Farmington, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 29, 2018 · N34VF · Substantial damage
  > A total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.
- [NTSB ERA16FA064](https://openairdocs.org/ntsb/ERA16FA064.md): Beech A36 · Farmington, PA · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2015 · N72054 · Destroyed
  > The pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…
- [NTSB ERA15FA171](https://openairdocs.org/ntsb/ERA15FA171.md): Piper PA28 · West Chester, PA · Accident · 2 fatal · Field investigation · Final report · Mar 29, 2015 · N6842W · Destroyed
  > The failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…
- [NTSB ERA11CA340](https://openairdocs.org/ntsb/ERA11CA340.md): Mooney M-20G · Monroeville, PA · Accident · No injuries · Data collection · Final report · Jun 12, 2011 · N6936N · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff.
- [NTSB NYC08FA307](https://openairdocs.org/ntsb/NYC08FA307.md): Lindstrand Balloons 150A · Phoenixville, PA · Accident · 1 fatal · Field investigation · Final report · Sep 7, 2008 · N844LB · Substantial damage
  > The separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…

## 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" = 'PA' 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" = '170' 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/170/sequence?state=PA

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