NTSB investigations, 2019
105 cases where the sequence of events included Loss of engine power (partial).
Cases, newest first
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\") = 2019
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2019 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ENG19WA009Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…NTSB CEN19LA071Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Beechwood, WIA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Salt Lake City, UTA partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.NTSB ENG21WA016Incident · No injuriesClass 5 · ForeignBoeing 737 · Lagos, NigeriaNTSB ENG19WA010Incident · No injuriesForeign investigationAirbus A320 · Chennai, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…