NTSB investigations
11 cases where NTSB found Placards and markings.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 2 |
| 2018 | 1 |
| 2021 | 2 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010111')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010111')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB CEN21LA145Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Mxii · Hattiesburg, MSThe total loss of engine power for undetermined reasons and the pilot’s failure to maintain clearance from the trees during the subsequent forced landing resulting in an impact with trees and terrain.NTSB CEN18LA209Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Longview, TXThe pilot's failure to use carburetor heat for takeoff, which resulted in an interruption of continuous fuel flow to the engine and a loss of engine power during climb. Also causal was the lack of required placarding warning of the need to use full carburetor…NTSB CEN15LA436Accident · No injuriesLimited investigationFinal reportBeech C35 · Belen, NMThe total loss of engine power due to contamination in the fuel system.NTSB WPR15LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · Santa Maria, CAThe engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…NTSB ERA13LA053Accident · No injuriesLimited investigationFinal reportCessna 210 · Jasper, GAA loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…NTSB ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…NTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.NTSB ERA09LA370Accident · Serious injuriesLimited investigationFinal reportMichael J. Kohout Glassair III · Manassas, VAThe pilot's failure to maintain aircraft control while attempting an emergency landing after takeoff. Contributing to the accident was the pilot's inadequate preflight inspection and distraction due to a separated fuel cap in flight.NTSB ERA09LA357Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Chipley, FLA partial loss of power due to the use of automotive gasoline that contained ethanol, which was prohibited by the operating limitations. Contributing to the accident was the pilot/owner's failure to obtain and comply with the applicable operating limitations.NTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…