NTSB investigations, 2002, CA
7 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 12 |
| 1984 | 7 |
| 1985 | 10 |
| 1986 | 4 |
| 1987 | 8 |
| 1988 | 7 |
| 1989 | 10 |
| 1990 | 9 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 6 |
| 1994 | 8 |
| 1995 | 4 |
| 1996 | 6 |
| 1997 | 1 |
| 1998 | 9 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 7 |
| 2003 | 1 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 6 |
| 2007 | 3 |
Where
Latest 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 year(c.\"eventDate\") = 2002
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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 year(c."eventDate") = 2002 AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 LAX03LA004Accident · No injuriesLimited investigationFinal reportRans S-12 XL · Los Banos, CAThe loss of engine power for undetermined reasons and his failure to maintain adequate airspeed resulting in a stall. A contributing factor was the pilot's decision to conduct a downwind takeoff.NTSB LAX03GA001Accident · Serious injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAan engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…NTSB LAX02LA249Accident · Minor injuriesLimited investigationFinal reportArns Spacewalker II · Irvine, CALoss of engine power due to an exhaust system leak and vapor lock.NTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.NTSB LAX02LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Lake Thomas A., CAa partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…NTSB LAX02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Oak Shores, CAthe number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.NTSB LAX02LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lake Los Angele, CAa reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.