NTSB investigations: Cessna 150L, IA
19 cases on aircraft the registry lists as Cessna 150L. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1972 | 5 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1982 | 2 |
| 1986 | 1 |
| 1995 | 1 |
| 2010 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\" = 'IA' 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 ('2071826'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" = 'IA' 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 ('2071826'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.NTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.NTSB MKC86LA125Accident · No injuriesLimited investigationFinal reportCessna 150L · Nevada, IAWitnesses stated that the student appeared nervous while performing the preflight inspection for what was to be her second supervised solo flight. After engine start and initial taxi, the student began to exercise the throttle in an erratic fashion, sometimes…NTSB MKC82DA114Accident · No injuriesFinal reportCessna 150L · Clarinda, IAThe student pilot flared too high during landing, added power and raised the flaps. The aircraft stalled and landed nose and wingtip first and came to rest off the left side of the runway at midfield.NTSB MKC82DA067Accident · No injuriesFinal reportCessna 150 · Nevada, IAAfter returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the…NTSB MKC80FCD08Accident · No injuriesClosedCessna 150 · Maquoketa, IANTSB MKC78FCD26Accident · No injuriesClosedCessna 150 · Ladora, IANTSB MKC78FCD23Accident · Serious injuriesClosedCessna 150L · Des Moines, IANTSB MKC77FCD16Accident · No injuriesClosedCessna 150 · West Union, IANTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IANTSB MKC76DCD26Accident · No injuriesClosedCessna 150L · New Sharon, IANTSB MKC76IK010Incident · No injuriesClosedCessna 150 · Runnells, IANTSB MKC74DCD26Accident · No injuriesClosedCessna 150 · Laporte City, IANTSB MKC73DCD51Accident · No injuriesClosedCessna 150 · Waterloo, IANTSB MKC73DCD43Accident · No injuriesClosedCessna 150L · Ames, IANTSB MKC73FCD39Accident · No injuriesClosedCessna 172 · Des Moines, IANTSB MKC73AKO29Accident · No injuriesClosedCessna 150L · Ames, IANTSB MKC73DCD11Accident · No injuriesClosedCessna 150 · Fort Dodge, IANTSB MKC72DCD52Accident · No injuriesClosedCessna 150L · Garner, IA