# NTSB investigations: Cessna 172H, MD

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 IAD00LA061](https://openairdocs.org/ntsb/IAD00LA061.md): Cessna 172H · Friendly, MD · Accident · No injuries · Limited investigation · Final report · Jul 1, 2000 · N1688F · Substantial damage
  > the student pilot's inadequate compensation for winds that resulted in his failure to maintain runway alignment and a hard landing.
- [NTSB IAD97LA072](https://openairdocs.org/ntsb/IAD97LA072.md): Cessna 172H · Westminister, MD · Accident · No injuries · Limited investigation · Final report · May 5, 1997 · N3748F · Destroyed
  > The pilot misjudged landing distance on the runway and his failure to perform a go-around.
- [NTSB BFO89LA026](https://openairdocs.org/ntsb/BFO89LA026.md): Cessna 172H · Odenton, MD · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1989 · N8027L · Substantial damage
  > The inflight collision with birds.
- [NTSB BFO88FA003](https://openairdocs.org/ntsb/BFO88FA003.md): Cessna 172H · Indian Head, MD · Accident · 1 fatal · Field investigation · Final report · Oct 16, 1987 · N9WB · Destroyed
  > The non-certificated plt took the acft without proper authority. A note was found in his automobile that showed he intended to commit suicide. A revolver was found at the crash scene with a spent cartridge under the hammer. Postmortem studies showed the pilot…
- [NTSB BFO86FA020](https://openairdocs.org/ntsb/BFO86FA020.md): Cessna 172H · Upper Marlboro, MD · Accident · No injuries · Field investigation · Final report · Mar 12, 1986 · N2780L · Substantial damage
  > Since the fuel gages in the acft were known not to be accurate, the plt measured the amount of fuel in each tank with a dipstick before departing. He determined that he had 18 gallons for the 2 hours of flying he planned to do and based on a fuel consumption…
- [NTSB NYC84LA126](https://openairdocs.org/ntsb/NYC84LA126.md): Cessna 172H · Hagerstown, MD · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1984 · N2477L · Substantial damage
  > The plt initiated a 5 mi straight-in approach. When the acft was within 2 mi of the arpt, the plt reduced power, appliedcarb heat & slowed the acft. When it appeared he was going to land short, he added power, but the eng would not respond. The acft was…
- [NTSB IAD77FIG21](https://openairdocs.org/ntsb/IAD77FIG21.md): Cessna 172 · College Park, MD · Accident · Minor injuries · Closed · Jun 25, 1977 · N2477L · Substantial damage
- [NTSB IAD71AI050](https://openairdocs.org/ntsb/IAD71AI050.md): Cessna 172H · Hollywood, MD · Accident · 1 fatal · Closed · May 8, 1971 · N2658L · Destroyed
- [NTSB IAD71FIG26](https://openairdocs.org/ntsb/IAD71FIG26.md): Cessna 172 · College Park, MD · Accident · Serious injuries · Closed · Mar 28, 1971 · N3704R · Substantial damage
- [NTSB DIA67D0083](https://openairdocs.org/ntsb/DIA67D0083.md): Cessna 172 · Cambridge, MD · Accident · No injuries · Closed · Apr 21, 1967 · N1713F · Substantial damage

## 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" = 'MD' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072424&state=MD

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