# NTSB investigations: Lycoming IO-360-L2A, 2018

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 CEN18LA344](https://openairdocs.org/ntsb/CEN18LA344.md): Cessna 172 · Addison, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 18, 2018 · N893JA · Substantial damage
  > The pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.
- [NTSB GAA18CA460](https://openairdocs.org/ntsb/GAA18CA460.md): Cessna 172 · Grand Prairie, TX · Accident · No injuries · Data collection · Final report · Jul 29, 2018 · N24144 · Substantial damage
  > The student pilot’s failure to maintain the runway centerline during takeoff with a crosswind.
- [NTSB GAA18CA425](https://openairdocs.org/ntsb/GAA18CA425.md): Cessna 172 · Batavia, OH · Accident · No injuries · Data collection · Final report · Jul 13, 2018 · N12064 · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a hard landing.
- [NTSB GAA18CA340](https://openairdocs.org/ntsb/GAA18CA340.md): Cessna 172 · Hillsboro, TX · Accident · No injuries · Data collection · Final report · Jun 9, 2018 · N363CK · Substantial damage
  > The pilot’s improper landing flare, which resulted in a bounced landing and subsequent porpoise.
- [NTSB GAA18CA323](https://openairdocs.org/ntsb/GAA18CA323.md): Cessna 172 · Fuquay Varina, NC · Accident · No injuries · Data collection · Final report · Jun 2, 2018 · N1305B · Substantial damage
  > The flight instructor’s failure to maintain adequate clearance from overgrown brush during taxi, which resulted in entanglement with the brush and a subsequent impact with a tree.
- [NTSB GAA18CA313](https://openairdocs.org/ntsb/GAA18CA313.md): Cessna 172 · Payson, AZ · Accident · No injuries · Data collection · Final report · May 30, 2018 · N780JA · Substantial damage
  > The pilot’s failure to maintain yaw control during a short-field takeoff in high-density altitude conditions.
- [NTSB GAA18CA294](https://openairdocs.org/ntsb/GAA18CA294.md): Cessna 172 · Palo Alto, CA · Accident · No injuries · Data collection · Final report · Apr 30, 2018 · N254EK · Substantial damage
  > The pilot’s improper landing flare, which resulted in a hard landing.
- [NTSB GAA18CA163](https://openairdocs.org/ntsb/GAA18CA163.md): Cessna 172 · Bedford, MA · Accident · No injuries · Data collection · Final report · Mar 11, 2018 · N249FS · Substantial damage
  > The pilot’s improper landing flare, which resulted in substantial damage.
- [NTSB GAA18CA150](https://openairdocs.org/ntsb/GAA18CA150.md): Cessna 172 · Kent, OH · Accident · No injuries · Data collection · Final report · Mar 7, 2018 · N103KS · Substantial damage
  > A deer collided with aircraft during landing at night.
- [NTSB ERA18LA094](https://openairdocs.org/ntsb/ERA18LA094.md): Cessna 172 · Ocean City, MD · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 2018 · N615JA · Destroyed
  > The pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.
- [NTSB GAA18CA143](https://openairdocs.org/ntsb/GAA18CA143.md): Cessna 172 · McKinney, TX · Accident · No injuries · Data collection · Final report · Jan 24, 2018 · N9520Z · Substantial damage
  > The student pilot’s improper approach and landing flare, which resulted in a porpoised landing.

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

This list as a web page: https://openairdocs.org/ntsb?engine=41597&year=2018

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