NTSB investigations: NONE, PA
6 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with object”. 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
| 1983 | 1 |
|---|---|
| 1993 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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" = 'PA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC07LA114Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · New Holland, PAUnfavorable winds and terrain during a precautionary landing.NTSB NYC06CA150Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Mt. Holly Sprin, PAThe pilot's failure to maintain altitude/clearance from trees along his final approach path.NTSB IAD02LA042Accident · No injuriesLimited investigationFinal reportWSK PZL PW-5 · New Smithville, PAThe pilot's inadequate evaluation of the weather which resulted in the loss of thermal lift and collision with trees.NTSB BFO95LA015Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hilltown, PAImproper in-flight planning decision by the pilot, which resulted in insufficient altitude to maintain clearance from trees.NTSB BFO93LA161Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Eighty Four, PAThe pilot's utilization of improper procedures for setting the altimeter which led to his misjudging altitude.NTSB NYC83LA076Accident · No injuriesLimited investigationFinal reportBurkhart Grob G10Z Astir CS · Buena Vista, PAThinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft…